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