public bool SaveEmpCastodyData(EmpCastodyDL ObjEmpCastodyDL)
{
StackFrame stackFrame = new StackFrame();
MethodBase methodBase = stackFrame.GetMethod();
var strErrorMessage = string.Empty;
bool result = true;
try
{
OpenEntityConnection();
// result = AddShiftGroup(ObjGroupD);
if (ObjEmpCastodyDL != null)
{
if (ObjEmpCastodyDL.Hdr_Id == Guid.Empty || ObjEmpCastodyDL.Hdr_Id == null)
{
if (ObjEmpCastodyDL.IsEdit == 0)
{
Hr_EmpCustodies EmpCustodies = new Hr_EmpCustodies
{
Hdr_Id = GetNewHeaderId(),
Rec_Id = GetNewRec_Id(),
Company_Id = ObjEmpCastodyDL.Company_Id,
Branch_Id = ObjEmpCastodyDL.Branch_Id,
Emp_Serial_No = ObjEmpCastodyDL.Emp_Serial_No,
Transdate = ObjEmpCastodyDL.Transdate,
Custody_Id = ObjEmpCastodyDL.Custody_Id,
Custody_Serial_No = ObjEmpCastodyDL.Custody_Serial_No,
Custody_Status = ObjEmpCastodyDL.Custody_Status,
Custody_Desc = ObjEmpCastodyDL.Custody_Desc,
Custody_Note = ObjEmpCastodyDL.Custody_Note,
Received_Date = ObjEmpCastodyDL.Received_Date,
// Delivery_Date = ObjEmpCastodyDL.Delivery_Date,
Ins_User = UserNameProperty,
Ins_Date = DateTime.Now
};
objPharmaEntities.Hr_EmpCustodies.Add(EmpCustodies);
objPharmaEntities.SaveChanges();
return(result);
}
}
//return result;
else
{
if (ObjEmpCastodyDL.IsEdit == 1)
{
Hr_EmpCustodies ObjForUpdate = (from objLinq in objPharmaEntities.Hr_EmpCustodies
where objLinq.Hdr_Id == ObjEmpCastodyDL.Hdr_Id
select objLinq).FirstOrDefault();
if (ObjForUpdate != null)
{
ObjForUpdate.Emp_Serial_No = ObjEmpCastodyDL.Emp_Serial_No;
ObjForUpdate.Custody_Id = ObjEmpCastodyDL.Custody_Id;
ObjForUpdate.Transdate = ObjEmpCastodyDL.Transdate;
ObjForUpdate.Received_Date = ObjEmpCastodyDL.Received_Date;
ObjForUpdate.Custody_Serial_No = ObjEmpCastodyDL.Custody_Serial_No;
ObjForUpdate.Custody_Status = ObjEmpCastodyDL.Custody_Status;
ObjForUpdate.Custody_Desc = ObjEmpCastodyDL.Custody_Desc;
ObjForUpdate.Custody_Note = ObjEmpCastodyDL.Custody_Note;
objPharmaEntities.SaveChanges();
return(result);
}
}
}
}
else
{
result = false;
}
}
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();
}
return(result);
}
public bool SaveTransferData(EmpCastodyDL ObjTransferCastodyDL)
{
StackFrame stackFrame = new StackFrame();
MethodBase methodBase = stackFrame.GetMethod();
var strErrorMessage = string.Empty;
bool result = true;
try
{
OpenEntityConnection();
if (ObjTransferCastodyDL != null)
{
if (ObjTransferCastodyDL.Hdr_Id != Guid.Empty && ObjTransferCastodyDL.Hdr_Id != null)
{
//Hr_EmpCustodies_History EmpCustodies = new Hr_EmpCustodies_History
//{
// Hdr_Id = ObjTransferCastodyDL.Hdr_Id,
// //Rec_Id = GetNewRec_Id(),
// Company_Id = ObjTransferCastodyDL.Company_Id,
// Branch_Id = ObjTransferCastodyDL.Branch_Id,
// Emp_Serial_No = ObjTransferCastodyDL.Emp_Serial_No,
// Emp_Serial_No_New = ObjTransferCastodyDL.Emp_Serial_No_New,
// Transdate = ObjTransferCastodyDL.Transdate,
// Custody_Id = ObjTransferCastodyDL.Custody_Id,
// Custody_Serial_No = ObjTransferCastodyDL.Custody_Serial_No,
// Custody_Status = ObjTransferCastodyDL.Custody_Status,
// Custody_Status_New = ObjTransferCastodyDL.Custody_Status_New,
// Custody_Desc = ObjTransferCastodyDL.Custody_Desc,
// Custody_Note = ObjTransferCastodyDL.Custody_Note,
// Received_Date = ObjTransferCastodyDL.Received_Date,
// // Delivery_Date = ObjEmpCastodyDL.Delivery_Date,
// Ins_User = UserNameProperty,
// Ins_Date = DateTime.Now
//};
//objPharmaEntities.Hr_EmpCustodies_History.Add(EmpCustodies);
//objPharmaEntities.SaveChanges();
//return result;
Hr_EmpCustodies ObjForUpdate = (from objLinq in objPharmaEntities.Hr_EmpCustodies
where objLinq.Hdr_Id == ObjTransferCastodyDL.Hdr_Id
select objLinq).FirstOrDefault();
if (ObjForUpdate != null)
{
ObjForUpdate.Emp_Serial_No = ObjTransferCastodyDL.Emp_Serial_No;
ObjForUpdate.Transdate = ObjTransferCastodyDL.Transdate;
ObjForUpdate.Received_Date = ObjTransferCastodyDL.Received_Date;
ObjForUpdate.Custody_Status = ObjTransferCastodyDL.Custody_Status;
ObjForUpdate.Custody_Desc = ObjTransferCastodyDL.Custody_Desc;
ObjForUpdate.Custody_Note = ObjTransferCastodyDL.Custody_Note;
objPharmaEntities.SaveChanges();
return(result);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
else
{
return(false);
}
}
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();
}
return(result);
}
public List <EmpCastodyDL> GetEmpCastodyData(decimal Emp_Serial_No, string Custody_Serial_No, string Company_Id, string Branch_Id)
{
StackFrame stackFrame = new StackFrame();
MethodBase methodBase = stackFrame.GetMethod();
try
{
OpenEntityConnection();
List <EmpCastodyDL> objectList = new List <EmpCastodyDL>();
object[] param1 =
{
new SqlParameter("@Emp_Serial_No", Emp_Serial_No),
new SqlParameter("@Custody_Serial_No", Custody_Serial_No),
new SqlParameter("@Company_Id", Company_Id),
new SqlParameter("@Branch_Id", Branch_Id)
};
var objlist = objPharmaEntities.Database.SqlQuery <EmpCastodyDL>("exec dbo.sp_GetEmpCastodyData @Emp_Serial_No ,@Custody_Serial_No, @Company_Id , @Branch_Id", param1).ToList();
foreach (var obj in objlist)
{
EmpCastodyDL EmpCastodyDL = new EmpCastodyDL();
EmpCastodyDL.Hdr_Id = obj.Hdr_Id;
EmpCastodyDL.Rec_Id = obj.Rec_Id;
EmpCastodyDL.Rec_No = obj.Rec_No;
EmpCastodyDL.Company_Id = obj.Company_Id;
EmpCastodyDL.Branch_Id = obj.Branch_Id;
EmpCastodyDL.Emp_Serial_No = obj.Emp_Serial_No;
EmpCastodyDL.FullNameArabic = obj.FullNameArabic;
EmpCastodyDL.FullNameEn = obj.FullNameEn;
EmpCastodyDL.Custody_Id = obj.Custody_Id;
EmpCastodyDL.Transdate = obj.Transdate;
EmpCastodyDL.Custody_Name = obj.Custody_Name;
EmpCastodyDL.Custody_NameEn = obj.Custody_NameEn;
EmpCastodyDL.Custody_Serial_No = obj.Custody_Serial_No;
EmpCastodyDL.Custody_Status = obj.Custody_Status;
EmpCastodyDL.Custody_Desc = obj.Custody_Desc;
EmpCastodyDL.Custody_Note = obj.Custody_Note;
EmpCastodyDL.Received_Date = obj.Received_Date;
EmpCastodyDL.Delivery_Date = obj.Delivery_Date;
EmpCastodyDL.InsUser = obj.InsUser;
EmpCastodyDL.InsDate = obj.InsDate;
objectList.Add(EmpCastodyDL);
}
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();
}
}
