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 DayCarePL.Result SaveCheckInCheckOutTime(Guid StaffSchoolYearId, bool CheckInCheckOut, string CheckInCheckOutDateTime)
        {
            clConnection.DoConnection();
            DayCarePL.Result objResult = new DayCarePL.Result();
            objResult.result = "true";
            DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clStaffAttendenceHistory, "SaveCheckInCheckOutTime", "Execute SaveCheckInCheckOutTime Method", DayCarePL.Common.GUID_DEFAULT);
            DayCareDataContext     db = new DayCareDataContext();
            StaffAttendenceHistory DBStaffAttendenceHistory = null;

            try
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clStaffAttendenceHistory, "SaveCheckInCheckOutTime", "", StaffSchoolYearId.ToString());
                DBStaffAttendenceHistory    = new StaffAttendenceHistory();
                DBStaffAttendenceHistory.Id = Guid.NewGuid();
                DBStaffAttendenceHistory.StaffSchoolYearId       = StaffSchoolYearId;
                DBStaffAttendenceHistory.CheckInCheckOut         = CheckInCheckOut;
                DBStaffAttendenceHistory.CheckInCheckOutDateTime = Convert.ToDateTime(CheckInCheckOutDateTime);
                DBStaffAttendenceHistory.CreatedDateTime         = DateTime.Now;
                db.StaffAttendenceHistories.InsertOnSubmit(DBStaffAttendenceHistory);
                db.SubmitChanges();
                objResult.result = "true";
            }
            catch (Exception ex)
            {
                objResult.result = "false";
                DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clStaffAttendenceHistory, "SaveCheckInCheckOutTime", ex.Message.ToString(), StaffSchoolYearId.ToString());
            }
            return(objResult);
        }
예제 #3
0
        public static bool DeleteAdditionalNotes(Guid Id)
        {
            bool result = false;

            DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.AdditionalNote, "Delete", "Delete Method", DayCarePL.Common.GUID_DEFAULT);
            clConnection.DoConnection();
            DayCareDataContext db = new DayCareDataContext();

            try
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.AdditionalNote, "Delete", "Debug Delete Method", DayCarePL.Common.GUID_DEFAULT);
                AdditionalNote DBAdditionalNotes = db.AdditionalNotes.FirstOrDefault(c => c.Id.Equals(Id));
                if (DBAdditionalNotes != null)
                {
                    db.AdditionalNotes.DeleteOnSubmit(DBAdditionalNotes);
                    db.SubmitChanges();
                    result = true;
                }
            }
            catch (Exception ex)
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.AdditionalNote, "Delete", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
                result = false;
            }
            return(result);
        }
예제 #4
0
        public static DayCarePL.Result Save(Guid ChildSchoolYearId, bool CheckInCheckOut, string CheckInCheckOutDateTime)
        {
            clConnection.DoConnection();
            DayCareDataContext db = new DayCareDataContext();

            DayCarePL.Result       objResult = new DayCarePL.Result();
            ChildAttendenceHistory DBChildAttendaceHistory = null;

            try
            {
                DBChildAttendaceHistory    = new ChildAttendenceHistory();
                DBChildAttendaceHistory.Id = System.Guid.NewGuid();
                DBChildAttendaceHistory.ChildSchoolYearId       = ChildSchoolYearId;
                DBChildAttendaceHistory.CheckInCheckOut         = CheckInCheckOut;
                DBChildAttendaceHistory.CheckInCheckOutDateTime = Convert.ToDateTime(CheckInCheckOutDateTime);
                db.ChildAttendenceHistories.InsertOnSubmit(DBChildAttendaceHistory);
                db.SubmitChanges();
                objResult.result = "true";
            }
            catch (Exception ex)
            {
                objResult.result = ex.Message.ToString();
            }
            return(objResult);
        }
예제 #5
0
        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);
        }
예제 #6
0
        public static bool Save(DayCarePL.LedgerProperties objLedger)
        {
            DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clLedgerOfFamily, "Save", "Execute Save Method", DayCarePL.Common.GUID_DEFAULT);
            clConnection.DoConnection();
            DayCareDataContext db       = new DayCareDataContext();
            Ledger             DBLedger = null;

            try
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clLedgerOfFamily, "Save", "Debug Save Method", DayCarePL.Common.GUID_DEFAULT);
                if (objLedger.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
                {
                    DBLedger                 = new Ledger();
                    DBLedger.Id              = Guid.NewGuid();
                    DBLedger.CreatedById     = objLedger.CreatedById;
                    DBLedger.CreatedDateTime = DateTime.Now;
                }
                else
                {
                    DBLedger = db.Ledgers.FirstOrDefault(i => i.Id.Equals(objLedger.Id));
                }
                DBLedger.SchoolYearId         = objLedger.SchoolYearId;
                DBLedger.ChildFamilyId        = objLedger.ChildFamilyId;
                DBLedger.TransactionDate      = objLedger.TransactionDate;
                DBLedger.Debit                = objLedger.Debit;
                DBLedger.Credit               = 0;
                DBLedger.Balance              = objLedger.Debit - objLedger.Credit;
                DBLedger.AllowEdit            = false;
                DBLedger.Comment              = objLedger.Comment;
                DBLedger.LateFee              = objLedger.LateFee; // 1. LateFee 0. No Late Fee
                DBLedger.LastModifiedById     = objLedger.LastModifiedById;
                DBLedger.LastModifiedDatetime = DateTime.Now;
                if (objLedger.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
                {
                    db.Ledgers.InsertOnSubmit(DBLedger);
                }
                db.SubmitChanges();

                try
                {
                    //update closing balance on 10 May 2013 By Akash
                    Guid SchoolId = clSchool.GetSchoolIdbySchoolYearId(objLedger.SchoolYearId.Value);
                    if (clSchoolYear.IsSelectedYearPrevYearORNot(SchoolId, objLedger.SchoolYearId.Value))//only prev year can only allow to edit closing balance. because in current year or in future year closing balance is not genrated in these year
                    {
                        clSchoolYear.UpdateClosingBalance(SchoolId, objLedger.SchoolYearId.Value, objLedger.ChildFamilyId);
                    }
                    //end
                }
                catch { }
                return(true);
            }
            catch (Exception ex)
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clLedgerOfFamily, "Save", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
                return(false);
            }
        }
