public vmPrdDyingMRRMaster GetProcessByID(int?companyID, int?loggedUser, int?DyingMRRID)
{
vmPrdDyingMRRMaster retunList = new vmPrdDyingMRRMaster();
try
{
DyingChemicalConsumptionMgt service = new DyingChemicalConsumptionMgt();
retunList = service.GetProcessByID(companyID, loggedUser, DyingMRRID);
}
catch (Exception e)
{
e.ToString();
}
return(retunList);
}
public int SaveMRR(vmPrdDyingMRRMaster master, List <vmPrdDyingMRRDetail> details, UserCommonEntity commonEntity)
{
int result = (int)ResponseMessage.Error;
try
{
PrdDyingMRRMaster entity = new PrdDyingMRRMaster();
PrdDyingMRRMaster_IEF = new PrdDyingMRRMaster_EF();
if (master.EntityState == "Insert")
{
entity = GenerateMrrSave(master, details, commonEntity);
PrdDyingMRRMaster_IEF.Insert(entity);
PrdDyingMRRMaster_IEF.Save();
}
else
{
entity = GenerateMrrUpdate(master, details, commonEntity);
PrdDyingMRRMaster_IEF.Update(entity);
if (entity.PrdDyingMRRDetails.Count() > 0)
{
PrdDyingMRRDetail_IEF = new PrdDyingMRRDetail_EF();
PrdDyingMRRDetail_IEF.UpdateList(entity.PrdDyingMRRDetails);
PrdDyingMRRDetail_IEF.Save();
}
PrdDyingMRRMaster_IEF.Save();
}
result = (int)entity.DyingMRRID;
}
catch (Exception ex)
{
ex.Message.ToString();
result = (int)ResponseMessage.Exception;
}
return(result);
}
public IHttpActionResult SaveMRR(object[] data)
{
int result = 0;
vmPrdDyingMRRMaster master = JsonConvert.DeserializeObject <vmPrdDyingMRRMaster>(data[0].ToString());
List <vmPrdDyingMRRDetail> DetailsList = JsonConvert.DeserializeObject <List <vmPrdDyingMRRDetail> >(data[1].ToString());
#region Shared Entity
UserCommonEntity commonEntity = JsonConvert.DeserializeObject <UserCommonEntity>(data[2].ToString());
#endregion Shared Entity
try
{
DyingChemicalConsumptionMgt service = new DyingChemicalConsumptionMgt();
result = service.SaveMRR(master, DetailsList, commonEntity);
}
catch (Exception e)
{
e.ToString();
result = 0;
}
return(Json(new
{
result
}));
}
public vmPrdDyingMRRMaster GetProcessByID(int?companyID, int?loggedUser, int?DyingMRRID)
{
vmPrdDyingMRRMaster returnList = new vmPrdDyingMRRMaster();
try
{
using (ERP_Entities context = new ERP_Entities())
{
returnList = (from process in context.PrdDyingMRRMasters
join item in context.CmnItemMasters on process.ItemID equals item.ItemID into itemGroup
from ig in itemGroup.DefaultIfEmpty()
join mc in context.PrdWeavingMachinConfigs on process.MachineID equals mc.MachineConfigID into mcGroup
from mg in mcGroup.DefaultIfEmpty()
join shift in context.HRMShifts on process.ShiftID equals shift.ShiftID into shiftGroup
from sg in shiftGroup.DefaultIfEmpty()
where process.CompanyID == companyID && process.IsDeleted == false &&
process.DyingMRRID == DyingMRRID
select new vmPrdDyingMRRMaster
{
DyingMRRID = process.DyingMRRID,
DyingMRRNo = process.DyingMRRNo,
DyingSetNo = process.DyingSetNo,
MachineID = process.MachineID,
MachineConfigNo = mg.MachineConfigNo ?? "",
ItemID = process.ItemID ?? 0,
ArticleNo = ig.ArticleNo ?? "",
Date = process.Date,
KGPreMin = process.KGPreMin,
Moiture = process.Moiture,
Speed = process.Speed,
TotalLength = process.TotalLength,
ShiftID = process.ShiftID,
ShiftName = sg.ShiftName ?? "",
EndTime = process.EndTime,
StartTime = process.StartTime,
Description = process.Description,
BuyerID = process.BuyerID,
RefSetID = process.RefSetID,
RefSetDate = process.RefSetDate,
CompanyID = process.CompanyID,
CreateBy = process.CreateBy,
CreateOn = process.CreateOn,
CreatePc = process.CreatePc,
UpdateBy = process.UpdateBy,
UpdateOn = process.UpdateOn,
UpdatePc = process.UpdatePc,
IsDeleted = process.IsDeleted,
DeleteBy = process.DeleteBy,
DeleteOn = process.DeleteOn,
DeletePc = process.DeletePc,
EntityState = "Update",
}).ToList().FirstOrDefault();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message.ToString());
}
return(returnList);
}
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);
}
