public bool SavePermissionRecordData(List <PermissionRecordDL> objList)
{
StackFrame stackFrame = new StackFrame();
MethodBase methodBase = stackFrame.GetMethod();
try
{
OpenEntityConnection();
int Result = 0;
if (objList != null)
{
foreach (var obj in objList)
{
// data base bind
if (obj.RecStatus == 0)
{
}
//Add
else if (obj.RecStatus == 1)
{
Hr_EmpPermissionRecord newobj = new Hr_EmpPermissionRecord();
newobj.Rec_Hdr_Id = GetNewHeaderId();
newobj.Company_Id = obj.Company_Id;
newobj.Branch_Id = obj.Branch_Id;
newobj.Emp_Serial_No = obj.Emp_Serial_No;
newobj.TransDate = DateTime.Now.ToString("yyyyMMdd");
newobj.PermissionDate = obj.PermissionDate;
newobj.Request_Id = "10";
newobj.Rec_Order_No = "0";
newobj.Rec_Order_HdrId = maxId;
newobj.FromTime = obj.FromTime;
newobj.ToTime = obj.ToTime;
newobj.Permission_Period = obj.Permission_Period;
newobj.InsUser = UserNameProperty;
newobj.InsDate = DateTime.Now;
newobj.DocumentPath = null;
newobj.Commissioner_Serial_no = obj.Emp_Serial_No;
newobj.Permission_Type = obj.Permission_Type;
newobj.HireItem_Id = "0011";
newobj.Permission_Reason_Id = obj.Permission_Reason_Id;
newobj.Permission_Reason_Sub_Id = obj.Permission_Reason_Sub_Id;
newobj.Confirmed = 0;
objPharmaEntities.Hr_EmpPermissionRecord.Add(newobj);
Result = objPharmaEntities.SaveChanges();
}
//Edit
else if (obj.RecStatus == 2)
{
if (obj.Rec_Hdr_Id != Guid.Empty)
{
Hr_EmpPermissionRecord ObjForUpdate = (from objLinq in objPharmaEntities.Hr_EmpPermissionRecord
where objLinq.Rec_Hdr_Id == obj.Rec_Hdr_Id
select objLinq).FirstOrDefault();
if (ObjForUpdate != null)
{
ObjForUpdate.PermissionDate = obj.PermissionDate;
ObjForUpdate.FromTime = obj.FromTime;
ObjForUpdate.ToTime = obj.ToTime;
ObjForUpdate.Permission_Period = obj.Permission_Period;
ObjForUpdate.Permission_Type = obj.Permission_Type;
ObjForUpdate.Emp_Serial_No = obj.Emp_Serial_No;
ObjForUpdate.Permission_Reason_Id = obj.Permission_Reason_Id;
ObjForUpdate.Permission_Reason_Sub_Id = obj.Permission_Reason_Sub_Id;
Result = objPharmaEntities.SaveChanges();
}
}
else
{
Hr_EmpPermissionRecord newobj = new Hr_EmpPermissionRecord();
newobj.Rec_Hdr_Id = GetNewHeaderId();
newobj.Company_Id = obj.Company_Id;
newobj.Branch_Id = obj.Branch_Id;
newobj.Emp_Serial_No = obj.Emp_Serial_No;
newobj.TransDate = DateTime.Now.ToString("yyyyMMdd");
newobj.PermissionDate = obj.PermissionDate;
newobj.Request_Id = "10";
newobj.Rec_Order_No = "0";
newobj.Rec_Order_HdrId = maxId;
newobj.FromTime = obj.FromTime;
newobj.ToTime = obj.ToTime;
newobj.Permission_Period = obj.Permission_Period;
newobj.InsUser = UserNameProperty;
newobj.InsDate = DateTime.Now;
newobj.DocumentPath = null;
newobj.Commissioner_Serial_no = obj.Emp_Serial_No;
newobj.Permission_Type = obj.Permission_Type;
newobj.HireItem_Id = "0011";
newobj.Permission_Reason_Id = obj.Permission_Reason_Id;
newobj.Permission_Reason_Sub_Id = obj.Permission_Reason_Sub_Id;
newobj.Confirmed = 0;
objPharmaEntities.Hr_EmpPermissionRecord.Add(newobj);
Result = objPharmaEntities.SaveChanges();
}
}
//Delete
else if (obj.RecStatus == 3)
{
if (obj.Rec_Hdr_Id != Guid.Empty)
{
Hr_EmpPermissionRecord ObjForDelete = (from objLinq in objPharmaEntities.Hr_EmpPermissionRecord
where objLinq.Rec_Hdr_Id == obj.Rec_Hdr_Id
select objLinq).FirstOrDefault();
if (ObjForDelete != null)
{
objPharmaEntities.Hr_EmpPermissionRecord.Remove(ObjForDelete);
objPharmaEntities.SaveChanges();
}
}
else
{
}
}
else
{
}
}
return(Result > 0);
}
else
{
return(Result < 0);
}
}
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(false);
}
finally
{
CloseEntityConnection();
}
}
public bool SaveRecordData(List <RecordsConfirmationDL> objList)
{
StackFrame stackFrame = new StackFrame();
MethodBase methodBase = stackFrame.GetMethod();
try
{
OpenEntityConnection();
int Result = 0;
if (objList != null)
{
foreach (var obj in objList)
{
if (obj.Record_ID == 0)
{
if (obj.Rec_Hdr_Id != Guid.Empty)
{
Hr_EmpOverTimeRecord ObjForUpdate = (from objLinq in objPharmaEntities.Hr_EmpOverTimeRecord
where objLinq.Rec_Hdr_Id == obj.Rec_Hdr_Id
select objLinq).FirstOrDefault();
if (ObjForUpdate != null)
{
ObjForUpdate.Confirmed = 1;
Result = objPharmaEntities.SaveChanges();
}
}
}
else if (obj.Record_ID == 1)
{
if (obj.Rec_Hdr_Id != Guid.Empty)
{
Hr_EmpPermissionRecord ObjForUpdate = (from objLinq in objPharmaEntities.Hr_EmpPermissionRecord
where objLinq.Rec_Hdr_Id == obj.Rec_Hdr_Id
select objLinq).FirstOrDefault();
if (ObjForUpdate != null)
{
ObjForUpdate.Confirmed = 1;
Result = objPharmaEntities.SaveChanges();
}
}
}
else if (obj.Record_ID == 2)
{
if (obj.Rec_Hdr_Id != Guid.Empty)
{
Hr_EmpDelayRecord ObjForUpdate = (from objLinq in objPharmaEntities.Hr_EmpDelayRecord
where objLinq.Rec_Hdr_Id == obj.Rec_Hdr_Id
select objLinq).FirstOrDefault();
if (ObjForUpdate != null)
{
ObjForUpdate.Confirmed = 1;
Result = objPharmaEntities.SaveChanges();
}
}
}
else if (obj.Record_ID == 3)
{
if (obj.Rec_Hdr_Id != Guid.Empty)
{
Hr_EmpVactionRecord ObjForUpdate = (from objLinq in objPharmaEntities.Hr_EmpVactionRecord
where objLinq.Rec_Hdr_Id == obj.Rec_Hdr_Id
select objLinq).FirstOrDefault();
if (ObjForUpdate != null)
{
ObjForUpdate.Confirmed = 1;
Result = objPharmaEntities.SaveChanges();
}
}
}
else if (obj.Record_ID == 4)
{
if (obj.Rec_Hdr_Id != Guid.Empty)
{
Hr_EmpAbsenceRecord ObjForUpdate = (from objLinq in objPharmaEntities.Hr_EmpAbsenceRecord
where objLinq.Rec_Hdr_Id == obj.Rec_Hdr_Id
select objLinq).FirstOrDefault();
if (ObjForUpdate != null)
{
ObjForUpdate.Confirmed = 1;
Result = objPharmaEntities.SaveChanges();
}
}
}
else
{
}
}
return(Result > 0);
}
else
{
return(Result < 0);
}
}
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(false);
}
finally
{
CloseEntityConnection();
}
}
