public bool SaveEmpCastodyData(EmpCastodyDL ObjEmpCastodyDL) { StackFrame stackFrame = new StackFrame(); MethodBase methodBase = stackFrame.GetMethod(); var strErrorMessage = string.Empty; bool result = true; try { OpenEntityConnection(); // result = AddShiftGroup(ObjGroupD); if (ObjEmpCastodyDL != null) { if (ObjEmpCastodyDL.Hdr_Id == Guid.Empty || ObjEmpCastodyDL.Hdr_Id == null) { if (ObjEmpCastodyDL.IsEdit == 0) { Hr_EmpCustodies EmpCustodies = new Hr_EmpCustodies { Hdr_Id = GetNewHeaderId(), Rec_Id = GetNewRec_Id(), Company_Id = ObjEmpCastodyDL.Company_Id, Branch_Id = ObjEmpCastodyDL.Branch_Id, Emp_Serial_No = ObjEmpCastodyDL.Emp_Serial_No, Transdate = ObjEmpCastodyDL.Transdate, Custody_Id = ObjEmpCastodyDL.Custody_Id, Custody_Serial_No = ObjEmpCastodyDL.Custody_Serial_No, Custody_Status = ObjEmpCastodyDL.Custody_Status, Custody_Desc = ObjEmpCastodyDL.Custody_Desc, Custody_Note = ObjEmpCastodyDL.Custody_Note, Received_Date = ObjEmpCastodyDL.Received_Date, // Delivery_Date = ObjEmpCastodyDL.Delivery_Date, Ins_User = UserNameProperty, Ins_Date = DateTime.Now }; objPharmaEntities.Hr_EmpCustodies.Add(EmpCustodies); objPharmaEntities.SaveChanges(); return(result); } } //return result; else { if (ObjEmpCastodyDL.IsEdit == 1) { Hr_EmpCustodies ObjForUpdate = (from objLinq in objPharmaEntities.Hr_EmpCustodies where objLinq.Hdr_Id == ObjEmpCastodyDL.Hdr_Id select objLinq).FirstOrDefault(); if (ObjForUpdate != null) { ObjForUpdate.Emp_Serial_No = ObjEmpCastodyDL.Emp_Serial_No; ObjForUpdate.Custody_Id = ObjEmpCastodyDL.Custody_Id; ObjForUpdate.Transdate = ObjEmpCastodyDL.Transdate; ObjForUpdate.Received_Date = ObjEmpCastodyDL.Received_Date; ObjForUpdate.Custody_Serial_No = ObjEmpCastodyDL.Custody_Serial_No; ObjForUpdate.Custody_Status = ObjEmpCastodyDL.Custody_Status; ObjForUpdate.Custody_Desc = ObjEmpCastodyDL.Custody_Desc; ObjForUpdate.Custody_Note = ObjEmpCastodyDL.Custody_Note; objPharmaEntities.SaveChanges(); return(result); } } } } else { result = false; } } 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(); } return(result); }
public bool SaveTransferData(EmpCastodyDL ObjTransferCastodyDL) { StackFrame stackFrame = new StackFrame(); MethodBase methodBase = stackFrame.GetMethod(); var strErrorMessage = string.Empty; bool result = true; try { OpenEntityConnection(); if (ObjTransferCastodyDL != null) { if (ObjTransferCastodyDL.Hdr_Id != Guid.Empty && ObjTransferCastodyDL.Hdr_Id != null) { //Hr_EmpCustodies_History EmpCustodies = new Hr_EmpCustodies_History //{ // Hdr_Id = ObjTransferCastodyDL.Hdr_Id, // //Rec_Id = GetNewRec_Id(), // Company_Id = ObjTransferCastodyDL.Company_Id, // Branch_Id = ObjTransferCastodyDL.Branch_Id, // Emp_Serial_No = ObjTransferCastodyDL.Emp_Serial_No, // Emp_Serial_No_New = ObjTransferCastodyDL.Emp_Serial_No_New, // Transdate = ObjTransferCastodyDL.Transdate, // Custody_Id = ObjTransferCastodyDL.Custody_Id, // Custody_Serial_No = ObjTransferCastodyDL.Custody_Serial_No, // Custody_Status = ObjTransferCastodyDL.Custody_Status, // Custody_Status_New = ObjTransferCastodyDL.Custody_Status_New, // Custody_Desc = ObjTransferCastodyDL.Custody_Desc, // Custody_Note = ObjTransferCastodyDL.Custody_Note, // Received_Date = ObjTransferCastodyDL.Received_Date, // // Delivery_Date = ObjEmpCastodyDL.Delivery_Date, // Ins_User = UserNameProperty, // Ins_Date = DateTime.Now //}; //objPharmaEntities.Hr_EmpCustodies_History.Add(EmpCustodies); //objPharmaEntities.SaveChanges(); //return result; Hr_EmpCustodies ObjForUpdate = (from objLinq in objPharmaEntities.Hr_EmpCustodies where objLinq.Hdr_Id == ObjTransferCastodyDL.Hdr_Id select objLinq).FirstOrDefault(); if (ObjForUpdate != null) { ObjForUpdate.Emp_Serial_No = ObjTransferCastodyDL.Emp_Serial_No; ObjForUpdate.Transdate = ObjTransferCastodyDL.Transdate; ObjForUpdate.Received_Date = ObjTransferCastodyDL.Received_Date; ObjForUpdate.Custody_Status = ObjTransferCastodyDL.Custody_Status; ObjForUpdate.Custody_Desc = ObjTransferCastodyDL.Custody_Desc; ObjForUpdate.Custody_Note = ObjTransferCastodyDL.Custody_Note; objPharmaEntities.SaveChanges(); return(result); } else { return(false); } } else { return(false); } } else { return(false); } } 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(); } return(result); }
public List <EmpCastodyDL> GetEmpCastodyData(decimal Emp_Serial_No, string Custody_Serial_No, string Company_Id, string Branch_Id) { StackFrame stackFrame = new StackFrame(); MethodBase methodBase = stackFrame.GetMethod(); try { OpenEntityConnection(); List <EmpCastodyDL> objectList = new List <EmpCastodyDL>(); object[] param1 = { new SqlParameter("@Emp_Serial_No", Emp_Serial_No), new SqlParameter("@Custody_Serial_No", Custody_Serial_No), new SqlParameter("@Company_Id", Company_Id), new SqlParameter("@Branch_Id", Branch_Id) }; var objlist = objPharmaEntities.Database.SqlQuery <EmpCastodyDL>("exec dbo.sp_GetEmpCastodyData @Emp_Serial_No ,@Custody_Serial_No, @Company_Id , @Branch_Id", param1).ToList(); foreach (var obj in objlist) { EmpCastodyDL EmpCastodyDL = new EmpCastodyDL(); EmpCastodyDL.Hdr_Id = obj.Hdr_Id; EmpCastodyDL.Rec_Id = obj.Rec_Id; EmpCastodyDL.Rec_No = obj.Rec_No; EmpCastodyDL.Company_Id = obj.Company_Id; EmpCastodyDL.Branch_Id = obj.Branch_Id; EmpCastodyDL.Emp_Serial_No = obj.Emp_Serial_No; EmpCastodyDL.FullNameArabic = obj.FullNameArabic; EmpCastodyDL.FullNameEn = obj.FullNameEn; EmpCastodyDL.Custody_Id = obj.Custody_Id; EmpCastodyDL.Transdate = obj.Transdate; EmpCastodyDL.Custody_Name = obj.Custody_Name; EmpCastodyDL.Custody_NameEn = obj.Custody_NameEn; EmpCastodyDL.Custody_Serial_No = obj.Custody_Serial_No; EmpCastodyDL.Custody_Status = obj.Custody_Status; EmpCastodyDL.Custody_Desc = obj.Custody_Desc; EmpCastodyDL.Custody_Note = obj.Custody_Note; EmpCastodyDL.Received_Date = obj.Received_Date; EmpCastodyDL.Delivery_Date = obj.Delivery_Date; EmpCastodyDL.InsUser = obj.InsUser; EmpCastodyDL.InsDate = obj.InsDate; objectList.Add(EmpCastodyDL); } return(objectList); } 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(null); } finally { CloseEntityConnection(); } }