public int Save(PRQChemicalPI model, int userId, string pageUrl) { int CurrentPIID = 0; try { using (TransactionScope transaction = new TransactionScope()) { using (_context) { #region New_PI_Insert PRQ_ChemicalPI objPI = new PRQ_ChemicalPI(); objPI.PINo = model.PINo; objPI.PIDate = DalCommon.SetDate(model.PIDate); objPI.PICategory = model.PICategory; objPI.OrderID = model.OrderID; objPI.OrderNo = model.OrderNo; objPI.PIReceiveDate = DateTime.Now; if (model.SupplierID == 0) { objPI.SupplierID = null; } else { objPI.SupplierID = model.SupplierID; } if (model.LocalAgent == 0) { objPI.LocalAgent = null; } else { objPI.LocalAgent = model.LocalAgent; } if (model.ForeignAgent == 0) { objPI.ForeignAgent = null; } else { objPI.ForeignAgent = model.ForeignAgent; } if (model.BuyerID == 0) { objPI.PIBeneficiary = null; } else { objPI.PIBeneficiary = model.BuyerID; } if (model.BuyerAddressID == 0) { objPI.BeneficiaryAddressID = null; } else { objPI.BeneficiaryAddressID = model.BuyerAddressID; } if (model.PICurrency == 0) { objPI.PICurrency = null; } else { objPI.PICurrency = model.PICurrency; } if (model.ExchangeCurrency == 0) { objPI.ExchangeCurrency = null; } else { objPI.ExchangeCurrency = model.ExchangeCurrency; } if (model.ExchangeRate == 0) { objPI.ExchangeRate = null; } else { objPI.ExchangeRate = model.ExchangeRate; } if (model.ExchangeValue == 0) { objPI.ExchangeValue = null; } else { objPI.ExchangeValue = model.ExchangeValue; } objPI.PaymentTerm = model.PaymentTerm; objPI.PaymentMode = model.PaymentMode; objPI.DeferredDays = model.DeferredDays; if (model.CountryOforigin == 0) { objPI.CountryOforigin = null; } else { objPI.CountryOforigin = model.CountryOforigin; } if (model.BeneficiaryBank == 0) { objPI.BeneficiaryBank = null; } else { objPI.BeneficiaryBank = model.BeneficiaryBank; } //if (model.AdvisingBank == 0) // objPI.AdvisingBank = null; //else // objPI.AdvisingBank = model.AdvisingBank; objPI.FreightCharge = model.FreightCharge; objPI.FreightChargeExtra = model.FreightChargeExtra; objPI.DeliveryTerm = model.DeliveryTerm; objPI.DeliveryMode = model.DeliveryMode; if (model.PortofLoading == 0) { objPI.PortofLoading = null; } else { objPI.PortofLoading = model.PortofLoading; } if (model.PortofDischarge == 0) { objPI.PortofDischarge = null; } else { objPI.PortofDischarge = model.PortofDischarge; } objPI.Transshipment = model.Transshipment; objPI.PartialShipment = model.PartialShipment; objPI.GoodDelivery = model.GoodDelivery; objPI.ShippingMark = model.ShippingMark; if (model.ExpectedShipmentTime == 0) { objPI.ExpectedShipmentTime = null; } else { objPI.ExpectedShipmentTime = model.ExpectedShipmentTime; } objPI.Packing = model.Packing; objPI.PreShipmentIns = model.PreShipmentIns; if (model.OfferValidityDays == 0) { objPI.OfferValidityDays = null; } else { objPI.OfferValidityDays = model.OfferValidityDays; } objPI.OfferValidityNote = model.OfferValidityNote; objPI.RecordStatus = "NCF"; objPI.SetBy = userId; objPI.SetOn = DateTime.Now; objPI.PIStatus = "ODDN"; objPI.PIState = "RNG"; //objPI.PIReceiveDate=?? //objPI.PINote=?? //objPI.RunningStatus= ?? //objPI.CostIndicator= ?? _context.PRQ_ChemicalPI.Add(objPI); _context.SaveChanges(); CurrentPIID = objPI.PIID; #endregion #region Item Insert if (model.PIItemList != null) { foreach (var item in model.PIItemList) { PRQ_ChemicalPIItem objItem = new PRQ_ChemicalPIItem(); objItem.PIID = CurrentPIID; objItem.ItemID = item.ItemID; objItem.OrderQty = item.OrderQty; objItem.OrderUnit = DalCommon.GetUnitCode(item.OrderUnitName); objItem.PackSize = DalCommon.GetSizeCode(item.PackSizeName); objItem.SizeUnit = DalCommon.GetUnitCode(item.SizeUnitName); objItem.PackQty = item.PackQty; objItem.PIQty = Convert.ToDecimal(item.PackSizeName) * item.PackQty; objItem.PIUnit = DalCommon.GetUnitCode(item.PIUnitName); objItem.PIUnitPrice = item.PIUnitPrice; objItem.PITotalPrice = Convert.ToDecimal(item.PackSizeName) * item.PackQty * item.PIUnitPrice; objItem.SupplierID = item.SupplierID; //objItem.ManufacturerID = item.ManufacturerID; objItem.ItemSource = item.ItemSource; objItem.SetOn = DateTime.Now; objItem.SetBy = userId; _context.PRQ_ChemicalPIItem.Add(objItem); _context.SaveChanges(); } } #endregion } transaction.Complete(); } return(CurrentPIID); } catch (Exception e) { return(CurrentPIID); } }
public ValidationMsg Save(PrqChemLocalPurcBill model, int userId, string url) { try { using (var tx = new TransactionScope()) { using (_context) { var bill = BillConversion(model, userId, url); if (model.BillId == 0) { _context.PRQ_ChemLocalPurcBill.Add(bill); _context.SaveChanges(); _mode = 1; } else { _context.SaveChanges(); _mode = 2; } if (model.References != null) { foreach (var reference in model.References) { var entityRef = BillReferenceConversion(reference, userId, bill.BillID); if (reference.BillRefId == 0) { _context.PRQ_ChemLocalPurcBillRef.Add(entityRef); _context.SaveChanges(); } else { _context.SaveChanges(); } if (reference.Items != null) { foreach (var item in reference.Items) { var entityItem = BillItemConversion(item, userId, bill.BillID, entityRef.BillRefID); if (item.BillItemId == 0) { _context.PRQ_ChemLocalPurcBillItem.Add(entityItem); _context.SaveChanges(); } else { _context.SaveChanges(); } } } } } tx.Complete(); if (_mode == 1) { _validationMsg.ReturnId = bill.BillID; _validationMsg.ReturnCode = bill.BillNo; _validationMsg.Type = Enums.MessageType.Success; _validationMsg.Msg = "Saved successfully."; } if (_mode == 2) { _validationMsg.Type = Enums.MessageType.Update; _validationMsg.Msg = "Updated successfully."; } } } } catch { _validationMsg.Type = Enums.MessageType.Error; _validationMsg.Msg = "Failed to save."; } return(_validationMsg); }
public ValidationMsg Save(InvFinishLeatherReceive model, int userid, string pageUrl) { _vmMsg = new ValidationMsg(); try { using (var tx = new TransactionScope()) { using (_context) { model.FNReceiveNo = DalCommon.GetPreDefineNextCodeByUrl(pageUrl);//DalCommon.GetPreDefineValue("1", "00045"); if (model.FNReceiveNo != null) { #region Save Finish Leather Receive Data INV_FinishLeatherReceive tblFinishLeatherReceive = SetToModelObject(model, userid); _context.INV_FinishLeatherReceive.Add(tblFinishLeatherReceive); _context.SaveChanges(); #endregion #region Save Finish Leather Receive Item Data if (model.InvFinishLeatherReceiveItemList != null) { foreach (InvFinishLeatherReceiveItem objFinishLeatherReceiveItem in model.InvFinishLeatherReceiveItemList) { objFinishLeatherReceiveItem.FNReceiveID = tblFinishLeatherReceive.FNReceiveID; INV_FinishLeatherReceiveItem tblFinishLeatherReceiveItem = SetToIssueItemModelObject(objFinishLeatherReceiveItem, userid); _context.INV_FinishLeatherReceiveItem.Add(tblFinishLeatherReceiveItem); _context.SaveChanges(); #region Save Finish Leather Receive Color Data if (model.InvFinishLeatherReceiveColorList != null) { if (objFinishLeatherReceiveItem.FNReceiveItemID != null) { foreach (InvFinishLeatherReceiveColor objFinishLeatherReceiveColor in model.InvFinishLeatherReceiveColorList) { objFinishLeatherReceiveColor.FNReceiveID = tblFinishLeatherReceiveItem.FNReceiveID; objFinishLeatherReceiveColor.FNReceiveItemID = tblFinishLeatherReceiveItem.FNReceiveItemID; INV_FinishLeatherReceiveColor tblFinishLeatherReceiveColor = SetToReceiveColorModelObject(objFinishLeatherReceiveColor, userid); _context.INV_FinishLeatherReceiveColor.Add(tblFinishLeatherReceiveColor); _context.SaveChanges(); } } } #endregion } } #endregion _context.SaveChanges(); tx.Complete(); //FNReceiveID = tblFinishLeatherReceive.FNReceiveID; //FNReceiveNo = tblFinishLeatherReceive.FNReceiveNo; _vmMsg.Type = Enums.MessageType.Success; _vmMsg.Msg = "Saved Successfully."; } else { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Crust Leather No Predefine Value not Found."; } } } } catch (Exception ex) { if (ex.InnerException.InnerException.Message.Contains("UNIQUE KEY")) { _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Crust Leather No Data Already Exit."; } _vmMsg.Type = Enums.MessageType.Error; _vmMsg.Msg = "Failed to save."; } return(_vmMsg); }
public int SaveAdjustItemRequest(InvLeatherStockAdjustModel model, int userID) { var leatherTypeID = DalCommon.GetLeatherTypeCode("Raw Hide"); var leatherStatusID = DalCommon.GetLeatherStatusCode("Raw Hide"); using (TransactionScope transaction = new TransactionScope()) { #region Insert Inv_LeatherStockAdjustRequest objAdjustmentRequest = new Inv_LeatherStockAdjustRequest(); objAdjustmentRequest.PurchaseYear = model.PurchaseYear; objAdjustmentRequest.RequestDate = DalCommon.SetDate(model.RequestDate); objAdjustmentRequest.LeatherType = model.LeatherType; objAdjustmentRequest.StoreID = model.StoreID; objAdjustmentRequest.RecordStatus = "NCF"; objAdjustmentRequest.SetBy = userID; objAdjustmentRequest.SetOn = DateTime.Now; _context.Inv_LeatherStockAdjustRequest.Add(objAdjustmentRequest); _context.SaveChanges(); var currentRequestID = objAdjustmentRequest.RequestID; foreach (var item in model.StockAdjustItemList) { Inv_LeatherStockAdjustItem objAdjustmentItems = new Inv_LeatherStockAdjustItem(); objAdjustmentItems.RequestID = currentRequestID; objAdjustmentItems.SupplierID = item.SupplierID; objAdjustmentItems.PurchaseID = item.ChallanID; objAdjustmentItems.ItemTypeID = item.ItemTypeID; objAdjustmentItems.LeatherType = model.LeatherType; objAdjustmentItems.LeatherStatus = leatherStatusID; objAdjustmentItems.ItemQty = item.ItemQty; objAdjustmentItems.Unit = item.Unit; objAdjustmentItems.Remarks = item.Remarks; objAdjustmentItems.AdjustmentCause = item.AdjustmentCause; _context.Inv_LeatherStockAdjustItem.Add(objAdjustmentItems); _context.SaveChanges(); } transaction.Complete(); return(currentRequestID); #endregion } }