예제 #7
0
        public static bool Save(DayCarePL.ClassRoomProperties objClassRoom)
        {
            DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clClassRoom, "Save", "Execute Save Method", DayCarePL.Common.GUID_DEFAULT);
            clConnection.DoConnection();
            bool result = false;



            DayCareDataContext db          = new DayCareDataContext();
            ClassRoom          DBClassRoom = null;


            try
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clClassRoom, "Save", "Debug Save Method", DayCarePL.Common.GUID_DEFAULT);
                if (objClassRoom.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
                {
                    DBClassRoom    = new ClassRoom();
                    DBClassRoom.Id = System.Guid.NewGuid();
                }
                else
                {
                    DBClassRoom = db.ClassRooms.SingleOrDefault(D => D.Id.Equals(objClassRoom.Id));
                }
                DBClassRoom.LastModifiedById     = objClassRoom.LastModifiedById;
                DBClassRoom.LastModifiedDatetime = DateTime.Now;
                DBClassRoom.Name     = objClassRoom.Name;
                DBClassRoom.SchoolId = objClassRoom.SchoolId;
                DBClassRoom.MaxSize  = objClassRoom.MaxSize;
                DBClassRoom.Active   = objClassRoom.Active;
                DBClassRoom.StaffId  = objClassRoom.StaffId;

                if (objClassRoom.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
                {
                    db.ClassRooms.InsertOnSubmit(DBClassRoom);
                }



                db.SubmitChanges();


                result = true;
            }
            catch (Exception ex)
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clClassRoom, "Save", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
                result = false;
            }
            finally
            {
            }
            return(result);
        }
예제 #8
0
        public static bool ImportAllActiveChild(Guid SchoolYearId, Guid SchoolId, Guid OldCurrentSchoolYearId, System.Data.Common.DbTransaction tran, DayCareDataContext dbold)
        {
            DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clChildSchoolYear, "ImportAllActiveChild", "Execute ImportAllActiveChild Method", DayCarePL.Common.GUID_DEFAULT);
            clConnection.DoConnection();

            DayCareDataContext db = dbold;

            db.Transaction = tran;
            ChildSchoolYear DBChildSchoolYear = null;

            try
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clChildSchoolYear, "ImportAllActiveChild", "Debug ImportAllActiveChild Method", DayCarePL.Common.GUID_DEFAULT);

                //Guid currentschoolyearid = (from sy in db.SchoolYears
                //                            where sy.CurrentId.Equals(true)
                //                            select sy.Id).SingleOrDefault();

                List <Guid> lstChild = (from c in db.ChildDatas
                                        join csy in db.ChildSchoolYears on c.Id equals csy.ChildDataId
                                        join cf in db.ChildFamilies on c.ChildFamilyId equals cf.Id
                                        where cf.SchoolId.Equals(SchoolId) && csy.active.Equals(true) && csy.SchoolYearId.Equals(OldCurrentSchoolYearId) &&
                                        !(from cy in db.ChildSchoolYears
                                          where cy.SchoolYearId.Equals(SchoolYearId)
                                          select cy.ChildDataId).Contains(c.Id)
                                        select c.Id).ToList();

                //var Data = db.spGetChildIdNotInChildSchoolYear(SchoolId, SchoolYearId);

                foreach (Guid ChildDataId in lstChild)
                {
                    try
                    {
                        DBChildSchoolYear              = new ChildSchoolYear();
                        DBChildSchoolYear.Id           = Guid.NewGuid();
                        DBChildSchoolYear.ChildDataId  = ChildDataId;
                        DBChildSchoolYear.SchoolYearId = SchoolYearId;
                        DBChildSchoolYear.active       = true;
                        db.ChildSchoolYears.InsertOnSubmit(DBChildSchoolYear);
                        db.SubmitChanges();
                    }
                    catch
                    { }
                }

                return(true);
            }
            catch (Exception ex)
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clChildSchoolYear, "ImportAllActiveChild", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
                return(false);
            }
        }
예제 #9
0
        public static bool ImportAllActiveClassRoom(Guid SchoolYearId, Guid SchoolId, Guid OldCurrentSchoolYearId, System.Data.Common.DbTransaction tran, DayCareDataContext dbold)
        {
            DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.ClassRoom, "ImportAllActiveClassRoom", "Execute ImportAllActiveClassRoom Method", DayCarePL.Common.GUID_DEFAULT);
            clConnection.DoConnection();

            DayCareDataContext db = dbold;

            db.Transaction = tran;
            ClassRoomSchoolYear DBClassRoomSchoolYear = null;

            try
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.ClassRoom, "ImportAllActiveClassRoom", "Debug ImportAllActiveClassRoom Method", DayCarePL.Common.GUID_DEFAULT);
                Guid currentschoolyearid = SchoolYearId;
                List <DayCarePL.ClassRoomProperties> lstClassroom = (from cr in db.ClassRooms
                                                                     join sy in db.SchoolYears on cr.SchoolId equals sy.SchoolId
                                                                     where cr.SchoolId.Equals(SchoolId) &&
                                                                     sy.Id.Equals(OldCurrentSchoolYearId) &&
                                                                     !(from crsy in db.ClassRoomSchoolYears
                                                                       where crsy.SchoolYearId.Equals(currentschoolyearid)
                                                                       select crsy.ClassRoomId).Contains(cr.Id)
                                                                     select new DayCarePL.ClassRoomProperties()
                {
                    Id = cr.Id,
                    SchoolYearId = sy.Id,
                    Active = cr.Active,
                    StaffId = cr.StaffId,
                    LastModifiedById = cr.LastModifiedById,
                    Name = cr.Name
                }).ToList();

                foreach (DayCarePL.ClassRoomProperties objClassroom in lstClassroom)
                {
                    DBClassRoomSchoolYear                      = new ClassRoomSchoolYear();
                    DBClassRoomSchoolYear.Id                   = Guid.NewGuid();
                    DBClassRoomSchoolYear.ClassRoomId          = objClassroom.Id;
                    DBClassRoomSchoolYear.SchoolYearId         = SchoolYearId;
                    DBClassRoomSchoolYear.Active               = objClassroom.Active;
                    DBClassRoomSchoolYear.StaffId              = objClassroom.StaffId;
                    DBClassRoomSchoolYear.CreatedById          = objClassroom.LastModifiedById;
                    DBClassRoomSchoolYear.CreatedDateTime      = DateTime.Now.Date;
                    DBClassRoomSchoolYear.LastModifiedById     = objClassroom.LastModifiedById;
                    DBClassRoomSchoolYear.LastModifiedDateTime = DateTime.Now.Date;
                    DBClassRoomSchoolYear.ClassRoomName        = objClassroom.Name;
                    db.ClassRoomSchoolYears.InsertOnSubmit(DBClassRoomSchoolYear);
                    db.SubmitChanges();
                }
            }
            catch
            {
            }
            return(true);
        }
