public bool SavePermissionRecordData(List <PermissionRecordDL> objList) { StackFrame stackFrame = new StackFrame(); MethodBase methodBase = stackFrame.GetMethod(); try { OpenEntityConnection(); int Result = 0; if (objList != null) { foreach (var obj in objList) { // data base bind if (obj.RecStatus == 0) { } //Add else if (obj.RecStatus == 1) { Hr_EmpPermissionRecord newobj = new Hr_EmpPermissionRecord(); newobj.Rec_Hdr_Id = GetNewHeaderId(); newobj.Company_Id = obj.Company_Id; newobj.Branch_Id = obj.Branch_Id; newobj.Emp_Serial_No = obj.Emp_Serial_No; newobj.TransDate = DateTime.Now.ToString("yyyyMMdd"); newobj.PermissionDate = obj.PermissionDate; newobj.Request_Id = "10"; newobj.Rec_Order_No = "0"; newobj.Rec_Order_HdrId = maxId; newobj.FromTime = obj.FromTime; newobj.ToTime = obj.ToTime; newobj.Permission_Period = obj.Permission_Period; newobj.InsUser = UserNameProperty; newobj.InsDate = DateTime.Now; newobj.DocumentPath = null; newobj.Commissioner_Serial_no = obj.Emp_Serial_No; newobj.Permission_Type = obj.Permission_Type; newobj.HireItem_Id = "0011"; newobj.Permission_Reason_Id = obj.Permission_Reason_Id; newobj.Permission_Reason_Sub_Id = obj.Permission_Reason_Sub_Id; newobj.Confirmed = 0; objPharmaEntities.Hr_EmpPermissionRecord.Add(newobj); Result = objPharmaEntities.SaveChanges(); } //Edit else if (obj.RecStatus == 2) { if (obj.Rec_Hdr_Id != Guid.Empty) { Hr_EmpPermissionRecord ObjForUpdate = (from objLinq in objPharmaEntities.Hr_EmpPermissionRecord where objLinq.Rec_Hdr_Id == obj.Rec_Hdr_Id select objLinq).FirstOrDefault(); if (ObjForUpdate != null) { ObjForUpdate.PermissionDate = obj.PermissionDate; ObjForUpdate.FromTime = obj.FromTime; ObjForUpdate.ToTime = obj.ToTime; ObjForUpdate.Permission_Period = obj.Permission_Period; ObjForUpdate.Permission_Type = obj.Permission_Type; ObjForUpdate.Emp_Serial_No = obj.Emp_Serial_No; ObjForUpdate.Permission_Reason_Id = obj.Permission_Reason_Id; ObjForUpdate.Permission_Reason_Sub_Id = obj.Permission_Reason_Sub_Id; Result = objPharmaEntities.SaveChanges(); } } else { Hr_EmpPermissionRecord newobj = new Hr_EmpPermissionRecord(); newobj.Rec_Hdr_Id = GetNewHeaderId(); newobj.Company_Id = obj.Company_Id; newobj.Branch_Id = obj.Branch_Id; newobj.Emp_Serial_No = obj.Emp_Serial_No; newobj.TransDate = DateTime.Now.ToString("yyyyMMdd"); newobj.PermissionDate = obj.PermissionDate; newobj.Request_Id = "10"; newobj.Rec_Order_No = "0"; newobj.Rec_Order_HdrId = maxId; newobj.FromTime = obj.FromTime; newobj.ToTime = obj.ToTime; newobj.Permission_Period = obj.Permission_Period; newobj.InsUser = UserNameProperty; newobj.InsDate = DateTime.Now; newobj.DocumentPath = null; newobj.Commissioner_Serial_no = obj.Emp_Serial_No; newobj.Permission_Type = obj.Permission_Type; newobj.HireItem_Id = "0011"; newobj.Permission_Reason_Id = obj.Permission_Reason_Id; newobj.Permission_Reason_Sub_Id = obj.Permission_Reason_Sub_Id; newobj.Confirmed = 0; objPharmaEntities.Hr_EmpPermissionRecord.Add(newobj); Result = objPharmaEntities.SaveChanges(); } } //Delete else if (obj.RecStatus == 3) { if (obj.Rec_Hdr_Id != Guid.Empty) { Hr_EmpPermissionRecord ObjForDelete = (from objLinq in objPharmaEntities.Hr_EmpPermissionRecord where objLinq.Rec_Hdr_Id == obj.Rec_Hdr_Id select objLinq).FirstOrDefault(); if (ObjForDelete != null) { objPharmaEntities.Hr_EmpPermissionRecord.Remove(ObjForDelete); objPharmaEntities.SaveChanges(); } } else { } } else { } } return(Result > 0); } else { return(Result < 0); } } catch (Exception ex) { catchEntityvalidation((System.Data.Entity.Validation.DbEntityValidationException)ex, System.Runtime.InteropServices.Marshal.GetExceptionCode().ToString(), this.UserNameProperty.ToString(), this.GetType().Name.ToString(), methodBase.Name.ToString()); ex.InnerException.Message.ToString(); return(false); } finally { CloseEntityConnection(); } }
public bool SaveRecordData(List <RecordsConfirmationDL> objList) { StackFrame stackFrame = new StackFrame(); MethodBase methodBase = stackFrame.GetMethod(); try { OpenEntityConnection(); int Result = 0; if (objList != null) { foreach (var obj in objList) { if (obj.Record_ID == 0) { if (obj.Rec_Hdr_Id != Guid.Empty) { Hr_EmpOverTimeRecord ObjForUpdate = (from objLinq in objPharmaEntities.Hr_EmpOverTimeRecord where objLinq.Rec_Hdr_Id == obj.Rec_Hdr_Id select objLinq).FirstOrDefault(); if (ObjForUpdate != null) { ObjForUpdate.Confirmed = 1; Result = objPharmaEntities.SaveChanges(); } } } else if (obj.Record_ID == 1) { if (obj.Rec_Hdr_Id != Guid.Empty) { Hr_EmpPermissionRecord ObjForUpdate = (from objLinq in objPharmaEntities.Hr_EmpPermissionRecord where objLinq.Rec_Hdr_Id == obj.Rec_Hdr_Id select objLinq).FirstOrDefault(); if (ObjForUpdate != null) { ObjForUpdate.Confirmed = 1; Result = objPharmaEntities.SaveChanges(); } } } else if (obj.Record_ID == 2) { if (obj.Rec_Hdr_Id != Guid.Empty) { Hr_EmpDelayRecord ObjForUpdate = (from objLinq in objPharmaEntities.Hr_EmpDelayRecord where objLinq.Rec_Hdr_Id == obj.Rec_Hdr_Id select objLinq).FirstOrDefault(); if (ObjForUpdate != null) { ObjForUpdate.Confirmed = 1; Result = objPharmaEntities.SaveChanges(); } } } else if (obj.Record_ID == 3) { if (obj.Rec_Hdr_Id != Guid.Empty) { Hr_EmpVactionRecord ObjForUpdate = (from objLinq in objPharmaEntities.Hr_EmpVactionRecord where objLinq.Rec_Hdr_Id == obj.Rec_Hdr_Id select objLinq).FirstOrDefault(); if (ObjForUpdate != null) { ObjForUpdate.Confirmed = 1; Result = objPharmaEntities.SaveChanges(); } } } else if (obj.Record_ID == 4) { if (obj.Rec_Hdr_Id != Guid.Empty) { Hr_EmpAbsenceRecord ObjForUpdate = (from objLinq in objPharmaEntities.Hr_EmpAbsenceRecord where objLinq.Rec_Hdr_Id == obj.Rec_Hdr_Id select objLinq).FirstOrDefault(); if (ObjForUpdate != null) { ObjForUpdate.Confirmed = 1; Result = objPharmaEntities.SaveChanges(); } } } else { } } return(Result > 0); } else { return(Result < 0); } } catch (Exception ex) { catchEntityvalidation((System.Data.Entity.Validation.DbEntityValidationException)ex, System.Runtime.InteropServices.Marshal.GetExceptionCode().ToString(), this.UserNameProperty.ToString(), this.GetType().Name.ToString(), methodBase.Name.ToString()); ex.InnerException.Message.ToString(); return(false); } finally { CloseEntityConnection(); } }