public async Task <int> Insert(Hr_EmpOverTimeRequest 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_EmpOverTimeRequest.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_EmpOverTimeRequest 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,OverTimeDate,FromTime,ToTime,Reason,DocumentPath,Order_Status,Commissioner_Serial_no,DayType";
sql = sql + " from Hr_EmpOverTimeRequest where Company_Id='" + strCompanyNo + "' and Branch_Id='" + strBranchNo + "' and Rec_Hdr_Id = '" + RequestHdrId + "'";
Hr_EmpOverTimeRequest obj = objPharmaEntities.Database.SqlQuery <Hr_EmpOverTimeRequest>(sql).FirstOrDefault();
return(obj);
// EmpOverTimeRequestDL objectList = new EmpOverTimeRequestDL();
//Hr_EmpOverTimeRequest obj = (from objLinq in objPharmaEntities.Hr_EmpOverTimeRequest
// 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,
// Reason = objLinq.Reason,
// PlaceOfResidence = objLinq.PlaceOfResidence,
// DocumentPath = objLinq.DocumentPath,
// Order_Status = objLinq.Order_Status
// });
//Hr_EmpOverTimeRequest obj = objPharmaEntities.Hr_EmpOverTimeRequest
// .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,
// Reason = objLinq.Reason,
// 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 ,Reason ,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();
}
}