예제 #10
0
        public static bool ImportAllActiveStaff(Guid SchoolYearId, Guid SchoolId, Guid OldCurrentSchoolYearId, System.Data.Common.DbTransaction tran, DayCareDataContext dbold)
        {
            DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clStaffSchoolYear, "ImportAllActiveStaff", "Execute ImportAllActiveStaff Method", DayCarePL.Common.GUID_DEFAULT);
            clConnection.DoConnection();

            DayCareDataContext db = dbold;

            db.Transaction = tran;
            StaffSchoolYear DBStaffSchoolYear = null;

            try
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clStaffSchoolYear, "ImportAllActiveStaff", "Debug ImportAllActiveStaff Method", DayCarePL.Common.GUID_DEFAULT);

                /* Guid currentschoolyearid = (from sy in db.SchoolYears
                 *                           where sy.CurrentId.Equals(true) && sy.SchoolId.Equals(SchoolId)
                 *                           select sy.Id).SingleOrDefault(); */
                Guid currentschoolyearid = SchoolYearId;

                List <Guid> lstStaff = (from s in db.Staffs
                                        join ug in db.UserGroups on s.UserGroupId equals ug.Id
                                        join ssy in db.StaffSchoolYears on s.Id equals ssy.StaffId
                                        where ug.SchoolId.Equals(SchoolId) && ssy.active.Equals(true) && ssy.SchoolYearId.Equals(OldCurrentSchoolYearId) &&
                                        !(from sy in db.StaffSchoolYears
                                          where sy.SchoolYearId.Equals(currentschoolyearid)
                                          select sy.StaffId).Contains(s.Id)
                                        select s.Id).ToList();

                foreach (Guid staffid in lstStaff)
                {
                    try
                    {
                        DBStaffSchoolYear              = new StaffSchoolYear();
                        DBStaffSchoolYear.Id           = Guid.NewGuid();
                        DBStaffSchoolYear.StaffId      = staffid;
                        DBStaffSchoolYear.SchoolYearId = SchoolYearId;
                        DBStaffSchoolYear.active       = true;
                        db.StaffSchoolYears.InsertOnSubmit(DBStaffSchoolYear);
                        db.SubmitChanges();
                    }
                    catch
                    { }
                }

                return(true);
            }
            catch (Exception ex)
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clStaffSchoolYear, "ImportAllActiveStaff", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
                return(false);
            }
        }
예제 #11
0
        public static bool Save(List <DayCarePL.LedgerProperties> lstLedger)
        {
            // DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clLedger, "Save", "Save method called", DayCarePL.Common.GUID_DEFAULT);
            DayCareDataContext db       = new DayCareDataContext();
            Ledger             DBLedger = null;

            try
            {
                ///DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clLedger, "Save", "Debug Save called", DayCarePL.Common.GUID_DEFAULT);
                foreach (DayCarePL.LedgerProperties objLedger in lstLedger)
                {
                    try
                    {
                        if (!CheckChildProgInLedger(objLedger.SchoolYearId, objLedger.ChildFamilyId, objLedger.ChildDataId, objLedger.TransactionDate, objLedger.SchoolProgramId))
                        {
                            DBLedger                      = new Ledger();
                            DBLedger.Id                   = Guid.NewGuid();
                            DBLedger.SchoolYearId         = objLedger.SchoolYearId;
                            DBLedger.ChildFamilyId        = objLedger.ChildFamilyId;
                            DBLedger.ChildDataId          = objLedger.ChildDataId;
                            DBLedger.TransactionDate      = objLedger.TransactionDate;
                            DBLedger.Comment              = objLedger.Comment;
                            DBLedger.Detail               = objLedger.Detail;
                            DBLedger.Debit                = objLedger.Debit;
                            DBLedger.Credit               = objLedger.Credit;
                            DBLedger.Balance              = objLedger.Debit - objLedger.Credit;
                            DBLedger.AllowEdit            = objLedger.AllowEdit;
                            DBLedger.PaymentId            = objLedger.PaymentId;
                            DBLedger.CreatedById          = objLedger.CreatedById.HasValue == true ? objLedger.CreatedById.Value : new Guid(DayCarePL.Common.GUID_DEFAULT);
                            DBLedger.CreatedDateTime      = objLedger.CreatedDateTime;
                            DBLedger.LastModifiedById     = objLedger.LastModifiedById;
                            DBLedger.LastModifiedDatetime = objLedger.LastModifiedDatetime;
                            DBLedger.SchoolProgramId      = objLedger.SchoolProgramId;
                            db.Ledgers.InsertOnSubmit(DBLedger);
                            db.SubmitChanges();
                        }
                    }
                    catch (Exception ex)
                    {
                        DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clLedger, "Save", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
                    }
                }

                return(true);
            }
            catch (Exception ex)
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clLedger, "Save", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
                return(false);
            }
        }
예제 #12
0
        public static bool Save(DayCarePL.StateProperties objState)
        {
            DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clState, "Save", "Execute Save Method", DayCarePL.Common.GUID_DEFAULT);
            clConnection.DoConnection();
            bool result           = false;
            DayCareDataContext db = new DayCareDataContext();
            State DBState         = null;

            try
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clState, "Save", "Debug Save Method", DayCarePL.Common.GUID_DEFAULT);
                Configuration myConfiguration = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("~");
                XDocument     xDoc            = XDocument.Load(myConfiguration.FilePath.ToLower().Remove(myConfiguration.FilePath.ToLower().IndexOf("web.config")) + "XML\\StateList.xml");

                if (objState.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
                {
                    DBState    = new State();
                    DBState.Id = Guid.NewGuid();
                    xDoc.Element("States").Add(new XElement("State", new XElement("Id", DBState.Id), new XElement("Name", objState.Name), new XElement("CountryId", objState.CountryId)));
                    xDoc.Save(myConfiguration.FilePath.ToLower().Remove(myConfiguration.FilePath.ToLower().IndexOf("web.config")) + "XML\\StateList.xml");
                }
                else
                {
                    DBState = db.States.SingleOrDefault(c => c.Id.Equals(objState.Id));
                    var statedata = (from c in xDoc.Descendants("State")
                                     where c.Element("Id").Value.Equals(objState.Id.ToString())
                                     select c).Single();

                    statedata.Element("Name").Value      = objState.Name;
                    statedata.Element("CountryId").Value = Convert.ToString(objState.CountryId);
                    xDoc.Save(myConfiguration.FilePath.ToLower().Remove(myConfiguration.FilePath.ToLower().IndexOf("web.config")) + "XML\\StateList.xml");
                }
                DBState.Name      = objState.Name;
                DBState.CountryId = objState.CountryId;
                if (objState.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
                {
                    db.States.InsertOnSubmit(DBState);
                }
                db.SubmitChanges();
                result = true;
            }
            catch (Exception ex)
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clState, "Save", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
                result = false;
            }
            return(result);
        }
예제 #13
0
        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);
        }
