// Calling the method of using Async //public int test() { // int task = Insert().Result; // return task; //} public int InsertTask(Hr_DocumentTypes 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_DocumentTypes.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_DocumentTypes GetById(string Doc_Type_ID) { StackFrame stackFrame = new StackFrame(); MethodBase methodBase = stackFrame.GetMethod(); try { OpenEntityConnection(); Hr_DocumentTypes DocumentTypesForGetEntity = (from objLinq in objPharmaEntities.Hr_DocumentTypes where objLinq.Doc_Type_Id == Doc_Type_ID && objLinq.Rec_Status == 0 select objLinq).FirstOrDefault(); return(DocumentTypesForGetEntity); } 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 List <Hr_DocumentTypes> GetAll() { StackFrame stackFrame = new StackFrame(); MethodBase methodBase = stackFrame.GetMethod(); try { OpenEntityConnection(); List <Hr_DocumentTypes> objlist = new List <Hr_DocumentTypes>(); string sql = " Select Doc_Type_Id,Doc_Type_Code,Doc_Type_Name,Doc_Type_NameEn,Doc_Type,Doc_Type_NameConv,InsUser, InsDate,UpdateUser, UpdateDate, Rec_Status, DeleteUser, DeleteDate,Id "; sql = sql + " FROM Hr_DocumentTypes where Rec_Status = 0 "; sql = sql + " Order by Id"; List <Hr_DocumentTypes> objectList = objPharmaEntities.Database.SqlQuery <Hr_DocumentTypes>(sql).ToList(); if (objectList != null) { foreach (var obj in objectList) { Hr_DocumentTypes objHr_DocumentTypes = new Hr_DocumentTypes(); objHr_DocumentTypes.Doc_Type_Id = obj.Doc_Type_Id; objHr_DocumentTypes.Doc_Type_Code = obj.Doc_Type_Code; objHr_DocumentTypes.Doc_Type_Name = obj.Doc_Type_Name; objHr_DocumentTypes.Doc_Type_NameEn = obj.Doc_Type_NameEn; objHr_DocumentTypes.Doc_Type_NameConv = obj.Doc_Type_NameConv; objHr_DocumentTypes.Doc_Type = obj.Doc_Type; objHr_DocumentTypes.Rec_Status = obj.Rec_Status; objlist.Add(objHr_DocumentTypes); } } //List<Hr_DocumentTypes> objectList = (from objLinq in objPharmaEntities.Hr_DocumentTypes // where objLinq.Rec_Status == 0 // select objLinq).ToList(); return(objlist); } 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 UpdateTask(Hr_DocumentTypes 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_DocumentTypes ObjForUpdate = (from objLinq in objPharmaEntities.Hr_DocumentTypes where objLinq.Doc_Type_Id == objUpdate.Doc_Type_Id select objLinq).FirstOrDefault(); ObjForUpdate.Doc_Type_Name = objUpdate.Doc_Type_Name; ObjForUpdate.Doc_Type_NameEn = objUpdate.Doc_Type_NameEn; ObjForUpdate.Doc_Type = objUpdate.Doc_Type; ObjForUpdate.Doc_Type_Code = objUpdate.Doc_Type_Code; 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); } }