// Calling the method of using Async //public int test() { // int task = Insert().Result; // return task; //} public int InsertTask(Hr_Nationalities 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_Nationalities.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_Nationalities GetById(string Country_ID) { StackFrame stackFrame = new StackFrame(); MethodBase methodBase = stackFrame.GetMethod(); try { OpenEntityConnection(); Hr_Nationalities CountriesForGetEntity = (from objLinq in objPharmaEntities.Hr_Nationalities where objLinq.Nationality_Id == Country_ID && objLinq.Rec_Status == 0 select objLinq).FirstOrDefault(); return(CountriesForGetEntity); } 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_Nationalities 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_Nationalities ObjForUpdate = (from objLinq in objPharmaEntities.Hr_Nationalities where objLinq.Nationality_Id == objUpdate.Nationality_Id select objLinq).FirstOrDefault(); ObjForUpdate.Nationality_Name = objUpdate.Nationality_Name; ObjForUpdate.Nationality_NameEn = objUpdate.Nationality_NameEn; ObjForUpdate.Nationality_Code = objUpdate.Nationality_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); } }
public List <Hr_Nationalities> GetAll() { StackFrame stackFrame = new StackFrame(); MethodBase methodBase = stackFrame.GetMethod(); List <Hr_Nationalities> objlist = new List <Hr_Nationalities>(); try { OpenEntityConnection(); List <Hr_Nationalities> objectList = (from objLinq in objPharmaEntities.Hr_Nationalities where objLinq.Rec_Status == 0 orderby objLinq.Id select objLinq).ToList(); if (objectList != null) { foreach (var obj in objectList) { Hr_Nationalities obj1 = new Hr_Nationalities(); obj1.Id = obj.Id; obj1.Nationality_Name = obj.Nationality_Name; obj1.Nationality_NameEn = obj.Nationality_NameEn; obj1.Nationality_Id = obj.Nationality_Id; obj1.Nationality_Code = obj.Nationality_Code; objlist.Add(obj1); } } 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(); } }