예제 #14
0
        public static bool Save(DayCarePL.AbsentResonProperties objAbsentReason)
        {
            DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clAbsentReason, "Save", "Execute Save Method", DayCarePL.Common.GUID_DEFAULT);
            clConnection.DoConnection();
            bool result                       = false;
            DayCareDataContext db             = new DayCareDataContext();
            AbsentReason       DBAbsentReason = null;

            try
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clAbsentReason, "Save", "Debug Save Method", DayCarePL.Common.GUID_DEFAULT);
                if (objAbsentReason.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
                {
                    DBAbsentReason    = new AbsentReason();
                    DBAbsentReason.Id = System.Guid.NewGuid();
                }
                else
                {
                    DBAbsentReason = db.AbsentReasons.SingleOrDefault(A => A.Id.Equals(objAbsentReason.Id));
                }
                DBAbsentReason.LastModifiedById     = objAbsentReason.LastModifiedById;
                DBAbsentReason.LastModifiedDatetime = DateTime.Now;
                // DBAbsentReason.Id=objAbsentReason.Id;
                DBAbsentReason.Reason               = objAbsentReason.Reason;
                DBAbsentReason.SchoolId             = objAbsentReason.SchoolId;
                DBAbsentReason.Active               = objAbsentReason.Active;
                DBAbsentReason.BillingAffected      = objAbsentReason.BillingAffected;
                DBAbsentReason.Comments             = objAbsentReason.Comments;
                DBAbsentReason.LastModifiedById     = objAbsentReason.LastModifiedById;
                DBAbsentReason.LastModifiedDatetime = DateTime.Now;
                if (objAbsentReason.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
                {
                    db.AbsentReasons.InsertOnSubmit(DBAbsentReason);
                }
                db.SubmitChanges();
                result = true;
            }
            catch (Exception ex)
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clAbsentReason, "Save", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
                result = false;
            }
            return(result);
        }
예제 #15
0
        public static bool Save(DayCarePL.EnrollmentStatusProperties objEnrollment)
        {
            DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clEnrollmentStatus, "Save", "Execute Save Method", DayCarePL.Common.GUID_DEFAULT);
            clConnection.DoConnection();
            bool result           = false;
            DayCareDataContext db = new DayCareDataContext();
            EnrollmentStatus   DBEnrollmentStatus = null;

            try
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clEnrollmentStatus, "Save", "Debug Save Method", DayCarePL.Common.GUID_DEFAULT);
                if (objEnrollment.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
                {
                    DBEnrollmentStatus    = new EnrollmentStatus();
                    DBEnrollmentStatus.Id = System.Guid.NewGuid();
                }
                else
                {
                    DBEnrollmentStatus = db.EnrollmentStatus.SingleOrDefault(E => E.Id.Equals(objEnrollment.Id));
                }
                DBEnrollmentStatus.LastModifiedById     = objEnrollment.LastModifiedById;
                DBEnrollmentStatus.LastModifiedDatetime = DateTime.Now;
                DBEnrollmentStatus.SchoolId             = objEnrollment.SchoolId;
                DBEnrollmentStatus.Status               = objEnrollment.Status;
                DBEnrollmentStatus.Active               = objEnrollment.Active;
                DBEnrollmentStatus.Comments             = objEnrollment.Comments;
                DBEnrollmentStatus.LastModifiedById     = objEnrollment.LastModifiedById;
                DBEnrollmentStatus.LastModifiedDatetime = DateTime.Now;
                if (objEnrollment.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
                {
                    db.EnrollmentStatus.InsertOnSubmit(DBEnrollmentStatus);
                }
                db.SubmitChanges();
                result = true;
            }
            catch (Exception ex)
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clEnrollmentStatus, "Save", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
                result = false;
            }
            return(result);
        }
예제 #16
0
        public static bool Save(DayCarePL.UserGroupProperties objUserGroup)
        {
            DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clUserGroup, "Save", "Execute Save Method", DayCarePL.Common.GUID_DEFAULT);
            clConnection.DoConnection();
            bool result                    = false;
            DayCareDataContext db          = new DayCareDataContext();
            UserGroup          DBUserGroup = null;

            try
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clUserGroup, "Save", "Debug Save Method", DayCarePL.Common.GUID_DEFAULT);
                if (objUserGroup.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
                {
                    DBUserGroup    = new UserGroup();
                    DBUserGroup.Id = System.Guid.NewGuid();
                }
                else
                {
                    DBUserGroup = db.UserGroups.SingleOrDefault(U => U.Id.Equals(objUserGroup.Id));
                }
                DBUserGroup.LastModifiedById     = objUserGroup.LastModifiedById;
                DBUserGroup.LastModifiedDatetime = DateTime.Now;
                DBUserGroup.SchoolId             = objUserGroup.SchoolId;
                DBUserGroup.GroupTitle           = objUserGroup.GroupTitle;
                DBUserGroup.RoleId               = objUserGroup.RoleId;
                DBUserGroup.Comments             = objUserGroup.Comments;
                DBUserGroup.LastModifiedById     = objUserGroup.LastModifiedById;
                DBUserGroup.LastModifiedDatetime = DateTime.Now;
                if (objUserGroup.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
                {
                    db.UserGroups.InsertOnSubmit(DBUserGroup);
                }
                db.SubmitChanges();
                result = true;
            }
            catch (Exception ex)
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clUserGroup, "Save", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
                result = false;
            }
            return(result);
        }
예제 #17
0
        public static bool Save(DayCarePL.HoursOfOperationProperties objHoursOfOperation)
        {
            DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clHoursOfOperation, "Save", "Execute Save Method", DayCarePL.Common.GUID_DEFAULT);
            clConnection.DoConnection();
            DayCareDataContext db = new DayCareDataContext();
            HoursOfOperation   DBHourOfOeration = null;

            try
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clHoursOfOperation, "Save", "Debug Save Method", DayCarePL.Common.GUID_DEFAULT);
                if (objHoursOfOperation.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
                {
                    DBHourOfOeration    = new HoursOfOperation();
                    DBHourOfOeration.Id = Guid.NewGuid();
                }
                else
                {
                    DBHourOfOeration = db.HoursOfOperations.SingleOrDefault(id => id.Id.Equals(objHoursOfOperation.Id));
                }
                DBHourOfOeration.LastModifiedById     = objHoursOfOperation.LastModifiedById;
                DBHourOfOeration.LastModifiedDatetime = DateTime.Now;
                DBHourOfOeration.Day       = objHoursOfOperation.Day;
                DBHourOfOeration.DayIndex  = objHoursOfOperation.DayIndex;
                DBHourOfOeration.OpenTime  = objHoursOfOperation.OpenTime;
                DBHourOfOeration.CloseTime = objHoursOfOperation.CloseTime;
                DBHourOfOeration.Comments  = objHoursOfOperation.Comments;
                DBHourOfOeration.SchoolId  = objHoursOfOperation.SchoolId;

                if (objHoursOfOperation.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
                {
                    db.HoursOfOperations.InsertOnSubmit(DBHourOfOeration);
                }
                db.SubmitChanges();
                return(true);
            }
            catch (Exception ex)
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clHoursOfOperation, "Save", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
                return(false);
            }
        }
