/// <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 EditAllDetail(IEnumerable <CanbanInfoModel> model)
{
DeleteAllDetail((int)model.First().InputOutputID);
foreach (var item in model)
{
DataLayer.PP_CanbanInfo tbl = new DataLayer.PP_CanbanInfo();
tbl = ConvertToTable(item);
context.PP_CanbanInfos.InsertOnSubmit(tbl);
context.SubmitChanges();
}
}
public CanbanInfoModel ConvertToModel(DataLayer.PP_CanbanInfo tbl)
{
CanbanInfoModel model = new CanbanInfoModel();
model.CanbanID = tbl.CanbanID;
model.IOTrackingCode = tbl.IOTrackingCode;
model.IOPackageCode = tbl.IOPackageCode;
model.IOInventoryCode = tbl.IOInventoryCode;
model.InputOutputID = tbl.InputOutputID;
model.CanbanPartID = tbl.CanbanPartID;
model.UnitID = tbl.UnitID;
model.Quantity = tbl.Quantity;
model.UserID = tbl.UserID;
model.YearID = tbl.YearID;
model.BranchID = tbl.BranchID;
model.RegisteredDate = tbl.RegisteredDate;
model.TechnicalCode = tbl.TechnicalCode;
model.CProcessStageID = tbl.CProcessStageID;
if (context.PP_WarehouseTypeInfos.Where(q => q.WarehouseTypeInfoID == tbl.IOInventoryCode).FirstOrDefault() != null)
{
model.IOInventoryCodeName = context.PP_WarehouseTypeInfos.Where(q => q.WarehouseTypeInfoID == tbl.IOInventoryCode).FirstOrDefault().WarehouseTypeInfoName;
}
if (context.MRP_PartInfos.Where(q => q.PartID == tbl.CanbanPartID).FirstOrDefault() != null)
{
model.CanbanPartIDName = context.MRP_PartInfos.Where(q => q.PartID == tbl.CanbanPartID).FirstOrDefault().PartName;
}
if (context.MRP_PartInfos.Where(q => q.PartID == tbl.CanbanPartID).FirstOrDefault() != null)
{
model.TechnicalCodeName = context.MRP_PartInfos.Where(q => q.PartID == tbl.CanbanPartID).FirstOrDefault().TechnicalNumber;
}
;
if (context.PP_UnitInfos.Where(q => q.UnitID == tbl.UnitID).FirstOrDefault() != null)
{
model.UnitIDName = context.PP_UnitInfos.Where(q => q.UnitID == tbl.UnitID).FirstOrDefault().UnitName;
}
if (context.PP_ProcessStageInfos.Where(q => q.ProcessStageID == tbl.CProcessStageID).FirstOrDefault() != null)
{
model.CProcessStageIDName = context.PP_ProcessStageInfos.Where(q => q.ProcessStageID == tbl.CProcessStageID).FirstOrDefault().ProcessStageName;
}
if (context.PP_WorkersInfos.Where(q => q.WorkersID == tbl.CWorkerID).FirstOrDefault() != null)
{
model.WorkerName = context.PP_WorkersInfos.Where(q => q.WorkersID == tbl.CWorkerID).FirstOrDefault().WorkersSurname;
}
if (context.PP_CodeInfos.Where(q => q.CodeID == tbl.IOPackageCode).FirstOrDefault() != null)
{
model.IOPackageCodeName = context.PP_CodeInfos.Where(q => q.CodeID == tbl.IOPackageCode).FirstOrDefault().CodeDesc;
}
if (context.PP_CodeInfos.Where(q => q.CodeID == tbl.IOTrackingCode).FirstOrDefault() != null)
{
model.IOTrackingCodeName = context.PP_CodeInfos.Where(q => q.CodeID == tbl.IOTrackingCode).FirstOrDefault().CodeDesc;
}
model.CWorkerID = tbl.CWorkerID;
return(model);
}
public DataLayer.PP_CanbanInfo ConvertToTable(CanbanInfoModel model)
{
DataLayer.PP_CanbanInfo tbl = new DataLayer.PP_CanbanInfo();
tbl.CanbanID = model.CanbanID;
tbl.IOTrackingCode = model.IOTrackingCode;
tbl.IOPackageCode = model.IOPackageCode;
tbl.IOInventoryCode = model.IOInventoryCode;
tbl.InputOutputID = model.InputOutputID;
tbl.CanbanPartID = model.CanbanPartID;
tbl.UnitID = model.UnitID;
tbl.Quantity = model.Quantity;
tbl.UserID = model.UserID;
tbl.YearID = model.YearID;
tbl.BranchID = model.BranchID;
tbl.RegisteredDate = model.RegisteredDate;
tbl.TechnicalCode = model.TechnicalCode;
tbl.CProcessStageID = model.CProcessStageID;
tbl.CWorkerID = model.CWorkerID;
return(tbl);
}
/// <summary>
/// this function saves all parent info
/// </summary>
/// <param name="model">parent info</param>
public void SaveAllDetail(IEnumerable <CanbanInfoModel> model, int inputoutpotid)
{
if (model.Any(q => q.CProcessStageID == 4))
{
foreach (var item in model)
{
DataLayer.PP_CanbanInfo tbl = new DataLayer.PP_CanbanInfo();
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;
tbl.CanbanPartID = item.CanbanPartID;
context.PP_CanbanInfos.InsertOnSubmit(tbl);
context.SubmitChanges();
}
}
else
{
foreach (var item in model)
{
DataLayer.PP_CanbanInfo tbl = new DataLayer.PP_CanbanInfo();
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;
tbl.CanbanPartID = item.CanbanPartID;
context.PP_CanbanInfos.InsertOnSubmit(tbl);
context.SubmitChanges();
}
var saveforworker = model.FirstOrDefault();
var schdul = context.PP_InputOutputInfos.Where(q => q.InputOutputID == inputoutpotid).FirstOrDefault().ScheduleProductionLineID;
var workerschedullist = context.PP_WorkersScheduleInfos.Where(q => q.ScheduleProductionLineID == schdul).ToList();
foreach (var a in workerschedullist)
{
DataLayer.PP_CanbanInfo tbl = new DataLayer.PP_CanbanInfo();
var workercountinfacility = workerschedullist.Where(q => q.ScheduleProductionLineID == schdul & q.FacilityID == a.FacilityID).ToList().Count();
tbl.IOTrackingCode = saveforworker.IOTrackingCode;
tbl.IOPackageCode = saveforworker.IOPackageCode;
tbl.IOInventoryCode = saveforworker.IOInventoryCode;
tbl.InputOutputID = saveforworker.InputOutputID;
tbl.CanbanPartID = saveforworker.CanbanPartID;
tbl.UnitID = saveforworker.UnitID;
tbl.Quantity = saveforworker.Quantity / workercountinfacility;
tbl.UserID = saveforworker.UserID;
tbl.YearID = saveforworker.YearID;
tbl.BranchID = saveforworker.BranchID;
tbl.RegisteredDate = saveforworker.RegisteredDate;
tbl.TechnicalCode = saveforworker.TechnicalCode;
tbl.CProcessStageID = 4;
tbl.CWorkerID = a.WorkersID;
tbl.InputOutputID = inputoutpotid;
tbl.BranchID = CRMStaticData.StaticData.getBranchID;
tbl.RegisteredDate = CRMStaticData.StaticData.getRegisteredDate;
tbl.UserID = CRMStaticData.StaticData.getUserID;
tbl.YearID = CRMStaticData.StaticData.getYearID;
tbl.CanbanPartID = saveforworker.CanbanPartID;
context.PP_CanbanInfos.InsertOnSubmit(tbl);
context.SubmitChanges();
}
}
}
