/// <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(); } } }