예제 #18
0
        public static bool Save(DayCarePL.AdditionalNotesProperties objNotes)
        {
            DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clAbsentReason, "Save", "Execute Save Method", DayCarePL.Common.GUID_DEFAULT);
            clConnection.DoConnection();
            bool result           = false;
            DayCareDataContext db = new DayCareDataContext();
            AdditionalNote     DBAdditionalNote = null;

            try
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clAbsentReason, "Save", "Debug Save Method", DayCarePL.Common.GUID_DEFAULT);
                if (objNotes.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
                {
                    DBAdditionalNote                 = new AdditionalNote();
                    DBAdditionalNote.Id              = System.Guid.NewGuid();
                    DBAdditionalNote.CreatedById     = objNotes.CreatedById;
                    DBAdditionalNote.CreatedDateTime = DateTime.Now;
                }
                else
                {
                    DBAdditionalNote = db.AdditionalNotes.SingleOrDefault(A => A.Id.Equals(objNotes.Id));
                }
                DBAdditionalNote.ChildSchoolYearId    = objNotes.ChildSchoolYearId;
                DBAdditionalNote.CommentDate          = objNotes.CommentDate;
                DBAdditionalNote.Comments             = objNotes.Comments;
                DBAdditionalNote.LastModifiedById     = objNotes.LastModifiedById;
                DBAdditionalNote.LastMidifiedDateTime = DateTime.Now;
                if (objNotes.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
                {
                    db.AdditionalNotes.InsertOnSubmit(DBAdditionalNote);
                }
                db.SubmitChanges();
                result = true;
            }
            catch (Exception ex)
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clAbsentReason, "Save", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
                result = false;
            }
            return(result);
        }
예제 #19
0
        public static bool Save(DayCarePL.RelationshipProperties objRelationship)
        {
            DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clRelationship, "Save", "Execute Save Method", DayCarePL.Common.GUID_DEFAULT);
            clConnection.DoConnection();

            DayCareDataContext db             = new DayCareDataContext();
            Relationship       DBRelationship = null;

            try
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clRelationship, "Save", "Debug Save Method", DayCarePL.Common.GUID_DEFAULT);

                if (objRelationship.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
                {
                    DBRelationship    = new Relationship();
                    DBRelationship.Id = System.Guid.NewGuid();
                }
                else
                {
                    DBRelationship = db.Relationships.SingleOrDefault(u => u.Id.Equals(objRelationship.Id));
                }
                DBRelationship.Name                 = objRelationship.Name;
                DBRelationship.SchoolId             = objRelationship.SchoolId;
                DBRelationship.Active               = objRelationship.Active;
                DBRelationship.Comments             = objRelationship.Comments;
                DBRelationship.LastModifiedById     = objRelationship.LastModifiedById;
                DBRelationship.LastModifiedDatetime = DateTime.Now;

                if (objRelationship.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
                {
                    db.Relationships.InsertOnSubmit(DBRelationship);
                }
                db.SubmitChanges();
                return(true);
            }
            catch (Exception ex)
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clRelationship, "Save", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
                return(false);
            }
        }
예제 #20
0
        public static bool Save(DayCarePL.ChargeCodeProperties objChargesCode)
        {
            DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clChargeCode, "Save", "Save method called", DayCarePL.Common.GUID_DEFAULT);
            clConnection.DoConnection();
            DayCareDataContext db           = new DayCareDataContext();
            ChargeCode         DBChargeCode = null;
            bool result = false;

            try
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clChargeCode, "Save", "Debug Save called", DayCarePL.Common.GUID_DEFAULT);
                if (objChargesCode.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
                {
                    DBChargeCode    = new ChargeCode();
                    DBChargeCode.Id = Guid.NewGuid();
                    DBChargeCode.CreatedDateTime = DateTime.Now;
                    DBChargeCode.CreatedById     = objChargesCode.CreatedById;
                }
                else
                {
                    DBChargeCode = db.ChargeCodes.SingleOrDefault(cc => cc.Id.Equals(objChargesCode.Id));
                }
                DBChargeCode.LastModifiedDatetime = DateTime.Now;
                DBChargeCode.LastModifiedById     = objChargesCode.LastModifiedById;
                DBChargeCode.Name       = objChargesCode.Name;
                DBChargeCode.Category   = objChargesCode.Category;
                DBChargeCode.DebitCrdit = objChargesCode.DebitCrdit;
                if (objChargesCode.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
                {
                    db.ChargeCodes.InsertOnSubmit(DBChargeCode);
                }
                db.SubmitChanges();
                result = true;
            }
            catch (Exception ex)
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clChargeCode, "Save", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
                result = false;
            }
            return(result);
        }
예제 #21
0
        public static bool Save(DayCarePL.FeesPeriodProperties objFeesPeriod)
        {
            DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clFeesPeriod, "Save", "Execute Save Method", DayCarePL.Common.GUID_DEFAULT);
            clConnection.DoConnection();
            bool result                     = false;
            DayCareDataContext db           = new DayCareDataContext();
            FeesPeriod         DBFeesPeriod = null;

            try
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clFeesPeriod, "Save", "Debug Save Method", DayCarePL.Common.GUID_DEFAULT);
                if (objFeesPeriod.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
                {
                    DBFeesPeriod    = new FeesPeriod();
                    DBFeesPeriod.Id = System.Guid.NewGuid();
                    DBFeesPeriod.CreatedDateTime = DateTime.Now;
                    DBFeesPeriod.CreatedById     = objFeesPeriod.CreatedById;
                }
                else
                {
                    DBFeesPeriod = db.FeesPeriods.SingleOrDefault(F => F.Id.Equals(objFeesPeriod.Id));
                }
                DBFeesPeriod.LastModifiedById     = objFeesPeriod.LastModifiedById;
                DBFeesPeriod.LastModifiedDatetime = DateTime.Now;
                DBFeesPeriod.Name   = objFeesPeriod.Name;
                DBFeesPeriod.Active = objFeesPeriod.Active;
                if (objFeesPeriod.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
                {
                    db.FeesPeriods.InsertOnSubmit(DBFeesPeriod);
                }
                db.SubmitChanges();
                result = true;
            }
            catch (Exception ex)
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clFeesPeriod, "Save", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
                result = false;
            }
            return(result);
        }
