// Calling the method of using Async
//public int test() {
// int task = Insert().Result;
// return task;
//}
public int InsertTask(Hr_PermissionSubReasons 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_PermissionSubReasons.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_PermissionSubReasons GetById(string PermissionSubReason_ID)
{
StackFrame stackFrame = new StackFrame();
MethodBase methodBase = stackFrame.GetMethod();
try
{
OpenEntityConnection();
Hr_PermissionSubReasons PermissionSubReasonsForGetEntity = (from objLinq in objPharmaEntities.Hr_PermissionSubReasons
where objLinq.PermissionSubReason_Id == PermissionSubReason_ID && objLinq.Rec_Status == 0
select objLinq).FirstOrDefault();
return(PermissionSubReasonsForGetEntity);
}
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_PermissionSubReasons 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_PermissionSubReasons ObjForUpdate = (from objLinq in objPharmaEntities.Hr_PermissionSubReasons
where objLinq.PermissionSubReason_Id == objUpdate.PermissionSubReason_Id
select objLinq).FirstOrDefault();
ObjForUpdate.PermissionSubReason_Name = objUpdate.PermissionSubReason_Name;
ObjForUpdate.PermissionSubReason_NameEn = objUpdate.PermissionSubReason_NameEn;
ObjForUpdate.PermissionReason_Id = objUpdate.PermissionReason_Id;
ObjForUpdate.PermissionSubReason_Code = objUpdate.PermissionSubReason_Code;
ObjForUpdate.Permission_Type = objUpdate.Permission_Type;
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> Delete(Hr_PermissionSubReasons objDelete)
{
StackFrame stackFrame = new StackFrame();
MethodBase methodBase = stackFrame.GetMethod();
int rowEffected = 0;
try
{
if (objDelete != null) //Definsive Programming
{
OpenEntityConnection();
Hr_PermissionSubReasons objForDelete = (from objLinq in objPharmaEntities.Hr_PermissionSubReasons
where objLinq.PermissionSubReason_Id == objDelete.PermissionSubReason_Id
select objLinq).FirstOrDefault();
objForDelete.Rec_Status = 1;
objForDelete.DeleteUser = objDelete.DeleteUser;
objForDelete.DeleteDate = 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 List <Hr_PermissionSubReasons> GetAll()
{
StackFrame stackFrame = new StackFrame();
MethodBase methodBase = stackFrame.GetMethod();
List <Hr_PermissionSubReasons> objlist = new List <Hr_PermissionSubReasons>();
try
{
OpenEntityConnection();
List <Hr_PermissionSubReasons> objectList = (from objLinq in objPharmaEntities.Hr_PermissionSubReasons
where objLinq.Rec_Status == 0
orderby objLinq.Id
select objLinq).ToList();
//PermissionSubReason_Id,PermissionSubReason_Name,PermissionSubReason_NameEn,PermissionSubReason_NameConv,PermissionReason_Id,PermissionSubReason_Code,InsUser,InsDate,UpdateUser,UpdateDate,DeleteUser,DeleteDate,Rec_Status
//string sql = "select * from Hr_PermissionSubReasons where Rec_Status = 0 order by replicate('0',15-len(PermissionSubReason_Id))+PermissionSubReason_Id ";
//List<Hr_PermissionSubReasons> objectlist = objPharmaEntities.Database.SqlQuery<Hr_PermissionSubReasons>(sql).ToList();
if (objectList != null)
{
foreach (var obj in objectList)
{
Hr_PermissionSubReasons obj1 = new Hr_PermissionSubReasons();
obj1.PermissionSubReason_Id = obj.PermissionSubReason_Id;
obj1.PermissionSubReason_Name = obj.PermissionSubReason_Name;
obj1.PermissionSubReason_NameEn = obj.PermissionSubReason_NameEn;
obj1.PermissionSubReason_NameConv = obj.PermissionSubReason_NameConv;
obj1.PermissionReason_Id = obj.PermissionReason_Id;
obj1.Permission_Type = obj.Permission_Type;
obj1.PermissionSubReason_Code = obj.PermissionSubReason_Code;
objlist.Add(obj1);
}
}
return(objlist);
}
catch (System.Data.Entity.Validation.DbEntityValidationException ex)
{
Exception raise = ex;
foreach (var validationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
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());
Exception raise = ex;
ex.InnerException.Message.ToString();
return(null);
}
finally
{
CloseEntityConnection();
}
}
