public DataLayer.PP_WasteCanbanInfo ConvertToTable(WasteCanbanInfoModel model)
{
DataLayer.PP_WasteCanbanInfo tbl = new DataLayer.PP_WasteCanbanInfo();
tbl.WasteCanbanID = model.WasteCanbanID;
tbl.FacilityID = model.FacilityID;
tbl.WorkerID = model.WorkerID;
tbl.WasteSourceID = model.WasteSourceID;
tbl.WTrackingCode = model.WTrackingCode;
tbl.WPackageCode = model.WPackageCode;
tbl.WInventoryCode = model.WInventoryCode;
tbl.InputOutputID = model.InputOutputID;
tbl.WastageQuantity = model.WastageQuantity;
tbl.TaminID = model.TaminID;
tbl.WasteDesc = model.WasteDesc;
tbl.OvercomeDesc = model.OvercomeDesc;
tbl.YearID = model.YearID;
tbl.UserID = model.UserID;
tbl.BranchID = model.BranchID;
tbl.RegisteredDate = model.RegisteredDate;
tbl.WCProcessStageID = model.WCProcessStageID;
tbl.ActionID = model.ActionID;
tbl.FaultID = model.FaultID;
tbl.WasteSupplierID = model.WasteSupplierID;
tbl.BOM = model.BOM;
tbl.WastePartID = model.WastePartID;
tbl.ReworkTime = model.ReworkTime;
return(tbl);
}
/// <summary>
/// this function edit all parent data
/// first delete all parent id then save all sended parent info
/// </summary>
/// <param name="model">all parent info</param>
public void EditAllDetail2(IEnumerable <WasteCanbanInfoModel> model)
{
DeleteAllDetail2((int)model.First().InputOutputID);
foreach (var item in model)
{
DataLayer.PP_WasteCanbanInfo tbl = new DataLayer.PP_WasteCanbanInfo();
tbl = ConvertToTable(item);
context.PP_WasteCanbanInfos.InsertOnSubmit(tbl);
context.SubmitChanges();
}
}
/// <summary>
/// this function saves all parent info
/// </summary>
/// <param name="model">parent info</param>
public void SaveAllDetail2(IEnumerable <WasteCanbanInfoModel> model, int inputoutpotid)
{
foreach (var item in model)
{
DataLayer.PP_WasteCanbanInfo tbl = new DataLayer.PP_WasteCanbanInfo();
tbl = ConvertToTable(item);
tbl.InputOutputID = inputoutpotid;
tbl.BranchID = CRMStaticData.StaticData.getBranchID;
tbl.RegisteredDate = CRMStaticData.StaticData.getRegisteredDate;
tbl.UserID = CRMStaticData.StaticData.getUserID;
tbl.YearID = CRMStaticData.StaticData.getYearID;
context.PP_WasteCanbanInfos.InsertOnSubmit(tbl);
context.SubmitChanges();
}
}
///////// second detail
public WasteCanbanInfoModel ConvertToModel(DataLayer.PP_WasteCanbanInfo tbl)
{
WasteCanbanInfoModel model = new WasteCanbanInfoModel();
model.WasteCanbanID = tbl.WasteCanbanID;
model.FacilityID = tbl.FacilityID;
model.WorkerID = tbl.WorkerID;
model.WasteSourceID = tbl.WasteSourceID;
model.WTrackingCode = tbl.WTrackingCode;
model.WPackageCode = tbl.WPackageCode;
model.WInventoryCode = tbl.WInventoryCode;
model.InputOutputID = tbl.InputOutputID;
model.WastageQuantity = tbl.WastageQuantity;
model.TaminID = tbl.TaminID;
model.WasteDesc = tbl.WasteDesc;
model.OvercomeDesc = tbl.OvercomeDesc;
model.YearID = tbl.YearID;
model.UserID = tbl.UserID;
model.BranchID = tbl.BranchID;
model.RegisteredDate = tbl.RegisteredDate;
model.ActionID = tbl.ActionID;
model.FaultID = tbl.FaultID;
model.ReworkTime = tbl.ReworkTime;
model.WasteSupplierID = tbl.WasteSupplierID;
model.BOM = tbl.BOM;
model.WastePartID = tbl.WastePartID;
if (context.PP_WarehouseTypeInfos.Where(q => q.WarehouseTypeInfoID == tbl.WInventoryCode).FirstOrDefault() != null)
{
model.WInventoryCodeName = context.PP_WarehouseTypeInfos.Where(q => q.WarehouseTypeInfoID == tbl.WInventoryCode).FirstOrDefault().WarehouseTypeInfoName;
}
if (context.PP_CodeInfos.Where(q => q.CodeID == tbl.WPackageCode).FirstOrDefault() != null)
{
model.WPackageCodeName = context.PP_CodeInfos.Where(q => q.CodeID == tbl.WPackageCode).FirstOrDefault().CodeDesc;
}
if (context.PP_CodeInfos.Where(q => q.CodeID == tbl.WTrackingCode).FirstOrDefault() != null)
{
model.WTrackingCodeName = context.PP_CodeInfos.Where(q => q.CodeID == tbl.WTrackingCode).FirstOrDefault().CodeDesc;
}
if (context.PP_WasteSourceInfos.Where(q => q.WasteSourceID == tbl.WasteSourceID).FirstOrDefault() != null)
{
model.WasteSourceIDName = context.PP_WasteSourceInfos.Where(q => q.WasteSourceID == tbl.WasteSourceID).FirstOrDefault().WasteSourceName;
}
if (context.PP_WorkersInfos.Where(q => q.WorkersID == tbl.WorkerID).FirstOrDefault() != null)
{
model.WorkerIDName = context.PP_WorkersInfos.Where(q => q.WorkersID == tbl.WorkerID).FirstOrDefault().WorkersName + " " + context.PP_WorkersInfos.Where(q => q.WorkersID == tbl.WorkerID).FirstOrDefault().WorkersSurname;
}
if (context.PP_FacilityInfos.Where(q => q.FacilityID == tbl.FacilityID).FirstOrDefault() != null)
{
model.FacilityIDName = context.PP_FacilityInfos.Where(q => q.FacilityID == tbl.FacilityID).FirstOrDefault().FacilityName;
}
if (context.PP_FaultInfos.Where(q => q.FaultID == tbl.FaultID).FirstOrDefault() != null)
{
model.FaultIDName = context.PP_FaultInfos.Where(q => q.FaultID == tbl.FaultID).FirstOrDefault().FaultName;
}
if (context.PP_ActionInfos.Where(q => q.ActionID == tbl.ActionID).FirstOrDefault() != null)
{
model.ActionIDName = context.PP_ActionInfos.Where(q => q.ActionID == tbl.ActionID).FirstOrDefault().ActionName;
}
if (context.MRP_PartInfos.Where(q => q.PartID == tbl.WastePartID).FirstOrDefault() != null)
{
model.WastePartIDName = context.MRP_PartInfos.Where(q => q.PartID == tbl.WastePartID).FirstOrDefault().PartName;
}
if (context.PP_ProcessStageInfos.Where(q => q.ProcessStageID == tbl.WCProcessStageID).FirstOrDefault() != null)
{
model.WCProcessStageIDName = context.PP_ProcessStageInfos.Where(q => q.ProcessStageID == tbl.WCProcessStageID).FirstOrDefault().ProcessStageName;
}
if (context.PP_Tamins.Where(q => q.TaminID == tbl.TaminID).FirstOrDefault() != null)
{
model.TaminName = context.PP_Tamins.Where(q => q.TaminID == tbl.TaminID).FirstOrDefault().TaminName;
}
//model.WCProcessStageID = tbl.WCProcessStageID;
return(model);
}