예제 #22
0
        public static bool ExportStafftoStaffSchoolYear(Guid StaffId, Guid SchoolId, Guid SchoolYearId, bool Active, System.Data.Common.DbTransaction tran, DayCareDataContext dbold)
        {
            DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clStaffSchoolYear, "ExportStafftoStaffSchoolYear", "Execute ExportStafftoStaffSchoolYear Method", DayCarePL.Common.GUID_DEFAULT);
            clConnection.DoConnection();

            DayCareDataContext db = dbold;

            db.Transaction = tran;
            StaffSchoolYear DBStaffSchoolYear = null;

            try
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clStaffSchoolYear, "ExportStafftoStaffSchoolYear", "Debug ExportStafftoStaffSchoolYear Method", DayCarePL.Common.GUID_DEFAULT);
                //Guid SchoolYearId = (from sy in db.SchoolYears
                //                     where sy.CurrentId.Equals(true) && sy.SchoolId.Equals(SchoolId)
                //                     select sy.Id).SingleOrDefault();

                int staffcount = (from ssy in db.StaffSchoolYears
                                  where ssy.SchoolYearId.Equals(SchoolYearId) && ssy.StaffId.Equals(StaffId)
                                  select ssy.Id).Count();

                if (staffcount == 0)
                {
                    DBStaffSchoolYear              = new StaffSchoolYear();
                    DBStaffSchoolYear.Id           = Guid.NewGuid();
                    DBStaffSchoolYear.StaffId      = StaffId;
                    DBStaffSchoolYear.SchoolYearId = SchoolYearId;
                    DBStaffSchoolYear.active       = Active;
                    db.StaffSchoolYears.InsertOnSubmit(DBStaffSchoolYear);
                    db.SubmitChanges();
                }
                return(true);
            }
            catch (Exception ex)
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clStaffSchoolYear, "ExportStafftoStaffSchoolYear", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
                return(false);
            }
        }
        public static bool Save(DayCarePL.StaffAttendenceHistoryProperties objStaffAttendance)
        {
            DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clAbsentReason, "Save", "Execute Save Method", DayCarePL.Common.GUID_DEFAULT);
            clConnection.DoConnection();
            bool result = false;
            DayCareDataContext     db = new DayCareDataContext();
            StaffAttendenceHistory DBStaffAttendance = null;

            try
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clAbsentReason, "Save", "Debug Save Method", DayCarePL.Common.GUID_DEFAULT);
                if (objStaffAttendance.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
                {
                    DBStaffAttendance    = new StaffAttendenceHistory();
                    DBStaffAttendance.Id = System.Guid.NewGuid();
                    DBStaffAttendance.CreatedDateTime = DateTime.Now;
                }
                else
                {
                    DBStaffAttendance = db.StaffAttendenceHistories.SingleOrDefault(A => A.Id.Equals(objStaffAttendance.Id));
                }
                DBStaffAttendance.StaffSchoolYearId       = objStaffAttendance.StaffSchoolYearId;
                DBStaffAttendance.CheckInCheckOutDateTime = objStaffAttendance.CheckInCheckOutDateTime;
                DBStaffAttendance.CheckInCheckOut         = objStaffAttendance.CheckInCheckOut;
                if (objStaffAttendance.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
                {
                    db.StaffAttendenceHistories.InsertOnSubmit(DBStaffAttendance);
                }
                db.SubmitChanges();
                result = true;
            }
            catch (Exception ex)
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clAbsentReason, "Save", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
                result = false;
            }
            return(result);
        }
예제 #24
0
        public static bool Save(DayCarePL.FontProperties objFont)
        {
            DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clFont, "Save", "Execute Save Method", DayCarePL.Common.GUID_DEFAULT);
            clConnection.DoConnection();
            bool result           = false;
            DayCareDataContext db = new DayCareDataContext();
            Font DBFont           = null;

            try
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clFont, "Save", "Debug Save Method", DayCarePL.Common.GUID_DEFAULT);
                if (objFont.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
                {
                    DBFont    = new Font();
                    DBFont.Id = System.Guid.NewGuid();
                }
                else
                {
                    DBFont = db.Fonts.SingleOrDefault(F => F.Id.Equals(objFont.Id));
                }
                DBFont.Name   = objFont.Name;
                DBFont.Color  = objFont.Color;
                DBFont.Size   = objFont.Size;
                DBFont.Active = objFont.Active;
                if (objFont.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
                {
                    db.Fonts.InsertOnSubmit(DBFont);
                }
                db.SubmitChanges();
                result = true;
            }
            catch (Exception ex)
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clFont, "Save", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
                result = false;
            }
            return(result);
        }
예제 #25
0
        public static DayCarePL.ResultStatus Save(string UserId, string DateTime)
        {
            clConnection.DoConnection();
            DayCareDataContext db = new DayCareDataContext();

            DayCarePL.ResultStatus objResultStatus = new DayCarePL.ResultStatus();
            SyncLog DBSyncLog = null;

            try
            {
                DBSyncLog          = new SyncLog();
                DBSyncLog.Id       = Guid.NewGuid();
                DBSyncLog.UserId   = new Guid(UserId);
                DBSyncLog.Datetime = Convert.ToDateTime(DateTime);
                db.SyncLogs.InsertOnSubmit(DBSyncLog);
                db.SubmitChanges();
                objResultStatus.Status = "true";
            }
            catch
            {
                objResultStatus.Status = "false";
            }
            return(objResultStatus);
        }
예제 #26
0
        public static bool Save(DayCarePL.StaffProperties objStaff)
        {
            DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clMyAccount, "Save", "Execute Save Method", DayCarePL.Common.GUID_DEFAULT);
            clConnection.DoConnection();
            bool result           = false;
            DayCareDataContext db = new DayCareDataContext();
            Staff DBStaff         = null;

            try
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clMyAccount, "Save", "Debug Save Method", DayCarePL.Common.GUID_DEFAULT);
                if (!objStaff.Id.Equals(DayCarePL.Common.GUID_DEFAULT))
                {
                    DBStaff = db.Staffs.SingleOrDefault(s => s.Id.Equals(objStaff.Id));
                }
                DBStaff.LastModifiedById     = objStaff.LastModifiedById;
                DBStaff.LastModifiedDatetime = DateTime.Now;
                DBStaff.FirstName            = objStaff.FirstName;
                DBStaff.LastName             = objStaff.LastName;
                DBStaff.UserName             = objStaff.UserName;
                DBStaff.Password             = objStaff.Password;
                DBStaff.code = objStaff.Code;
                if (objStaff.Id.Equals(DayCarePL.Common.GUID_DEFAULT))
                {
                    db.Staffs.InsertOnSubmit(DBStaff);
                }
                db.SubmitChanges();
                result = true;
            }
            catch (Exception ex)
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clMyAccount, "Save", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
                result = false;
            }
            return(result);
        }
