public int InsertTaskByContext(Hr_EmpEmploymentRequest objInsert, AthelHREntities varContexct)
{
StackFrame stackFrame = new StackFrame();
MethodBase methodBase = stackFrame.GetMethod();
//int result = Insert(objInsert).Result;
//return result;
int RowEffected = 0;
try
{
if (objInsert != null)
{
objInsert.Rec_Hdr_Id = objInsert.Rec_Hdr_Id;
objInsert.InsDate = DateTime.Now;//DateTime.Today;
varContexct.Hr_EmpEmploymentRequest.Add(objInsert);
RowEffected = varContexct.SaveChanges();
//varAthelHREntities.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 async Task <int> Insert(Hr_EmpEmploymentRequest objInsert)
{
StackFrame stackFrame = new StackFrame();
MethodBase methodBase = stackFrame.GetMethod();
int RowEffected = 0;
try
{
if (objInsert != null)
{
OpenEntityConnection();
objInsert.InsDate = DateTime.Now;//DateTime.Today;
objPharmaEntities.Hr_EmpEmploymentRequest.Add(objInsert);
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();
}
return(RowEffected);
}
public Hr_EmpEmploymentRequest GetRequestByHdrId(string strCompanyNo, string strBranchNo, Guid RequestHdrId)
{
StackFrame stackFrame = new StackFrame();
MethodBase methodBase = stackFrame.GetMethod();
try
{
OpenEntityConnection();
string sql = "select Rec_Hdr_Id,ReferenceNo,Request_Id,Rec_No,TransDate,InsUser,InsDate,Company_Id,Branch_Id";
sql = sql + ",Emp_Serial_No,WithinBudget,Admin_Id,Dept_Id,Notes,DocumentPath,Order_Status,Commissioner_Serial_no";
sql = sql + " from Hr_EmpEmploymentRequest where Company_Id='" + strCompanyNo + "' and Branch_Id='" + strBranchNo + "' and Rec_Hdr_Id = '" + RequestHdrId + "'";
Hr_EmpEmploymentRequest obj = objPharmaEntities.Database.SqlQuery <Hr_EmpEmploymentRequest>(sql).FirstOrDefault();
return(obj);
// EmpEmploymentRequestDL objectList = new EmpEmploymentRequestDL();
//Hr_EmpEmploymentRequest obj = (from objLinq in objPharmaEntities.Hr_EmpEmploymentRequest
// where objLinq.Company_Id == strCompanyNo && objLinq.Branch_Id==strBranchNo && objLinq.Rec_Hdr_Id == RequestHdrId
// select objLinq).FirstOrDefault();
// select new
// {
// Rec_Hdr_Id = objLinq.Rec_Hdr_Id,
// ReferenceNo = objLinq.ReferenceNo,
// Request_Id = objLinq.Request_Id,
// Emp_Serial_No = objLinq.Emp_Serial_No,
// FromDate = objLinq.FromDate,
// ToDate = objLinq.ToDate,
// Notes = objLinq.Notes,
// PlaceOfResidence = objLinq.PlaceOfResidence,
// DocumentPath = objLinq.DocumentPath,
// Order_Status = objLinq.Order_Status
// });
//Hr_EmpEmploymentRequest obj = objPharmaEntities.Hr_EmpEmploymentRequest
// .Where(objLinq => objLinq.Company_Id == strCompanyNo && objLinq.Branch_Id == strBranchNo && objLinq.Rec_Hdr_Id == RequestHdrId)
// .Select(
// objLinq =>
// new
// {
// Rec_Hdr_Id = objLinq.Rec_Hdr_Id,
// ReferenceNo = objLinq.ReferenceNo,
// Request_Id = objLinq.Request_Id,
// Emp_Serial_No = objLinq.Emp_Serial_No,
// FromDate = objLinq.FromDate,
// ToDate = objLinq.ToDate,
// Notes = objLinq.Notes,
// PlaceOfResidence = objLinq.PlaceOfResidence,
// DocumentPath = objLinq.DocumentPath,
// Order_Status = objLinq.Order_Status
// });
// return objLinq;
//Rec_No ,ReferenceNo ,Request_Id
//,Company_Id ,Branch_Id ,Emp_Serial_No ,TransDate ,FromDate ,ToDate ,BackDate ,Notes ,InsUser ,InsDate ,Order_Status ,PlaceOfResidence ,DocumentPath ,RequestTypeName ,StatusName
}
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 InsetEmployeementReguest(Hr_EmpEmploymentRequest objInsert, List <Hr_EmploymentQualifyRequest> ListDtlsEmpQulify, List <Hr_EmploymentExperinceRequest> Obj_DtlsExprince)
{
StackFrame stackFrame = new StackFrame();
MethodBase methodBase = stackFrame.GetMethod();
bool result = false;
var strErrorMessage = string.Empty;
try
{
int resultInsertEmployee = 0;
Guid varEmpHdrId;
varEmpHdrId = GetNewHeaderId();
using (AthelHREntities varcontext = new AthelHREntities())
{
using (var dbContextTransaction = varcontext.Database.BeginTransaction())
{
try
{
if (varcontext.Database.Connection.State == System.Data.ConnectionState.Closed)
{
varcontext.Database.Connection.Open();
}
//OpenEntityConnection();
EmploymentExperinceRequestDAL objEmploymentExperince = new EmploymentExperinceRequestDAL();
result = objEmploymentExperince.AddEmploymentExperinceRequestByContext(Obj_DtlsExprince, varEmpHdrId, UserNameProperty, varcontext);
if (result)
{
//EmpSpousesDAL objEmpSpouses = new EmpSpousesDAL();
//result = objEmpSpouses.AddEmpSpousesByContext(ListDtlsEmpSpouses, varEmpHdrId, UserNameProperty, varcontext);
//if (result)
//{
EmploymentQualifyRequestDAL objEmploymentQulify = new EmploymentQualifyRequestDAL();
result = objEmploymentQulify.AddEmploymentQualifyRequestByContext(ListDtlsEmpQulify, varEmpHdrId, UserNameProperty, varcontext);
if (result)
{
EmpEmploymentRequestDAL objEmp = new EmpEmploymentRequestDAL();
objInsert.Rec_Hdr_Id = varEmpHdrId;
objInsert.InsUser = UserNameProperty;
resultInsertEmployee = objEmp.InsertTaskByContext(objInsert, varcontext);
result = (resultInsertEmployee > 0);
varcontext.SaveChanges();
dbContextTransaction.Commit();
}
}
//}
else
{
dbContextTransaction.Rollback();
result = false;
}
}
catch (DbEntityValidationException ex)
{
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();
dbContextTransaction.Rollback();
result = false;
}
//--- End Try Of Using
catch (Exception ex)
{
dbContextTransaction.Rollback(); //Required according to MSDN article
throw; //Not in MSDN article, but recommended so the exception still bubbles up
}
finally
{
varcontext.Database.Connection.Close();
dbContextTransaction.Dispose();
}
//--- End catch
}
//--- End Using
}
}
//--- End Try
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);
}
