// Calling the method of using Async //public int test() { // int task = Insert().Result; // return task; //} public int InsertTask(Hr_Hiring_Items 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_Hiring_Items.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 Hr_Hiring_Items GetByIdWithOutBranch(string HireItem_Id) { StackFrame stackFrame = new StackFrame(); MethodBase methodBase = stackFrame.GetMethod(); try { OpenEntityConnection(); Hr_Hiring_Items JobsForGetEntity = (from objLinq in objPharmaEntities.Hr_Hiring_Items where objLinq.HireItem_Id == HireItem_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(); } }
public bool UpdateTaskWithOutBranch(Hr_Hiring_Items 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_Hiring_Items ObjForUpdate = (from objLinq in objPharmaEntities.Hr_Hiring_Items where objLinq.HireItem_Id == objUpdate.HireItem_Id //&& objLinq.Company_Id == objUpdate.Company_Id && objLinq.Branch_Id == objUpdate.Branch_Id select objLinq).FirstOrDefault(); ObjForUpdate.HireItem_Name = objUpdate.HireItem_Name; ObjForUpdate.HireItem_NameEn = objUpdate.HireItem_NameEn; ObjForUpdate.HireItem_Type = objUpdate.HireItem_Type; ObjForUpdate.Account_Type = objUpdate.Account_Type; ObjForUpdate.Hire_Appear_W_Grade = objUpdate.Hire_Appear_W_Grade; ObjForUpdate.JoinEndOfService = objUpdate.JoinEndOfService; ObjForUpdate.CalcAnnually = objUpdate.CalcAnnually; ObjForUpdate.NotIncludeVacAllownce = objUpdate.NotIncludeVacAllownce; ObjForUpdate.AffectsSalaries = objUpdate.AffectsSalaries; ObjForUpdate.Hire_AppearOnlyW_Grades = objUpdate.Hire_AppearOnlyW_Grades; ObjForUpdate.Hire_Status = 0; ObjForUpdate.IsPaymentBorrow = objUpdate.IsPaymentBorrow; 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 async Task <bool> Update(Hr_Hiring_Items objUpdate) { StackFrame stackFrame = new StackFrame(); MethodBase methodBase = stackFrame.GetMethod(); int rowEffected = 0; try { if (objUpdate != null) //Definsive Programming { OpenEntityConnection(); Hr_Hiring_Items ObjForUpdate = (from objLinq in objPharmaEntities.Hr_Hiring_Items where objLinq.HireItem_Id == objUpdate.HireItem_Id select objLinq).FirstOrDefault(); ObjForUpdate.HireItem_Name = objUpdate.HireItem_Name; ObjForUpdate.HireItem_NameEn = objUpdate.HireItem_NameEn; ObjForUpdate.HireItem_Type = objUpdate.HireItem_Type; 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 DeleteTaskWithOutBranch(Hr_Hiring_Items 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_Hiring_Items objForDelete = (from objLinq in objPharmaEntities.Hr_Hiring_Items where objLinq.HireItem_Id == objDelete.HireItem_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); } }