예제 #27
0
        public static bool Save(List <DayCarePL.FamilyPaymentProperties> lstFamilyPayment)
        {
            DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clFamilyPayment, "Save", "Save method called", DayCarePL.Common.GUID_DEFAULT);
            clConnection.DoConnection();
            DayCareDataContext db = new DayCareDataContext();

            System.Data.Common.DbTransaction Tran = null;
            Payment DBPayment = null;

            try
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clFamilyPayment, "Save", "Debug Save called", DayCarePL.Common.GUID_DEFAULT);
                if (db.Connection.State == System.Data.ConnectionState.Closed)
                {
                    db.Connection.Open();
                }
                Tran           = db.Connection.BeginTransaction();
                db.Transaction = Tran;
                int cntSuccess = 0;
                foreach (DayCarePL.FamilyPaymentProperties objFamilyPayment in lstFamilyPayment)
                {
                    try
                    {
                        if (objFamilyPayment.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
                        {
                            DBPayment    = new Payment();
                            DBPayment.Id = Guid.NewGuid();
                            DBPayment.CreatedDateTime = DateTime.Now;
                            DBPayment.CreatedById     = objFamilyPayment.CreatedById;
                        }
                        else
                        {
                            DBPayment = db.Payments.FirstOrDefault(i => i.Id.Equals(objFamilyPayment.Id));
                        }
                        DBPayment.SchoolYearId         = objFamilyPayment.SchoolYearId;
                        DBPayment.ChildFamilyId        = objFamilyPayment.ChildFamilyId;
                        DBPayment.PostDate             = objFamilyPayment.PostDate;
                        DBPayment.PaymentMethod        = objFamilyPayment.PaymentMethod;
                        DBPayment.PaymentDetail        = objFamilyPayment.PaymentDetail;
                        DBPayment.Amount               = objFamilyPayment.Amount;
                        DBPayment.LastModifiedDatetime = DateTime.Now;
                        DBPayment.LastModifiedById     = objFamilyPayment.LastModifiedById;
                        if (objFamilyPayment.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
                        {
                            db.Payments.InsertOnSubmit(DBPayment);
                        }
                        db.SubmitChanges();
                        Ledger DBLedger = new Ledger();
                        if (objFamilyPayment.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
                        {
                            DBLedger.Id              = Guid.NewGuid();
                            DBLedger.PaymentId       = DBPayment.Id;
                            DBLedger.CreatedById     = (objFamilyPayment.CreatedById).Value;
                            DBLedger.CreatedDateTime = DateTime.Now;
                        }
                        else
                        {
                            DBLedger = db.Ledgers.FirstOrDefault(i => i.PaymentId.Equals(objFamilyPayment.Id));
                        }
                        DBLedger.SchoolYearId    = objFamilyPayment.SchoolYearId;
                        DBLedger.ChildFamilyId   = objFamilyPayment.ChildFamilyId;
                        DBLedger.TransactionDate = Convert.ToDateTime(objFamilyPayment.PostDate);
                        string paymentmethod = "";
                        if (!string.IsNullOrEmpty(objFamilyPayment.PaymentMethod))
                        {
                            switch (objFamilyPayment.PaymentMethod)
                            {
                            case "0":
                                paymentmethod = "Cash";
                                break;

                            case "1":
                                paymentmethod = "Check";
                                break;

                            case "2":
                                paymentmethod = "Credit";
                                break;
                            }
                        }
                        DBLedger.PaymentMethodId      = Convert.ToInt16(objFamilyPayment.PaymentMethod);
                        DBLedger.Comment              = paymentmethod + (string.IsNullOrEmpty(objFamilyPayment.PaymentDetail) ? "" : "-" + objFamilyPayment.PaymentDetail);
                        DBLedger.Debit                = 0;
                        DBLedger.Credit               = objFamilyPayment.Amount;
                        DBLedger.Balance              = DBLedger.Debit - DBLedger.Credit;
                        DBLedger.AllowEdit            = true;
                        DBLedger.LastModifiedDatetime = DateTime.Now;
                        DBLedger.LastModifiedById     = objFamilyPayment.LastModifiedById;
                        if (objFamilyPayment.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
                        {
                            db.Ledgers.InsertOnSubmit(DBLedger);
                        }
                        db.SubmitChanges();

                        //update closing balance on 10 May 2013 By Akash
                        try
                        {
                            Guid SchoolId = clSchool.GetSchoolIdbySchoolYearId(objFamilyPayment.SchoolYearId.Value);
                            if (clSchoolYear.IsSelectedYearPrevYearORNot(SchoolId, objFamilyPayment.SchoolYearId.Value))//only prev year can only allow to edit closing balance. because in current year or in future year closing balance is not genrated in these year
                            {
                                clSchoolYear.UpdateClosingBalance(SchoolId, objFamilyPayment.SchoolYearId.Value, objFamilyPayment.ChildFamilyId.Value, Tran, db);
                            }
                        }
                        catch { }

                        //End
                        cntSuccess++;
                    }
                    catch
                    { }
                }
                Tran.Commit();
                if (cntSuccess > 0)
                {
                    return(true);
                }
                else
                {
                    return(false);
                }
            }
            catch (Exception ex)
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clFamilyPayment, "Save", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
                if (Tran != null)
                {
                    Tran.Rollback();
                }
                return(false);
            }
        }
예제 #28
0
        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);
            }
        }
예제 #29
0
        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);
            //SqlConnection conn = clConnection.CreateConnection();
            clConnection.DoConnection();
            DayCareDataContext db = new DayCareDataContext();

            System.Data.Common.DbTransaction Tran = null;
            try
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clFamilyPayment, "Delete", "Debug Delete Method", DayCarePL.Common.GUID_DEFAULT);
                //clConnection.OpenConnection(conn);
                //SqlCommand cmd;
                //cmd = clConnection.CreateCommand("spDeleteFamilyPayment", conn);
                //cmd.Parameters.Add(clConnection.GetInputParameter("@Id", Id));
                //object Result = cmd.ExecuteScalar();
                //result = Convert.ToBoolean(Result);
                if (db.Connection.State == System.Data.ConnectionState.Closed)
                {
                    db.Connection.Open();
                }
                Tran           = db.Connection.BeginTransaction();
                db.Transaction = Tran;

                Ledger DBLedger = db.Ledgers.FirstOrDefault(i => i.PaymentId.Equals(Id));
                if (DBLedger != null)
                {
                    db.Ledgers.DeleteOnSubmit(DBLedger);
                    db.SubmitChanges();
                }
                else
                {
                    Tran.Rollback();
                    result = false;
                }
                Payment DBPayment = db.Payments.FirstOrDefault(i => i.Id.Equals(Id));
                if (DBPayment != null)
                {
                    db.Payments.DeleteOnSubmit(DBPayment);
                    db.SubmitChanges();
                    Tran.Commit();
                    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;
                if (Tran != null)
                {
                    Tran.Rollback();
                }
            }
            return(result);
        }
