public void DTO2DB_FactoryFinishedProductReceipt(DTO.FactoryFinishedProductReceipt dtoItem, ref FactoryFinishedProductReceipt dbItem) { if (dtoItem.FactoryFinishedProductReceiptDetails != null) { foreach (var item in dbItem.FactoryFinishedProductReceiptDetail.ToArray()) { if (!dtoItem.FactoryFinishedProductReceiptDetails.Select(s => s.FactoryFinishedProductReceiptDetailID).Contains(item.FactoryFinishedProductReceiptDetailID)) { dbItem.FactoryFinishedProductReceiptDetail.Remove(item); } } foreach (var item in dtoItem.FactoryFinishedProductReceiptDetails) { FactoryFinishedProductReceiptDetail dbDetail; if (item.FactoryFinishedProductReceiptDetailID < 0) { dbDetail = new FactoryFinishedProductReceiptDetail(); dbItem.FactoryFinishedProductReceiptDetail.Add(dbDetail); } else { dbDetail = dbItem.FactoryFinishedProductReceiptDetail.Where(o => o.FactoryFinishedProductReceiptDetailID == item.FactoryFinishedProductReceiptDetailID).FirstOrDefault(); } if (dbDetail != null) { AutoMapper.Mapper.Map <DTO.FactoryFinishedProductReceiptDetail, FactoryFinishedProductReceiptDetail>(item, dbDetail); } } } AutoMapper.Mapper.Map <DTO.FactoryFinishedProductReceipt, FactoryFinishedProductReceipt>(dtoItem, dbItem); dbItem.UpdatedDate = DateTime.Now; dbItem.UpdatedBy = dtoItem.UpdatedBy; dbItem.ReceiptDate = dtoItem.ReceiptDate.ConvertStringToDateTime(); if (dtoItem.FactoryFinishedProductReceiptID == null) { dbItem.CreatedDate = DateTime.Now; dbItem.CreatedBy = dtoItem.UpdatedBy; } }
public void ValidateQuantity(DTO.FactoryFinishedProductReceipt dtoReceipt) { using (FactoryFinishedProductReceiptEntities context = CreateContext()) { List <string> ids = new List <string>(); string stepProgress = context.FactoryFinishedProductReceiptMng_action_GetStepProgress(dtoReceipt.FactoryGoodsProcedureID, dtoReceipt.FactoryStepID).FirstOrDefault();; foreach (var item in dtoReceipt.FactoryFinishedProductReceiptDetails) { if (dtoReceipt.ReceiptTypeID == 1) { ids.Add(dtoReceipt.ImportFromTeamID.ToString() + "_" + dtoReceipt.FactoryStepID.ToString() + "_" + dtoReceipt.FactoryGoodsProcedureID.ToString() + "_" + item.FactoryOrderDetailID + "_" + item.FactoryFinishedProductOrderNormID.ToString() + "_" + item.FactoryFinishedProductID.ToString()); } else if (dtoReceipt.ReceiptTypeID == 2) { ids.Add(item.FactoryOrderDetailID.ToString() + "_" + item.FactoryFinishedProductOrderNormID.ToString() + "_" + item.FactoryFinishedProductID + "_" + item.FromGoodsProcedureID.ToString() + "_" + stepProgress); } } List <FactoryFinishedProductReceiptMng_ComponentNeedToImport_View> dbNeedImports; List <FactoryFinishedProductReceiptMng_ComponentNeedToExport_View> dbNeedExports; dbNeedImports = (dtoReceipt.ReceiptTypeID == 1 ? context.FactoryFinishedProductReceiptMng_ComponentNeedToImport_View.Where(o => ids.Contains(o.FactoryTeamID.ToString() + "_" + o.FactoryStepID.ToString() + "_" + o.FactoryGoodsProcedureID.ToString() + "_" + o.FactoryOrderDetailID + "_" + o.FactoryFinishedProductOrderNormID.ToString() + "_" + o.FactoryFinishedProductID.ToString())).ToList() : null); dbNeedExports = (dtoReceipt.ReceiptTypeID == 2 ? context.FactoryFinishedProductReceiptMng_ComponentNeedToExport_View.Where(o => ids.Contains(o.FactoryOrderDetailID.ToString() + "_" + o.FactoryFinishedProductOrderNormID.ToString() + "_" + o.FactoryFinishedProductID + "_" + o.FromGoodsProcedureID.ToString() + "_" + o.StepProgress.ToString())).ToList() : null); foreach (var item in dtoReceipt.FactoryFinishedProductReceiptDetails) { //take qnt to check decimal?qntCheck = 0; if (dtoReceipt.ReceiptTypeID == 1) { var needImport = dbNeedImports.Where(o => o.FactoryTeamID == dtoReceipt.ImportFromTeamID && o.FactoryStepID == dtoReceipt.FactoryStepID && o.FactoryGoodsProcedureID == dtoReceipt.FactoryGoodsProcedureID && o.FactoryOrderDetailID == item.FactoryOrderDetailID && o.FactoryFinishedProductOrderNormID == item.FactoryFinishedProductOrderNormID && o.FactoryFinishedProductID == item.FactoryFinishedProductID).FirstOrDefault(); qntCheck = (needImport == null ? 0 : needImport.Quantity); } else if (dtoReceipt.ReceiptTypeID == 2) { var needExport = dbNeedExports.Where(o => o.FactoryOrderDetailID == item.FactoryOrderDetailID && o.FactoryFinishedProductOrderNormID == item.FactoryFinishedProductOrderNormID && o.FactoryFinishedProductID == item.FactoryFinishedProductID && o.FromGoodsProcedureID == item.FromGoodsProcedureID && o.StepProgress == stepProgress).FirstOrDefault(); qntCheck = (needExport == null ? 0 : needExport.Quantity); } //check if (item.FactoryFinishedProductReceiptDetailID > 0) { decimal?currentQnt = context.FactoryFinishedProductReceiptDetail.Where(o => o.FactoryFinishedProductReceiptDetailID == item.FactoryFinishedProductReceiptDetailID).FirstOrDefault().Quantity; if (item.Quantity - (currentQnt.HasValue ? currentQnt.Value : 0) > (qntCheck.HasValue ? qntCheck.Value : 0)) { throw new Exception("Quantity of component " + item.FactoryFinishedProductUD + "must be less than " + ((currentQnt.HasValue ? currentQnt.Value : 0) + (qntCheck.HasValue ? qntCheck.Value : 0)).ToString()); } } else { if (item.Quantity > (qntCheck.HasValue ? qntCheck.Value : 0)) { throw new Exception("Quantity of component " + item.FactoryFinishedProductUD + "must be less than " + (qntCheck.HasValue ? qntCheck.Value : 0).ToString()); } } } } }
public override bool UpdateData(int userId, int id, ref object dtoItem, out Library.DTO.Notification notification) { notification = new Library.DTO.Notification() { Type = Library.DTO.NotificationType.Success }; DTO.FactoryFinishedProductReceipt dtoFactoryFinishedProductReceipt = ((Newtonsoft.Json.Linq.JObject)dtoItem).ToObject <DTO.FactoryFinishedProductReceipt>(); dtoFactoryFinishedProductReceipt.UpdatedBy = userId; try { using (FactoryFinishedProductReceiptEntities context = CreateContext()) { FactoryFinishedProductReceipt dbItem = null; if (id == 0) { dbItem = new FactoryFinishedProductReceipt(); context.FactoryFinishedProductReceipt.Add(dbItem); } else { dbItem = context.FactoryFinishedProductReceipt.Where(o => o.FactoryFinishedProductReceiptID == id).FirstOrDefault(); } if (dbItem == null) { notification.Message = "data not found!"; return(false); } else { if (dtoFactoryFinishedProductReceipt.ReceiptTypeID == 1) { if (dtoFactoryFinishedProductReceipt.InProgressOrBuyDirectlyID == 1) { if (!dtoFactoryFinishedProductReceipt.ImportFromTeamID.HasValue) { throw new Exception("Team is empty. You should fill-in Team"); } } } else if (dtoFactoryFinishedProductReceipt.ReceiptTypeID == 2) { if (!dtoFactoryFinishedProductReceipt.ExportToTeamID.HasValue) { throw new Exception("Team is empty. You should fill-in Team"); } } if (!dtoFactoryFinishedProductReceipt.FactoryStepID.HasValue) { throw new Exception("Step is empty. You should fill-in Step"); } if (!dtoFactoryFinishedProductReceipt.FactoryGoodsProcedureID.HasValue) { throw new Exception("Step is empty. You should fill-in goods procedure"); } //validate quantity //ValidateQuantity(dtoFactoryFinishedProductReceipt); //convert dto to db converter.DTO2DB_FactoryFinishedProductReceipt(dtoFactoryFinishedProductReceipt, ref dbItem); //remove orphan item context.FactoryFinishedProductReceiptDetail.Local.Where(o => o.FactoryFinishedProductReceipt == null).ToList().ForEach(o => context.FactoryFinishedProductReceiptDetail.Remove(o)); //save data context.SaveChanges(); //update receipt no context.FactoryFinishedProductReceiptMng_function_GenerateReceipNo(dbItem.FactoryFinishedProductReceiptID, dbItem.Season, dbItem.ReceiptTypeID); //get return data dtoItem = GetData(dbItem.FactoryFinishedProductReceiptID, out notification).Data; return(true); } } } catch (Exception ex) { notification.Type = Library.DTO.NotificationType.Error; notification.Message = ex.Message; notification.DetailMessage.Add(ex.Message); if (ex.GetBaseException() != null) { notification.DetailMessage.Add(ex.GetBaseException().Message); } return(false); } }