학원관리 Lesson_Schedule 관리 예제 소스

728x90

학원관리 Lesson_Schedule 관리 예제 소스

 

DeleteLesson_Schedule, DayCancelLesson_Schedule, DeleteLesson_Stay_Schedule

 

public static int DeleteLesson_Schedule(int MemberKey, int UserKey, DateTime Date, int Time)
        {
            int result = 0;

            SqlHelper sql = new SqlHelper(_dbIP, _dbPort, _dbID, _dbPW, _dbName);
            try
            {
                if (!sql.Connect()) return result;

                string strProc = "SP_Lesson_Schedule_Delete";
                System.Diagnostics.Debug.WriteLine(string.Format("{0}", strProc));

                List<SqlParameter> parameters = new List<SqlParameter>();
                parameters.Add(new SqlParameter("@MemberKey", MemberKey));
                parameters.Add(new SqlParameter("@Code", VARS_LOGIN_ACCOUNT.VARS_LOGIN_ACADEMYINFO.code));
                parameters.Add(new SqlParameter("@UserKey", UserKey));
                parameters.Add(new SqlParameter("@Date", Date.ToString("yyyy-MM-dd")));
                parameters.Add(new SqlParameter("@Time", Time));

                result = Convert.ToInt32(sql.ExecuteNonProcedure(strProc, parameters));
            }
            catch (Exception ee)
            {
                TraceManager.AddLog(string.Format("{0}r\n{1}", ee.StackTrace, ee.Message));
                System.Diagnostics.Debug.WriteLine(string.Format("{0}r\n{1}", ee.StackTrace, ee.Message));
            }
            finally
            {
                sql.DisConnect();
            }

            return result;
        }

        public static int DayCancelLesson_Schedule(int MemberKey, int UserKey, DateTime Date, int Time)
        {
            int result = 0;

            SqlHelper sql = new SqlHelper(_dbIP, _dbPort, _dbID, _dbPW, _dbName);
            try
            {
                if (!sql.Connect()) return result;

                string strProc = "SP_Lesson_Schedule_DayCancel_Update";
                System.Diagnostics.Debug.WriteLine(string.Format("{0}", strProc));

                List<SqlParameter> parameters = new List<SqlParameter>();
                parameters.Add(new SqlParameter("@MemberKey", MemberKey));
                parameters.Add(new SqlParameter("@Code", VARS_LOGIN_ACCOUNT.VARS_LOGIN_ACADEMYINFO.code));
                parameters.Add(new SqlParameter("@UserKey", UserKey));
                parameters.Add(new SqlParameter("@Date", Date.ToString("yyyy-MM-dd")));
                parameters.Add(new SqlParameter("@Time", Time));

                result = Convert.ToInt32(sql.ExecuteNonProcedure(strProc, parameters));
            }
            catch (Exception ee)
            {
                TraceManager.AddLog(string.Format("{0}r\n{1}", ee.StackTrace, ee.Message));
                System.Diagnostics.Debug.WriteLine(string.Format("{0}r\n{1}", ee.StackTrace, ee.Message));
            }
            finally
            {
                sql.DisConnect();
            }

            return result;
        }

        public static int DeleteLesson_Stay_Schedule(int MemberKey, int UserKey, DateTime Date, int Time)
        {
            int result = 0;

            SqlHelper sql = new SqlHelper(_dbIP, _dbPort, _dbID, _dbPW, _dbName);
            try
            {
                if (!sql.Connect()) return result;

                string strProc = "SP_Lesson_Stay_Schedule_Delete";
                System.Diagnostics.Debug.WriteLine(string.Format("{0}", strProc));

                List<SqlParameter> parameters = new List<SqlParameter>();
                parameters.Add(new SqlParameter("@MemberKey", MemberKey));
                parameters.Add(new SqlParameter("@UserKey", UserKey));
                parameters.Add(new SqlParameter("@Date", Date.ToString("yyyy-MM-dd")));
                parameters.Add(new SqlParameter("@Time", Time));

                result = Convert.ToInt32(sql.ExecuteNonProcedure(strProc, parameters));
            }
            catch (Exception ee)
            {
                TraceManager.AddLog(string.Format("{0}r\n{1}", ee.StackTrace, ee.Message));
                System.Diagnostics.Debug.WriteLine(string.Format("{0}r\n{1}", ee.StackTrace, ee.Message));
            }
            finally
            {
                sql.DisConnect();
            }

            return result;
        }