public static bool Delete(Guid Id, Guid SchoolYearID)
{
bool result = false;
DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clClassRoom, "Delete", "Delete Method", DayCarePL.Common.GUID_DEFAULT);
clConnection.DoConnection();
DayCareDataContext db = new DayCareDataContext();
try
{
DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clClassRoom, "Delete", "Debug Delete Method", DayCarePL.Common.GUID_DEFAULT);
ClassRoom DBClassRoom = db.ClassRooms.FirstOrDefault(c => c.Id.Equals(Id));
ProgClassRoom DBProgClassRoom = db.ProgClassRooms.FirstOrDefault(pc => pc.ClassRoomId.Equals(Id) && pc.ClassRoomSchoolYearId.Equals(SchoolYearID));
ClassRoomSchoolYear DBClassRoomSchoolYear = db.ClassRoomSchoolYears.FirstOrDefault(crsy => crsy.ClassRoomId.Equals(Id) && crsy.SchoolYearId.Equals(SchoolYearID));
if (DBClassRoomSchoolYear != null)
{
db.ClassRoomSchoolYears.DeleteOnSubmit(DBClassRoomSchoolYear);
}
if (DBProgClassRoom != null)
{
db.ProgClassRooms.DeleteOnSubmit(DBProgClassRoom);
db.SubmitChanges();
result = true;
}
if (DBClassRoom != null)
{
db.ClassRooms.DeleteOnSubmit(DBClassRoom);
db.SubmitChanges();
result = true;
}
else
{
result = false;
}
}
catch (Exception ex)
{
DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clClassRoom, "Delete", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
result = false;
}
return(result);
}
public static bool UpdateClassRoomSchoolYearID(Guid SchoolYearId, Guid OldCurrentSchoolYearID, System.Data.Common.DbTransaction tran, DayCareDataContext dbold)
{
DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clClassRoom, "Save", "Execute Save Method", DayCarePL.Common.GUID_DEFAULT);
clConnection.DoConnection();
bool result = false;
//declare trans variable
// System.Data.Common.DbTransaction trans = null;
DayCareDataContext db = dbold;
db.Transaction = tran;
ProgClassRoom DBProgClassRoom = null;
try
{
DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clClassRoom, "Update", "Debug Update Method", DayCarePL.Common.GUID_DEFAULT);
var ClassRoomSchoolYear = (from pcr in db.ProgClassRooms
join sp in db.SchoolPrograms on pcr.SchoolProgramId equals sp.Id
join csy in db.ClassRoomSchoolYears on pcr.ClassRoomSchoolYearId equals csy.Id
where sp.SchoolYearId.Equals(OldCurrentSchoolYearID) && csy.ClassRoomId == pcr.ClassRoomId
select new
{
pcrId = pcr.Id,
csyId = csy.Id
}).ToList();
var cl = ClassRoomSchoolYear;
for (int cnt = 0; cnt < cl.Count(); cnt++)
{
DBProgClassRoom = db.ProgClassRooms.FirstOrDefault(pc => pc.Id.Equals(cl[cnt].pcrId));
if (DBProgClassRoom != null)
{
DBProgClassRoom.ClassRoomSchoolYearId = cl[cnt].csyId;
db.SubmitChanges();
DBProgClassRoom = null;
}
}
}
catch
{
return(false);
}
return(true);
}
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);
}
}
