public PrdDyingMRRMaster GenerateMrrUpdate(vmPrdDyingMRRMaster master, List <vmPrdDyingMRRDetail> details, UserCommonEntity commonEntity)
{
PrdDyingMRRMaster MRR = new PrdDyingMRRMaster();
DateTime serverDate = DateTime.Now;
String HostID = HostService.GetIP();
ERP_Entities context = new ERP_Entities();
PrdDyingMRRMaster masterDatafromdb = context.PrdDyingMRRMasters.Where(X => X.DyingMRRID == master.DyingMRRID).FirstOrDefault();
serverDate = context.Database.SqlQuery <DateTime>("SELECT getdate()").AsEnumerable().First();
Int64 MasterID = 0; long detialsID = 0;
MasterID = context.Database.SqlQuery <Int64>(" Select ISNULL(max(DyingMRRID), 0) +1 from PrdDyingMRRMaster").AsEnumerable().First();
detialsID = context.Database.SqlQuery <Int64>(" Select ISNULL(max(DyingMRRDetailID), 0) +1 from PrdDyingMRRDetail").AsEnumerable().First();
PrdDyingMRRDetail_IEF = new PrdDyingMRRDetail_EF();
List <PrdDyingMRRDetail> insertionList = new List <PrdDyingMRRDetail>();
try
{
MRR.DyingMRRID = master.DyingMRRID;
MRR.DyingMRRNo = MRR.DyingMRRID.ToString();
MRR.DyingSetNo = master.DyingSetNo;
MRR.MachineID = master.MachineID;
MRR.ItemID = master.ItemID;
MRR.KGPreMin = master.KGPreMin;
MRR.Moiture = master.Moiture;
MRR.Speed = master.Speed;
MRR.TotalLength = master.TotalLength;
MRR.ShiftID = master.ShiftID;
MRR.EndTime = master.EndTime == null?TimeSpan.Parse("0:00") : master.EndTime;
MRR.StartTime = master.StartTime == null?TimeSpan.Parse("0:00") : master.StartTime;
MRR.Description = master.Description;
MRR.Description = "";
MRR.BuyerID = master.BuyerID;
MRR.RefSetID = (int)master.RefSetID;
MRR.RefSetDate = master.RefSetDate;
MRR.Date = master.Date;
MRR.CompanyID = commonEntity.loggedCompnyID ?? 0;
if (master.EntityState == "Insert")
{
MRR.CreateBy = commonEntity.loggedUserID;
MRR.CreateOn = serverDate;
MRR.CreatePc = HostID;
}
if (master.EntityState == "Update")
{
MRR.CreateBy = masterDatafromdb.CreateBy;
MRR.CreateOn = masterDatafromdb.CreateOn;
MRR.CreatePc = masterDatafromdb.CreatePc;
MRR.UpdateBy = commonEntity.loggedUserID;
MRR.UpdateOn = serverDate;
MRR.UpdatePc = HostID;
}
MRR.IsDeleted = master.IsDeleted;
if (MRR.IsDeleted)
{
MRR.DeleteBy = commonEntity.loggedUserID;
MRR.DeleteOn = serverDate;
MRR.DeletePc = HostID;
}
foreach (vmPrdDyingMRRDetail item in details)
{
PrdDyingMRRDetail detail = new PrdDyingMRRDetail();
if (item.EntityState == "Insert")
{
detail.DyingMRRDetailID = ++detialsID;
}
else
{
detail.DyingMRRDetailID = item.DyingMRRDetailID;
}
detail.DyingMRRID = MRR.DyingMRRID;
detail.DyingProcessID = item.DyingProcessID;
detail.Time = item.Time;
detail.OperationID = item.OperationID;
detail.Quantity = item.Quantity;
detail.UnitID = item.UnitID;
detail.CompanyID = commonEntity.loggedCompnyID ?? 0;
if (item.EntityState == "Insert")
{
detail.CreateBy = commonEntity.loggedUserID;
detail.CreateOn = serverDate;
detail.CreatePc = HostID;
}
if (item.EntityState == "Update")
{
detail.CreateBy = item.CreateBy;
detail.CreateOn = item.CreateOn;
detail.CreatePc = item.CreatePc;
detail.UpdateBy = commonEntity.loggedUserID;
detail.UpdateOn = serverDate;
detail.UpdatePc = HostID;
}
detail.IsDeleted = item.IsDeleted;
if (detail.IsDeleted)
{
detail.DeleteBy = commonEntity.loggedUserID;
detail.DeleteOn = serverDate;
detail.DeletePc = HostID;
}
if (item.EntityState == "Update")
{
MRR.PrdDyingMRRDetails.Add(detail);
}
else
{
insertionList.Add(detail);
}
}
if (insertionList.Count > 0)
{
PrdDyingMRRDetail_IEF.InsertList(insertionList);
PrdDyingMRRDetail_IEF.Save();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
return(MRR);
}
public PrdDyingMRRMaster GenerateMrrSave(vmPrdDyingMRRMaster master, List <vmPrdDyingMRRDetail> details, UserCommonEntity commonEntity)
{
PrdDyingMRRMaster MRR = new PrdDyingMRRMaster();
DateTime serverDate = DateTime.Now;
String HostID = HostService.GetIP();
ERP_Entities context = new ERP_Entities();
serverDate = context.Database.SqlQuery <DateTime>("SELECT getdate()").AsEnumerable().First();
Int64 MasterID = 0; long detialsID = 0;
MasterID = context.Database.SqlQuery <Int64>(" Select ISNULL(max(DyingMRRID), 0) +1 from PrdDyingMRRMaster").AsEnumerable().First();
detialsID = context.Database.SqlQuery <Int64>(" Select ISNULL(max(DyingMRRDetailID), 0) +1 from PrdDyingMRRDetail").AsEnumerable().First();
string startTime = "7:00 AM";
TimeSpan ts;
TimeSpan.TryParse(startTime, out ts);
try
{
MRR.DyingMRRID = MasterID;
MRR.DyingMRRNo = MRR.DyingMRRID.ToString();
MRR.DyingSetNo = master.DyingSetNo;
MRR.MachineID = master.MachineID;
MRR.ItemID = master.ItemID;
MRR.KGPreMin = master.KGPreMin;
MRR.Moiture = master.Moiture;
MRR.Speed = master.Speed;
MRR.TotalLength = master.TotalLength;
MRR.ShiftID = master.ShiftID;
MRR.EndTime = master.EndTime == null?TimeSpan.Parse("0:00") : master.EndTime;
MRR.StartTime = master.StartTime == null?TimeSpan.Parse("0:00") : master.StartTime;
MRR.Description = master.Description;
MRR.Description = "";
MRR.BuyerID = master.BuyerID;
MRR.RefSetID = (int)master.RefSetID;
MRR.RefSetDate = master.RefSetDate;
MRR.Date = master.Date;
MRR.CompanyID = commonEntity.loggedCompnyID ?? 0;
MRR.CreateBy = commonEntity.loggedUserID;
MRR.CreateOn = master.CreateOn;
MRR.CreatePc = HostID;
//MRR.UpdateBy = master.UpdateBy;
//MRR.UpdateOn = master.UpdateOn;
//MRR.UpdatePc = master.UpdatePc;
MRR.IsDeleted = master.IsDeleted;
//MRR.DeleteBy = master.DeleteBy;
//MRR.DeleteOn = master.DeleteOn;
//MRR.DeletePc = master.DeletePc;
foreach (vmPrdDyingMRRDetail item in details)
{
PrdDyingMRRDetail detail = new PrdDyingMRRDetail();
detail.DyingMRRDetailID = ++detialsID;
detail.DyingMRRID = MRR.DyingMRRID;
detail.DyingProcessID = item.DyingProcessID;
detail.Time = item.Time;
detail.OperationID = item.OperationID;
detail.Quantity = item.Quantity;
detail.UnitID = item.UnitID;
detail.CompanyID = commonEntity.loggedCompnyID ?? 0;;
detail.CreateBy = commonEntity.loggedUserID;
detail.CreateOn = serverDate;
detail.CreatePc = HostID;
//detail.UpdateBy = item.UpdateBy;
//detail.UpdateOn = item.UpdateOn;
//detail.UpdatePc = item.UpdatePc;
detail.IsDeleted = item.IsDeleted;
//detail.DeleteBy = item.DeleteBy;
//detail.DeleteOn = item.DeleteOn;
//detail.DeletePc = item.DeletePc;
MRR.PrdDyingMRRDetails.Add(detail);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
return(MRR);
}