예제 #30
0
        public static Guid Save(DayCarePL.SchoolYearProperties objSchoolYear, Guid OldCurrentSchoolYearId)
        {
            DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.clSchoolYear, "Save", "Execute Save Method", DayCarePL.Common.GUID_DEFAULT);
            clConnection.DoConnection();

            DayCareDataContext db = new DayCareDataContext();

            System.Data.Common.DbTransaction tran = null;
            SchoolYear DBSchoolYear = null;
            bool       result       = true;

            //Guid LastCurrentId = new Guid();
            try
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.clSchoolYear, "Save", "Debug Save Method", DayCarePL.Common.GUID_DEFAULT);
                if (db.Connection.State == System.Data.ConnectionState.Closed)
                {
                    db.Connection.Open();
                }
                tran           = db.Connection.BeginTransaction();
                db.Transaction = tran;
                //if (objSchoolYear.CurrentId == true)
                if (objSchoolYear.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT) && objSchoolYear.CurrentId == false) // remove condition if you wish to import staff and programs on update event.
                {
                    DBSchoolYear = new SchoolYear();
                    DBSchoolYear = db.SchoolYears.SingleOrDefault(Currentid => Currentid.CurrentId.Equals(true) && Currentid.SchoolId == objSchoolYear.SchoolId);
                    if (DBSchoolYear != null)
                    {
                        OldCurrentSchoolYearId = DBSchoolYear.Id;
                        // DBSchoolYear.CurrentId = false;
                        // db.SubmitChanges();
                    }
                }

                if (objSchoolYear.CurrentId == true)
                {
                    DBSchoolYear = new SchoolYear();
                    DBSchoolYear = db.SchoolYears.SingleOrDefault(Currentid => Currentid.CurrentId.Equals(true) && Currentid.SchoolId == objSchoolYear.SchoolId);
                    if (DBSchoolYear != null)
                    {
                        OldCurrentSchoolYearId = DBSchoolYear.Id;
                        DBSchoolYear.CurrentId = false;
                        db.SubmitChanges();
                    }
                }

                if (objSchoolYear.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
                {
                    DBSchoolYear                 = new SchoolYear();
                    DBSchoolYear.Id              = System.Guid.NewGuid();
                    DBSchoolYear.CreatedById     = objSchoolYear.CreatedById;
                    DBSchoolYear.CreatedDateTime = DateTime.Now;
                }
                else
                {
                    DBSchoolYear = db.SchoolYears.SingleOrDefault(u => u.Id.Equals(objSchoolYear.Id));
                }
                DBSchoolYear.Year                 = objSchoolYear.Year;
                DBSchoolYear.SchoolId             = objSchoolYear.SchoolId;
                DBSchoolYear.StartDate            = objSchoolYear.StartDate;
                DBSchoolYear.EndDate              = objSchoolYear.EndDate;
                DBSchoolYear.CurrentId            = objSchoolYear.CurrentId;
                DBSchoolYear.Comments             = objSchoolYear.Comments;
                DBSchoolYear.LastModifiedById     = objSchoolYear.LastModifiedById;
                DBSchoolYear.LastModifiedDatetime = DateTime.Now;
                //if (objSchoolYear.CurrentId == true)
                //{
                //if (!OldCurrentSchoolYearId.Equals(DBSchoolYear.Id))
                //{
                DBSchoolYear.OldCurrentSchoolYearId = OldCurrentSchoolYearId;
                //}
                //}

                if (objSchoolYear.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
                {
                    db.SchoolYears.InsertOnSubmit(DBSchoolYear);
                }
                db.SubmitChanges();



                if (objSchoolYear.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT)) // add ! (not equal to if you wish to import staff and programs on update event.
                //if (objSchoolYear.CurrentId == true)
                {
                    if (DayCareDAL.clStaffSchoolYear.ImportAllActiveStaff(DBSchoolYear.Id, objSchoolYear.SchoolId, OldCurrentSchoolYearId, tran, db))
                    {
                        //tran.Commit();
                        result = true;
                    }
                    else
                    {
                        //tran.Rollback();
                        result = false;
                    }

                    //clChildFamily objChildFamily = new clChildFamily();
                    //if (objChildFamily.ImportAllActiveChildFamily(DBSchoolYear.Id, objSchoolYear.SchoolId, OldCurrentSchoolYearId, tran, db))
                    //{
                    //    //tran.Commit();
                    //    result = true;
                    //    if (objChildFamily.ImportActiveChildFamilyCount > 0)
                    //    {
                    //        if (clChildSchoolYear.ImportAllActiveChild(objSchoolYear.Id, objSchoolYear.SchoolId, OldCurrentSchoolYearId, tran, db))
                    //        {
                    //            result = true;
                    //        }
                    //        else
                    //        {
                    //            result = false;
                    //        }
                    //    }
                    //}
                    //else
                    //{
                    //    //tran.Rollback();
                    //    result = false;
                    //}
                    //importschoolProgram Import
                    if (result == true)
                    {
                        if (!OldCurrentSchoolYearId.Equals(DBSchoolYear.Id))
                        {
                            if (SaveProgramWithOtherSchoolYear(OldCurrentSchoolYearId, DBSchoolYear.Id, objSchoolYear.SchoolId, tran, db))
                            {
                                result = true;
                            }
                            else
                            {
                                result = false;
                            }
                        }
                    }
                    //end
                    //if (result)
                    //{
                    //    tran.Commit();

                    //}
                    //else
                    //{
                    //    tran.Rollback();
                    //}
                }
                else
                {
                    //tran.Commit();
                    result = true;
                }
                #region "import classroom when changes current year"
                //start---import classroom when changes current year
                if (result == true)
                {
                    if (objSchoolYear.Id.ToString().Equals(DayCarePL.Common.GUID_DEFAULT))
                    {
                        if (DayCareDAL.clClassRoom.ImportAllActiveClassRoom(DBSchoolYear.Id, objSchoolYear.SchoolId, OldCurrentSchoolYearId, tran, db))
                        {
                            //tran.Commit();
                            result = true;

                            //update ClassRoomSchoolYearId into ProgClassRoom table.
                            if (DayCareDAL.clClassRoom.UpdateClassRoomSchoolYearID(DBSchoolYear.Id, OldCurrentSchoolYearId, tran, db))
                            {
                                result = true;
                            }
                            else
                            {
                                result = false;
                            }

                            //update classroomschoolyearid into last year, when first time added
                            if (DayCareDAL.clClassRoom.UpdateLastAddedYearClassRoomSchoolYearID(DBSchoolYear.Id, OldCurrentSchoolYearId, tran, db))
                            {
                                result = true;
                            }
                            else
                            {
                                result = false;
                            }
                        }
                        else
                        {
                            //tran.Rollback();
                            result = false;
                        }
                    }
                    else
                    {
                        result = true;
                    }
                }
                //end---import classroom when changes current year
                #endregion
                if (result == true)
                {
                    if (objSchoolYear.CurrentId == true)
                    {
                        if (!OldCurrentSchoolYearId.Equals(DBSchoolYear.Id))
                        {
                            if (UpdateClosingBalance(objSchoolYear.SchoolId, OldCurrentSchoolYearId, null, tran, db))
                            {
                                result = true;
                            }
                            else
                            {
                                result = false;
                            }
                        }
                    }
                }

                if (result)
                {
                    tran.Commit();
                    return(DBSchoolYear.Id);
                }
                else
                {
                    tran.Rollback();
                    return(new Guid());
                }
            }
            catch (Exception ex)
            {
                DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.clSchoolYear, "Save", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT);
                if (tran != null)
                {
                    tran.Rollback();
                }
                return(new Guid());
            }
            finally
            {
                if (db.Connection.State == System.Data.ConnectionState.Open)
                {
                    db.Connection.Close();
                }
            }
        }