public static void CreateClassInstance(System.DayOfWeek dayOfWeek) { TblClassInstance classInstance = new TblClassInstance(); TblClassSchedule classSchedule = new TblClassSchedule(); DateTime dateNow = System.DateTime.Today.Date; if (dateNow.DayOfWeek != dayOfWeek) { for (double i = 1; i < 8; i++) { dateNow = dateNow.AddDays(1).Date; if (dateNow.DayOfWeek == dayOfWeek) break; } } for (double i = 0; i < 2; i++) { DateTime date; if (i == 0) date = dateNow; else { double dayToAdd = i * 7; date = dateNow.AddDays(dayToAdd).Date; } int nDay = ConvertDateToNDay(date); DataTable table = classSchedule.SelectAllWnDay(nDay, User.BranchCode); if (table == null || table.Rows.Count == 0) continue; else { foreach (DataRow r in table.Rows) { //DateTime newdate = System.DateTime.(date.Year, date.Month, date.Year); //DateTime dt= System.Convert.ToDateTime(date.ToString("dd/MM/yyyy")); DateTime dtEndTime = ACMS.Convert.ToDateTime(r["dtEndTime"]); DateTime dtStartTime = ACMS.Convert.ToDateTime(r["dtStartTime"]); string strClassCode = r["strClassCode"].ToString(); int nHallNo = ACMS.Convert.ToInt32(r["nHallNo"]); bool createdInstance = classInstance.HaveClassInstance(date, dtEndTime, dtStartTime, strClassCode, nHallNo, User.BranchCode); if (!createdInstance) { classInstance.DtDate = date; classInstance.DtEndTime = ACMS.Convert.ToDateTime(r["dtEndTime"]); classInstance.DtStartTime = ACMS.Convert.ToDateTime(r["dtStartTime"]); classInstance.StrClassCode = ACMS.Convert.ToSqlString(r["strClassCode"]); classInstance.NHallNo = ACMS.Convert.ToSqlInt32(r["nHallNo"]); classInstance.NPermanentInstructorID = ACMS.Convert.ToSqlInt32(r["nInstructorID"]); classInstance.FFree = ACMS.Convert.ToBoolean(r["fFree"]); classInstance.FPeak = ACMS.Convert.ToBoolean(r["fPeak"]); classInstance.FAllowStudentOnPeak = ACMS.Convert.ToBoolean(r["fAllowStudentOnPeak"]); classInstance.FReservation = ACMS.Convert.ToBoolean(r["fReservation"]); classInstance.FPeak = ACMS.Convert.ToBoolean(r["fPeak"]); classInstance.FAllowStudentOnPeak = ACMS.Convert.ToBoolean(r["fAllowStudentOnPeak"]); classInstance.FReservation = ACMS.Convert.ToBoolean(r["fReservation"]); classInstance.NMaxNo = ACMS.Convert.ToSqlInt32(r["nMaxNo"]); classInstance.FAllowUOBBooking = ACMS.Convert.ToBoolean(r["fAllowUOBBooking"]); classInstance.NCommissionTypeID = ACMS.Convert.ToSqlInt32(r["nCommissionTypeID"]); classInstance.StrBranchCode = User.BranchCode; classInstance.FCancelled = System.Data.SqlTypes.SqlBoolean.False; classInstance.Insert(); } } } } }
public static void CreateClassInstance() { TblClassInstance classInstance = new TblClassInstance(); TblClassSchedule classSchedule = new TblClassSchedule(); classInstance.StrClassCode = "GYM"; DataTable temptable = classInstance.SelectAllWstrClassCodeLogic(); if (temptable == null || temptable.Rows.Count == 0) { TblInstructorTypeCommission dummyInstructorTypeCommission = new TblInstructorTypeCommission(); DataTable dummyTable = dummyInstructorTypeCommission.SelectAll(); if (dummyTable.Rows.Count == 0) throw new Exception("Please insert a record in InstructorTypeCommission table."); classInstance.StrClassCode = "GYM"; classInstance.NPermanentInstructorID = User.EmployeeID; classInstance.NCommissionTypeID = ACMS.Convert.ToInt32(dummyTable.Rows[0]["nCommissionTypeID"]); classInstance.StrBranchCode = User.BranchCode; classInstance.DtDate = DateTime.Today.Date; classInstance.DtEndTime = DateTime.Now; classInstance.DtStartTime = DateTime.Now; //classInstance.nClassScheduleID = 0; classInstance.Insert(); } DateTime dateNow = System.DateTime.Now; for (double i = 0; i < 2; i++) { DateTime date; if (i == 0) date = DateTime.Today.Date; else { double dayToAdd = i * 7; date = dateNow.AddDays(dayToAdd).Date; } int nDay = ConvertDateToNDay(date); DataTable table = classSchedule.SelectAllWnDay(nDay, User.BranchCode); if (table == null || table.Rows.Count == 0) continue; else { foreach (DataRow r in table.Rows) { //DateTime newdate = System.DateTime.(date.Year, date.Month, date.Year); //DateTime dt= System.Convert.ToDateTime(date.ToString("dd/MM/yyyy")); DateTime dtEndTime = ACMS.Convert.ToDateTime(r["dtEndTime"]); DateTime dtStartTime = ACMS.Convert.ToDateTime(r["dtStartTime"]); string strClassCode = r["strClassCode"].ToString(); int nHallNo = ACMS.Convert.ToInt32(r["nHallNo"]); bool createdInstance = classInstance.HaveClassInstance(date, dtEndTime, dtStartTime, strClassCode, nHallNo, User.BranchCode); if (!createdInstance) { classInstance.DtDate = date; classInstance.DtEndTime = ACMS.Convert.ToDateTime(r["dtEndTime"]); classInstance.DtStartTime = ACMS.Convert.ToDateTime(r["dtStartTime"]); classInstance.StrClassCode = ACMS.Convert.ToSqlString(r["strClassCode"]); classInstance.NHallNo = ACMS.Convert.ToSqlInt32(r["nHallNo"]); classInstance.NPermanentInstructorID = ACMS.Convert.ToSqlInt32(r["nInstructorID"]); classInstance.FFree = ACMS.Convert.ToBoolean(r["fFree"]); classInstance.FPeak = ACMS.Convert.ToBoolean(r["fPeak"]); classInstance.FAllowStudentOnPeak = ACMS.Convert.ToBoolean(r["fAllowStudentOnPeak"]); classInstance.FReservation = ACMS.Convert.ToBoolean(r["fReservation"]); classInstance.NMaxNo = ACMS.Convert.ToSqlInt32(r["nMaxNo"]); classInstance.FAllowUOBBooking = ACMS.Convert.ToBoolean(r["fAllowUOBBooking"]); classInstance.NCommissionTypeID = ACMS.Convert.ToSqlInt32(r["nCommissionTypeID"]); classInstance.StrBranchCode = User.BranchCode; classInstance.FCancelled = System.Data.SqlTypes.SqlBoolean.False; #region ====== Added by Albert ====== /*To insert class schedule id while creating class instance.*/ classInstance.nClassScheduleID = ACMS.Convert.ToSqlInt32(r["nClassScheduleID"]); #endregion classInstance.Insert(); } } } } }