public Hr_RequestTypes GetByIdWithOutBranch(string Request_Id) { StackFrame stackFrame = new StackFrame(); MethodBase methodBase = stackFrame.GetMethod(); try { OpenEntityConnection(); Hr_RequestTypes JobsForGetEntity = (from objLinq in objPharmaEntities.Hr_RequestTypes where objLinq.Request_Id == Request_Id && objLinq.Rec_Status == 0 select objLinq).FirstOrDefault(); return(JobsForGetEntity); } 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(); } }
// Calling the method of using Async //public int test() { // int task = Insert().Result; // return task; //} public int InsertTask(Hr_RequestTypes objInsert) { StackFrame stackFrame = new StackFrame(); MethodBase methodBase = stackFrame.GetMethod(); //int result = Insert(objInsert).Result; //return result; int RowEffected = 0; try { if (objInsert != null) { OpenEntityConnection(); objInsert.InsDate = DateTime.Now;//DateTime.Today; objPharmaEntities.Hr_RequestTypes.Add(objInsert); RowEffected = objPharmaEntities.SaveChanges(); } } 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()); RowEffected = -1; ex.InnerException.Message.ToString(); } finally { CloseEntityConnection(); } return(RowEffected); }
public bool UpdateTaskWithOutBranch(Hr_RequestTypes objUpdate) { StackFrame stackFrame = new StackFrame(); MethodBase methodBase = stackFrame.GetMethod(); // bool task = Update(objInsert).Result; //return task; int rowEffected = 0; try { if (objUpdate != null) //Definsive Programming { OpenEntityConnection(); Hr_RequestTypes ObjForUpdate = (from objLinq in objPharmaEntities.Hr_RequestTypes where objLinq.Request_Id == objUpdate.Request_Id // && objLinq.Company_Id == objUpdate.Company_Id && objLinq.Branch_Id == objUpdate.Branch_Id select objLinq).FirstOrDefault(); ObjForUpdate.Request_Name = objUpdate.Request_Name; ObjForUpdate.Request_NameEn = objUpdate.Request_NameEn; ObjForUpdate.RequestType = objUpdate.RequestType; ObjForUpdate.AttachIsNecessary = objUpdate.AttachIsNecessary; ObjForUpdate.VactionIndivisible = objUpdate.VactionIndivisible; ObjForUpdate.SendOnlyToManger = objUpdate.SendOnlyToManger; ObjForUpdate.ChkJoinHireItem = objUpdate.ChkJoinHireItem; ObjForUpdate.HireItem_Id = objUpdate.HireItem_Id; ObjForUpdate.UpdateUser = objUpdate.UpdateUser; ObjForUpdate.UpdateDate = DateTime.Now; rowEffected = objPharmaEntities.SaveChanges(); } } 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()); rowEffected = -1; ex.InnerException.Message.ToString(); } finally { CloseEntityConnection(); } if (rowEffected > 0) { return(true); } else { return(false); } }
public bool DeleteTask(Hr_RequestTypes objDelete) { StackFrame stackFrame = new StackFrame(); MethodBase methodBase = stackFrame.GetMethod(); // bool task = Delete(objInsert).Result; // return task; int rowEffected = 0; try { if (objDelete != null) //Definsive Programming { OpenEntityConnection(); Hr_RequestTypes objForDelete = (from objLinq in objPharmaEntities.Hr_RequestTypes where objLinq.Request_Id == objDelete.Request_Id && objLinq.Company_Id == objDelete.Company_Id && objLinq.Branch_Id == objDelete.Branch_Id select objLinq).FirstOrDefault(); objForDelete.Rec_Status = 1; objForDelete.DeleteUser = objDelete.DeleteUser; objForDelete.DeleteDate = DateTime.Now; rowEffected = objPharmaEntities.SaveChanges(); } } 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()); rowEffected = -1; ex.InnerException.Message.ToString(); } finally { CloseEntityConnection(); } if (rowEffected > 0) { return(true); } else { return(false); } }
public async Task <bool> Update(Hr_RequestTypes objUpdate) { StackFrame stackFrame = new StackFrame(); MethodBase methodBase = stackFrame.GetMethod(); int rowEffected = 0; try { if (objUpdate != null) //Definsive Programming { OpenEntityConnection(); Hr_RequestTypes ObjForUpdate = (from objLinq in objPharmaEntities.Hr_RequestTypes where objLinq.Request_Id == objUpdate.Request_Id select objLinq).FirstOrDefault(); ObjForUpdate.Request_Name = objUpdate.Request_Name; ObjForUpdate.Request_NameEn = objUpdate.Request_NameEn; ObjForUpdate.RequestType = objUpdate.RequestType; ObjForUpdate.UpdateUser = objUpdate.UpdateUser; ObjForUpdate.UpdateDate = DateTime.Now; rowEffected = await objPharmaEntities.SaveChangesAsync(); } } 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()); rowEffected = -1; ex.InnerException.Message.ToString(); } finally { CloseEntityConnection(); } if (rowEffected > 0) { return(true); } else { return(false); } }
public bool AddNewDataWithDtls(Hr_RequestTypes ObjHdrDL, List <Hr_RequestTypesDtls> ListDtls) { StackFrame stackFrame = new StackFrame(); MethodBase methodBase = stackFrame.GetMethod(); var strErrorMessage = string.Empty; // ObjWorkFlow_HdrDL.InsUser = "******"; ObjHdrDL.InsDate = DateTime.Now; // ObjCommTransHeaderDL.InsDate = DateTime.Now.ToString("dd/MM/yyyy"); bool result = true; using (System.Data.Entity.DbContextTransaction dbTran = objPharmaEntities.Database.BeginTransaction()) { try { if (objPharmaEntities.Database.Connection.State == System.Data.ConnectionState.Closed) { objPharmaEntities.Database.Connection.Open(); } Hr_RequestTypes loclHdr = new Hr_RequestTypes { Request_Id = ObjHdrDL.Request_Id, Request_Name = ObjHdrDL.Request_Name, Request_NameEn = ObjHdrDL.Request_NameEn, AttachIsNecessary = ObjHdrDL.AttachIsNecessary, RequestType = ObjHdrDL.RequestType, VactionIndivisible = ObjHdrDL.VactionIndivisible, SendOnlyToManger = ObjHdrDL.SendOnlyToManger, InsUser = ObjHdrDL.InsUser, InsDate = ObjHdrDL.InsDate }; objPharmaEntities.Hr_RequestTypes.Add(loclHdr); //saves all above operations within one transaction objPharmaEntities.SaveChanges(); foreach (Hr_RequestTypesDtls Obj_Dtls in ListDtls) { if (Obj_Dtls != null) { Hr_RequestTypesDtls loclDtls = new Hr_RequestTypesDtls { RequestTypeId = loclHdr.Request_Id, RequestDiscountType = Obj_Dtls.RequestDiscountType, RequestTypeValue = Obj_Dtls.RequestTypeValue, RequestRatioValue = Obj_Dtls.RequestRatioValue, }; objPharmaEntities.Hr_RequestTypesDtls.Add(loclDtls); //saves all above operations within one transaction objPharmaEntities.SaveChanges(); } } //commit transaction dbTran.Commit(); } catch (DbEntityValidationException ex) { // Retrieve the error messages as a list of strings. var errorMessages = ex.EntityValidationErrors .SelectMany(x => x.ValidationErrors) .Select(x => x.ErrorMessage); // Join the list to a single string. var fullErrorMessage = string.Join("; ", errorMessages); // Combine the original exception message with the new one. var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage); strErrorMessage = fullErrorMessage; // Throw a new DbEntityValidationException with the improved exception message. throw new DbEntityValidationException(exceptionMessage, ex.EntityValidationErrors); //((System.Data.Entity.Validation.DbEntityValidationException)$exception).EntityValidationErrors.First().ValidationErrors.First().ErrorMessage dbTran.Rollback(); result = false; } catch (Exception ex) { //Rollback transaction if exception occurs dbTran.Rollback(); result = false; } finally { objPharmaEntities.Database.Connection.Close(); dbTran.Dispose(); if (!string.IsNullOrEmpty(strErrorMessage)) { SaveErrorLog(System.Runtime.InteropServices.Marshal.GetExceptionCode().ToString(), strErrorMessage, this.UserNameProperty.ToString(), this.GetType().Name.ToString(), methodBase.Name.ToString()); } } return(result); } }