public static bool Delete(Guid Id) { bool result = false; DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clFamilyPayment, "Delete", "Delete Method", DayCarePL.Common.GUID_DEFAULT); clConnection.DoConnection(); DayCareDataContext db = new DayCareDataContext(); try { DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clFamilyPayment, "Delete", "Debug Delete Method", DayCarePL.Common.GUID_DEFAULT); SchoolProgramFeesDetail DBSchoolProgram = db.SchoolProgramFeesDetails.FirstOrDefault(s => s.Id.Equals(Id)); if (DBSchoolProgram != null) { db.SchoolProgramFeesDetails.DeleteOnSubmit(DBSchoolProgram); db.SubmitChanges(); result = true; } else { result = false; } } catch (Exception ex) { DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clFamilyPayment, "Delete", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT); result = false; } return(result); }
public static bool SaveProgramWithOtherSchoolYear(Guid OldCurrentSchoolYearId, Guid CurrentSchoolYearId, Guid SchoolId, System.Data.Common.DbTransaction tran, DayCareDataContext dbold) { DayCareDataContext db = dbold; db.Transaction = tran; SchoolProgram DBSchoolProgram = null; SchoolProgramFeesDetail DBSchoolProgramFeesDetail = null; try { /* Guid currentschoolyearid = (from sy in db.SchoolYears * where sy.CurrentId.Equals(true) && sy.SchoolId.Equals(SchoolId) * select sy.Id).SingleOrDefault(); */ Guid currentschoolyearid = CurrentSchoolYearId; List <Guid> lstProgram = (from sp in db.SchoolPrograms where sp.SchoolYearId.Equals(OldCurrentSchoolYearId) && sp.Active.Equals(true) && !(from sp1 in db.SchoolPrograms where sp1.SchoolYearId.Equals(currentschoolyearid) select sp1.ProgUniqueId).Contains(sp.ProgUniqueId) select sp.Id).ToList(); ProgClassRoom DBProgClassRoom = null; foreach (Guid ProgramId in lstProgram) { //try //{ SchoolProgram DBSchoolProgramOld = db.SchoolPrograms.FirstOrDefault(i => i.Id.Equals(ProgramId)); if (DBSchoolProgramOld != null) { DBSchoolProgram = new SchoolProgram(); //DBSchoolProgram = DBSchoolProgramOld; DBSchoolProgram.Id = Guid.NewGuid(); DBSchoolProgram.Title = DBSchoolProgramOld.Title; DBSchoolProgram.Comments = DBSchoolProgramOld.Comments; DBSchoolProgram.Active = DBSchoolProgramOld.Active; DBSchoolProgram.IsPrimary = DBSchoolProgramOld.IsPrimary; DBSchoolProgram.CreatedById = DBSchoolProgramOld.CreatedById; DBSchoolProgram.LastModifiedById = DBSchoolProgramOld.LastModifiedById; DBSchoolProgram.ProgUniqueId = DBSchoolProgramOld.ProgUniqueId; DBSchoolProgram.SchoolYearId = CurrentSchoolYearId; DBSchoolProgram.CreatedDateTime = DateTime.Now; DBSchoolProgram.LastModifiedDatetime = DateTime.Now; db.SchoolPrograms.InsertOnSubmit(DBSchoolProgram); db.SubmitChanges(); //Automatic add to progclassroom change on 28-Aug-2012 by Akash List <Guid> lstProgClass = (from pcr in db.ProgClassRooms where pcr.Active.Equals(true) && pcr.SchoolProgramId.Equals(ProgramId) select pcr.ClassRoomId).ToList(); foreach (Guid ClassroomId in lstProgClass) { DBProgClassRoom = new ProgClassRoom(); DBProgClassRoom.Id = Guid.NewGuid(); DBProgClassRoom.SchoolProgramId = DBSchoolProgram.Id; DBProgClassRoom.ClassRoomId = ClassroomId; DBProgClassRoom.Active = true; DBProgClassRoom.CreatedDateTime = DateTime.Now; DBProgClassRoom.LastModifiedDatetime = DateTime.Now; DBProgClassRoom.CreatedById = DBSchoolProgramOld.CreatedById; DBProgClassRoom.LastModifiedById = DBSchoolProgramOld.LastModifiedById; db.ProgClassRooms.InsertOnSubmit(DBProgClassRoom); db.SubmitChanges(); } } var lstDBSchoolProgramFeesDetailOld = db.SchoolProgramFeesDetails.Where(i => i.SchoolProgramId.Equals(ProgramId)); if (lstDBSchoolProgramFeesDetailOld != null) { foreach (SchoolProgramFeesDetail objSchoolProgramFeesDetails in lstDBSchoolProgramFeesDetailOld) { DBSchoolProgramFeesDetail = new SchoolProgramFeesDetail(); DBSchoolProgramFeesDetail.Id = Guid.NewGuid(); //DBSchoolProgramFeesDetail = objSchoolProgramFeesDetails; DBSchoolProgramFeesDetail.SchoolProgramId = DBSchoolProgram.Id; DBSchoolProgramFeesDetail.Fees = objSchoolProgramFeesDetails.Fees; DBSchoolProgramFeesDetail.FeesPeriodId = objSchoolProgramFeesDetails.FeesPeriodId; DBSchoolProgramFeesDetail.EffectiveYearDate = objSchoolProgramFeesDetails.EffectiveYearDate; DBSchoolProgramFeesDetail.EffectiveMonthDay = objSchoolProgramFeesDetails.EffectiveMonthDay; DBSchoolProgramFeesDetail.EffectiveWeekDay = objSchoolProgramFeesDetails.EffectiveWeekDay; DBSchoolProgramFeesDetail.CreatedById = objSchoolProgramFeesDetails.CreatedById; DBSchoolProgramFeesDetail.LastModifiedById = objSchoolProgramFeesDetails.LastModifiedById; DBSchoolProgramFeesDetail.CreatedDateTime = DateTime.Now; DBSchoolProgramFeesDetail.LastModifiedDatetime = DateTime.Now; db.SchoolProgramFeesDetails.InsertOnSubmit(DBSchoolProgramFeesDetail); db.SubmitChanges(); } } //} //catch //{ } } return(true); } catch (Exception ex) { DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clSchoolYear, "SaveProgramWithOtherSchoolYear", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT); return(false); } }