private void SetupOrderRepo() { orderRepository = OrderRepository.getInstance(); List <string> orders = dBcontroller.GetAllOrders(); foreach (string order in orders) { string[] values = order.Split(','); int.TryParse(values[0], out int orderId); bool.TryParse(values[4], out bool picked); Customer customer = GetCustomer(values[1]); List <string> saleOrderLinesValues = dBcontroller.GetSaleOrderLines(orderId); List <SaleOrderLine> saleOrderLines = new List <SaleOrderLine>(); foreach (string saleOrderLineValue in saleOrderLinesValues) { string[] valuesSaleLine = saleOrderLineValue.Split(','); int.TryParse(valuesSaleLine[0], out int productId); int.TryParse(valuesSaleLine[1], out int quantity); double.TryParse(valuesSaleLine[2], out double price); SaleOrderLine saleOrderLine = new SaleOrderLine(GetProduct(productId), quantity, price); saleOrderLines.Add(saleOrderLine); } orderRepository.AddOrder(orderRepository.CreateOrder(saleOrderLines, customer, orderId, values[2], values[3], picked)); } }
private ActionResult _Modify(int id) { SaleOrderLine temp = _SaleOrderLineService.GetSaleOrderLine(id); if (temp == null) { return(HttpNotFound()); } #region DocTypeTimeLineValidation try { TimePlanValidation = DocumentValidation.ValidateDocumentLine(new DocumentUniqueId { LockReason = temp.LockReason }, User.Identity.Name, out ExceptionMsg, out Continue); } catch (Exception ex) { string message = _exception.HandleException(ex); TempData["CSEXCL"] += message; TimePlanValidation = false; } if (!TimePlanValidation) { TempData["CSEXCL"] += ExceptionMsg; } #endregion if ((TimePlanValidation || Continue)) { ViewBag.LineMode = "Edit"; } SaleOrderHeader H = new SaleOrderHeaderService(_unitOfWork).GetSaleOrderHeader(temp.SaleOrderHeaderId); ViewBag.DocNo = H.DocNo; SaleOrderLineViewModel s = Mapper.Map <SaleOrderLine, SaleOrderLineViewModel>(temp); string BuyerSku = (_SaleOrderLineService.GetBuyerSKU(temp.ProductId, temp.SaleOrderHeaderId)); s.BuyerSku = BuyerSku; var settings = new SaleOrderSettingsService(_unitOfWork).GetSaleOrderSettings(H.DocTypeId, H.DivisionId, H.SiteId); s.SaleOrderSettings = Mapper.Map <SaleOrderSettings, SaleOrderSettingsViewModel>(settings); s.DocumentTypeSettings = new DocumentTypeSettingsService(_unitOfWork).GetDocumentTypeSettingsForDocument(H.DocTypeId); s.UnitId = new ProductService(_unitOfWork).Find(temp.ProductId).UnitId; PrepareViewBag(H); return(PartialView("_Create", s)); }
public bool CheckForProductExists(int ProductId, int SaleOrderHeaderId) { SaleOrderLine temp = (from p in db.SaleOrderLine where p.ProductId == ProductId && p.SaleOrderHeaderId == SaleOrderHeaderId select p).FirstOrDefault(); if (temp != null) { return(true); } else { return(false); } }
public void CreateSaleOrderLine(int SaleEnquiryLineId, int SaleOrderHeaderId) { SaleEnquiryLine Line = new SaleEnquiryLineService(_unitOfWork).Find(SaleEnquiryLineId); SaleEnquiryHeader EnquiryHeader = new SaleEnquiryHeaderService(_unitOfWork).Find(Line.SaleEnquiryHeaderId); SaleOrderLine OrderLine = new SaleOrderLine(); OrderLine.SaleOrderHeaderId = SaleOrderHeaderId; OrderLine.DueDate = Line.DueDate; OrderLine.ProductId = Line.ProductId ?? 0; OrderLine.Specification = Line.Specification; OrderLine.Dimension1Id = Line.Dimension1Id; OrderLine.Dimension2Id = Line.Dimension2Id; OrderLine.Qty = Line.Qty; OrderLine.DealQty = Line.DealQty; OrderLine.DealUnitId = Line.DealUnitId; OrderLine.UnitConversionMultiplier = Line.UnitConversionMultiplier; OrderLine.Rate = Line.Rate; OrderLine.Amount = Line.Amount; OrderLine.Remark = Line.Remark; OrderLine.ReferenceDocTypeId = EnquiryHeader.DocTypeId; OrderLine.ReferenceDocLineId = Line.SaleEnquiryLineId; OrderLine.CreatedDate = DateTime.Now; OrderLine.ModifiedDate = DateTime.Now; OrderLine.CreatedBy = User.Identity.Name; OrderLine.ModifiedBy = User.Identity.Name; new SaleOrderLineService(_unitOfWork).Create(OrderLine); new SaleOrderLineStatusService(_unitOfWork).CreateLineStatus(OrderLine.SaleOrderLineId); Line.LockReason = "Sale order is created for enquiry.Now you can't modify enquiry, changes can be done in sale order."; new SaleEnquiryLineService(_unitOfWork).Update(Line); var PersonProductUid = (from p in db.PersonProductUid where p.GenLineId == SaleEnquiryLineId && p.GenDocTypeId == EnquiryHeader.DocTypeId && p.GenDocId == EnquiryHeader.SaleEnquiryHeaderId select p).ToList(); if (PersonProductUid.Count() != 0) { foreach (var item2 in PersonProductUid) { PersonProductUid PPU = new PersonProductUidService(_unitOfWork).Find(item2.PersonProductUidId); PPU.SaleOrderLineId = OrderLine.SaleOrderLineId; PPU.ObjectState = Model.ObjectState.Modified; new PersonProductUidService(_unitOfWork).Create(PPU); } } }
private ActionResult _Detail(int id) { SaleOrderLine temp = _SaleOrderLineService.GetSaleOrderLine(id); if (temp == null) { return(HttpNotFound()); } SaleOrderHeader H = new SaleOrderHeaderService(_unitOfWork).GetSaleOrderHeader(temp.SaleOrderHeaderId); ViewBag.DocNo = H.DocNo; SaleOrderLineViewModel s = Mapper.Map <SaleOrderLine, SaleOrderLineViewModel>(temp); s.UnitId = new ProductService(_unitOfWork).Find(temp.ProductId).UnitId; PrepareViewBag(H); return(PartialView("_Create", s)); }
public ActionResult SaleOrderExcelImport(int id) { int BuyerId = 0; var file = Request.Files[0]; string filePath = Request.MapPath(ConfigurationManager.AppSettings["ExcelFilePath"] + file.FileName); file.SaveAs(filePath); var excel = new ExcelQueryFactory(); //excel.FileName =ConfigurationManager.AppSettings["ExcelFilePath"]; // @"C:\Users\guru\Downloads\PO.xls"; //TODO: Rempve hardcode excel.FileName = filePath; var SaleOrderRecordList = from c in excel.Worksheet <SaleOrderExcel>() select c; StringBuilder strSku = new StringBuilder(); StringBuilder strSaleToBuyer = new StringBuilder(); StringBuilder strBillToBuyer = new StringBuilder(); StringBuilder strCurrency = new StringBuilder(); StringBuilder strShipMethod = new StringBuilder(); StringBuilder strDeliveryTerms = new StringBuilder(); StringBuilder strPriority = new StringBuilder(); StringBuilder strOrderNo = new StringBuilder(); foreach (var SaleOrderRecord in SaleOrderRecordList) { if (_SaleOrderHeaderService.FindByDocNo(SaleOrderRecord.OrderNumber) != null) { if (!strOrderNo.ToString().Contains("" + SaleOrderRecord.OrderNumber)) { strOrderNo.Append(" " + SaleOrderRecord.OrderNumber + ","); } } if (_ProductService.Find(SaleOrderRecord.Product) == null) { if (!strSku.ToString().Contains("" + SaleOrderRecord.Product)) { strSku.Append(" " + SaleOrderRecord.Product + ","); } } if (SaleOrderRecord.SaleToBuyer != null) { if (_BuyerService.GetBuyerByName(SaleOrderRecord.SaleToBuyer) == null) { if (!strSaleToBuyer.ToString().Contains("" + SaleOrderRecord.SaleToBuyer)) { strSaleToBuyer.Append(" " + SaleOrderRecord.SaleToBuyer + ","); } } } if (SaleOrderRecord.BillToBuyer != null) { if (_BuyerService.GetBuyerByName(SaleOrderRecord.BillToBuyer) == null) { if (!strBillToBuyer.ToString().Contains("" + SaleOrderRecord.BillToBuyer)) { strBillToBuyer.Append(" " + SaleOrderRecord.BillToBuyer + ","); } } } if (SaleOrderRecord.Currency != null) { if (_currencyService.GetCurrencyByName(SaleOrderRecord.Currency) == null) { if (!strCurrency.ToString().Contains("" + SaleOrderRecord.Currency)) { strCurrency.Append(" " + SaleOrderRecord.Currency + ","); } } } if (SaleOrderRecord.ShipMethod != null) { if (_ShipMethodService.GetShipMethodByName(SaleOrderRecord.ShipMethod) == null) { if (!strShipMethod.ToString().Contains("" + SaleOrderRecord.ShipMethod)) { strShipMethod.Append(" " + SaleOrderRecord.ShipMethod + ","); } } } if (SaleOrderRecord.DeliveryTerms != null) { if (_DeliveryTermsService.GetDeliveryTermsByName(SaleOrderRecord.DeliveryTerms) == null) { if (!strDeliveryTerms.ToString().Contains("" + SaleOrderRecord.DeliveryTerms)) { strDeliveryTerms.Append(" " + SaleOrderRecord.DeliveryTerms + ","); } } } if (SaleOrderRecord.Priority != null) { if (Enum.IsDefined(typeof(SaleOrderPriority), SaleOrderRecord.Priority) == false) { if (!strPriority.ToString().Contains("" + SaleOrderRecord.Priority)) { strPriority.Append(" " + SaleOrderRecord.Priority + ","); } } } } if (!string.IsNullOrEmpty(strSku.ToString()) || !string.IsNullOrEmpty(strOrderNo.ToString()) || !string.IsNullOrEmpty(strSaleToBuyer.ToString()) || !string.IsNullOrEmpty(strBillToBuyer.ToString()) || !string.IsNullOrEmpty(strCurrency.ToString()) || !string.IsNullOrEmpty(strShipMethod.ToString()) || !string.IsNullOrEmpty(strDeliveryTerms.ToString()) || !string.IsNullOrEmpty(strPriority.ToString())) { if (string.IsNullOrEmpty(strOrderNo.ToString())) { ViewBag.orderno = null; } else { ViewBag.orderno = strOrderNo; } if (string.IsNullOrEmpty(strSku.ToString())) { ViewBag.product = null; } else { ViewBag.product = strSku; } if (string.IsNullOrEmpty(strSaleToBuyer.ToString())) { ViewBag.SaleToBuyer = null; } else { ViewBag.SaleToBuyer = strSaleToBuyer; } if (string.IsNullOrEmpty(strBillToBuyer.ToString())) { ViewBag.BillToBuyer = null; } else { ViewBag.BillToBuyer = strBillToBuyer; } if (string.IsNullOrEmpty(strCurrency.ToString())) { ViewBag.Currency = null; } else { ViewBag.Currency = strCurrency; } if (string.IsNullOrEmpty(strShipMethod.ToString())) { ViewBag.ShipMethod = null; } else { ViewBag.ShipMethod = strShipMethod; } if (string.IsNullOrEmpty(strDeliveryTerms.ToString())) { ViewBag.DeliveryTerms = null; } else { ViewBag.DeliveryTerms = strDeliveryTerms; } if (string.IsNullOrEmpty(strPriority.ToString())) { ViewBag.Priority = null; } else { ViewBag.Priority = strPriority; } return(View()); } else { string previousRecord = null; int count = 0; SaleOrderHeader stemp = new SaleOrderHeader(); int LinePk = 0; foreach (var SaleOrderRecord in SaleOrderRecordList) { if (count == 0 || SaleOrderRecord.OrderNumber != previousRecord) { //Object for SaleorderHeader Model to Save Order Num,Order Date, Ship Date and Supplier SaleOrderHeader s = new SaleOrderHeader(); if (SaleOrderRecord.ShipAddress != null) { s.ShipAddress = SaleOrderRecord.ShipAddress; } s.DocDate = SaleOrderRecord.OrderDate; s.DocNo = SaleOrderRecord.OrderNumber; s.DueDate = SaleOrderRecord.DueDate; s.ActualDueDate = SaleOrderRecord.DueDate; s.BuyerOrderNo = SaleOrderRecord.BuyerOrderNo; s.CreatedDate = DateTime.Now; s.ModifiedDate = DateTime.Now; s.CreatedBy = User.Identity.Name; s.ModifiedBy = User.Identity.Name; s.SaleToBuyerId = _BuyerService.GetBuyerByName(SaleOrderRecord.SaleToBuyer).PersonID; if (SaleOrderRecord.BillToBuyer != null) { s.BillToBuyerId = _BuyerService.GetBuyerByName(SaleOrderRecord.BillToBuyer).PersonID; } else { s.BillToBuyerId = s.SaleToBuyerId; } BuyerId = s.SaleToBuyerId; s.DivisionId = (int)System.Web.HttpContext.Current.Session["DivisionId"]; s.SiteId = (int)System.Web.HttpContext.Current.Session["SiteId"]; SaleOrderSettings temp = new SaleOrderSettingsService(_unitOfWork).GetSaleOrderSettings(id, s.DivisionId, s.SiteId); if (temp == null) { throw new Exception("Sale order settings is not configured"); } if (SaleOrderRecord.Currency != null) { s.CurrencyId = _currencyService.GetCurrencyByName(SaleOrderRecord.Currency).ID; } else { s.CurrencyId = temp.CurrencyId; } if (SaleOrderRecord.ShipMethod == null) { s.ShipMethodId = temp.ShipMethodId; } else { s.ShipMethodId = _ShipMethodService.GetShipMethodByName(SaleOrderRecord.ShipMethod).ShipMethodId; } if (SaleOrderRecord.DeliveryTerms == null) { s.DeliveryTermsId = temp.DeliveryTermsId; } else { s.DeliveryTermsId = _DeliveryTermsService.GetDeliveryTermsByName(SaleOrderRecord.DeliveryTerms).DeliveryTermsId; } if (SaleOrderRecord.Priority == null) { s.Priority = temp.Priority; } else if (SaleOrderRecord.Priority == "Low") { s.Priority = (int)(SaleOrderPriority.Low); } else if (SaleOrderRecord.Priority == "High") { s.Priority = (int)(SaleOrderPriority.High); } else { s.Priority = (int)(SaleOrderPriority.Normal); } if (temp != null) { s.DocTypeId = temp.DocTypeId; s.UnitConversionForId = temp.UnitConversionForId; } _SaleOrderHeaderService.Create(s); stemp = s; } //Object for SaleOrderLineDetail Model to Save Rate, Quantity, Product Product product = _ProductService.Find(SaleOrderRecord.Product); SaleOrderLine sl = new SaleOrderLine(); sl.SaleOrderHeaderId = stemp.SaleOrderHeaderId; sl.Rate = (decimal)SaleOrderRecord.Rate; sl.Qty = SaleOrderRecord.Quantity; sl.ProductId = product.ProductId; sl.Specification = product.ProductSpecification; sl.DueDate = SaleOrderRecord.DueDate; sl.DealUnitId = product.UnitId; sl.CreatedDate = DateTime.Now; sl.ModifiedDate = DateTime.Now; sl.DealQty = SaleOrderRecord.Quantity; sl.CreatedBy = User.Identity.Name; sl.ModifiedBy = User.Identity.Name; sl.Amount = sl.Rate * sl.Qty; sl.SaleOrderLineId = LinePk++; if (SaleOrderRecord.BuyerUpcCode != "" && SaleOrderRecord.BuyerUpcCode != null) { ProductBuyer productbuyer = new ProductBuyerService(_unitOfWork).Find(BuyerId, sl.ProductId); if (productbuyer != null) { productbuyer.BuyerUpcCode = SaleOrderRecord.BuyerUpcCode; new ProductBuyerService(_unitOfWork).Update(productbuyer); } else { ProductBuyer Temp = new ProductBuyer(); Temp.BuyerId = BuyerId; Temp.ProductId = sl.ProductId; Temp.BuyerUpcCode = SaleOrderRecord.BuyerUpcCode; Temp.CreatedDate = DateTime.Now; Temp.ModifiedDate = DateTime.Now; Temp.CreatedBy = User.Identity.Name; Temp.ModifiedBy = User.Identity.Name; Temp.ObjectState = Model.ObjectState.Added; new ProductBuyerService(_unitOfWork).Create(Temp); } } _SaleOrderLineService.Create(sl); new SaleOrderLineStatusService(_unitOfWork).CreateLineStatus(sl.SaleOrderLineId); count++; previousRecord = SaleOrderRecord.OrderNumber; _unitOfWork.Save(); } ViewBag.id = id; return(View("Sucess")); } }
public void Update(SaleOrderLine s) { s.ObjectState = ObjectState.Modified; _unitOfWork.Repository <SaleOrderLine>().Update(s); }
public void Delete(SaleOrderLine s) { _unitOfWork.Repository <SaleOrderLine>().Delete(s); }
public SaleOrderLine Create(SaleOrderLine S) { S.ObjectState = ObjectState.Added; _unitOfWork.Repository <SaleOrderLine>().Insert(S); return(S); }
private void DeleteSaleOrderLine(SaleOrderLine line, SqlConnection connection) { }
private void AlterSaleOrderLine(SaleOrderLine line, SqlConnection connection) { }
public void UpdateDB() { using (SqlConnection connection = new SqlConnection(ConnectionString)) { connection.Open(); try { IEnumerator <Product> enumerator = ProductRepository.GetProductRepository.GetEnumerator(); while (enumerator.MoveNext()) { Product product = enumerator.Current; } } catch (SqlException e) { throw e; } try { IEnumerator <Customer> enumerator = CustomerRepository.GetCustomerRepository.GetEnumerator(); while (enumerator.MoveNext()) { Customer cus = enumerator.Current; switch (cus.status) { case Status.Nothing: break; case Status.Alter: AlterCustomer(cus, connection); break; case Status.Create: CreateCustomer(cus, connection); break; case Status.Delete: DeleteCustomer(cus, connection); break; default: throw new FormatException($"Unknown status {cus.status}"); } } } catch (SqlException e) { throw e; } try { IEnumerator <Order> enumerator = OrderRepository.GetOrderRepository.GetEnumerator(); while (enumerator.MoveNext()) { Order order = enumerator.Current; switch (order.status) { case Status.Nothing: break; case Status.Alter: AlterOrder(order, connection); break; case Status.Create: CreateOrder(order, connection); break; case Status.Delete: DeleteOrder(order, connection); break; default: throw new FormatException($"Unknown status {order.status}"); } IEnumerator <SaleOrderLine> enumerator2 = order.GetEnumerator(); while (enumerator2.MoveNext()) { SaleOrderLine line = enumerator2.Current; switch (line.status) { case Status.Nothing: break; case Status.Alter: AlterSaleOrderLine(line, connection); break; case Status.Create: CreateSaleOrderLine(line, connection); break; case Status.Delete: DeleteSaleOrderLine(line, connection); break; default: throw new FormatException($"Unknown status {line.status}"); } } } } catch (SqlException e) { throw e; } connection.Close(); } }
void Init(SaleOrderLine _product) { Description = _product.DisplayName; }
public ProductQuotationModel(SaleOrderLine _product, string currency) { switch (_product.ProductKind) { case "saddle": { OrderStatusTypes = new ObservableCollection <string>(ProductConstants.ProductStatusRangeSaddle); break; } case "accessory": { OrderStatusTypes = new ObservableCollection <string>(ProductConstants.ProductStatusRangeAccessories); break; } case "other": { OrderStatusTypes = new ObservableCollection <string>(ProductConstants.ProductStatusRangeOther); break; } case "service": { OrderStatusTypes = new ObservableCollection <string>(ProductConstants.ProductStatusRangeService); break; } case "discount": { OrderStatusTypes = new ObservableCollection <string>(ProductConstants.ProductStatusRangeDiscount); break; } case "tradein": { OrderStatusTypes = new ObservableCollection <string>(ProductConstants.ProductStatusRangeTradeIn); break; } default: OrderStatusTypes = new ObservableCollection <string>(ProductConstants.ProductStatusRangeOther); break; } CurrencyLogo = currency; QuantitySource = ProductConstants.QuantityRange; Init(_product); Product = _product; UnitPrice = _product.PriceUnit; Quantity = (int)_product.ProductQty; ProductKind = QuotationSignPageModel.ParseEnum <ProductKind>(_product.ProductKind); if (OrderStatusTypes.Contains(_product.State?.Trim())) { OrderStatusIndex = OrderStatusTypes.IndexOf(_product.State?.Trim()); } else { OrderStatusIndex = 0; } }
public ActionResult DeletePost(SaleOrderLineViewModel vm) { List <LogTypeViewModel> LogList = new List <LogTypeViewModel>(); SaleOrderLine SaleOrderLine = _SaleOrderLineService.Find(vm.SaleOrderLineId); int?StockId = 0; StockId = SaleOrderLine.StockId; if (StockId != null) { new StockService(_unitOfWork).DeleteStock((int)StockId); } if (SaleOrderLine.ReferenceDocLineId != null && SaleOrderLine.ReferenceDocLineId != 0 && SaleOrderLine.ReferenceDocTypeId != null && SaleOrderLine.ReferenceDocTypeId != 0) { var temp = (from L in db.SaleEnquiryLine join H in db.SaleEnquiryHeader on L.SaleEnquiryHeaderId equals H.SaleEnquiryHeaderId into SaleEnquiryHeaderTable from SaleEnquiryHeaderTab in SaleEnquiryHeaderTable.DefaultIfEmpty() where SaleEnquiryHeaderTab.DocTypeId == SaleOrderLine.ReferenceDocTypeId && L.SaleEnquiryLineId == SaleOrderLine.ReferenceDocLineId select L).FirstOrDefault(); if (temp != null) { SaleEnquiryLine SaleEnquiryLine = new SaleEnquiryLineService(_unitOfWork).Find(temp.SaleEnquiryLineId); SaleEnquiryLine.LockReason = null; new SaleEnquiryLineService(_unitOfWork).Update(SaleEnquiryLine); } } new SaleOrderLineStatusService(_unitOfWork).Delete(vm.SaleOrderLineId); _SaleOrderLineService.Delete(vm.SaleOrderLineId); SaleOrderHeader header = new SaleOrderHeaderService(_unitOfWork).Find(SaleOrderLine.SaleOrderHeaderId); if (header.Status != (int)StatusConstants.Drafted && header.Status != (int)StatusConstants.Import) { header.Status = (int)StatusConstants.Modified; header.ModifiedBy = User.Identity.Name; header.ModifiedDate = DateTime.Now; new SaleOrderHeaderService(_unitOfWork).Update(header); } LogList.Add(new LogTypeViewModel { Obj = SaleOrderLine, }); XElement Modifications = new ModificationsCheckService().CheckChanges(LogList); try { _unitOfWork.Save(); } catch (Exception ex) { string message = _exception.HandleException(ex); TempData["CSEXCL"] += message; ViewBag.Docno = header.DocNo; ViewBag.DeliveryUnitList = new UnitService(_unitOfWork).GetUnitList().ToList(); return(PartialView("_Create", vm)); } LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel { DocTypeId = header.DocTypeId, DocId = header.SaleOrderHeaderId, DocLineId = SaleOrderLine.SaleOrderLineId, ActivityType = (int)ActivityTypeContants.Deleted, DocNo = header.DocNo, xEModifications = Modifications, DocDate = header.DocDate, DocStatus = header.Status, })); return(Json(new { success = true })); }
public ActionResult _CreatePost(SaleOrderLineViewModel svm) { SaleOrderLine s = Mapper.Map <SaleOrderLineViewModel, SaleOrderLine>(svm); SaleOrderHeader temp = new SaleOrderHeaderService(_unitOfWork).Find(s.SaleOrderHeaderId); //if (Command == "Submit" && (s.ProductId == 0)) // return RedirectToAction("Submit", "SaleOrderHeader", new { id = s.SaleOrderHeaderId }).Success("Data saved successfully"); var settings = new SaleOrderSettingsService(_unitOfWork).GetSaleOrderSettingsForDocument(temp.DocTypeId, temp.DivisionId, temp.SiteId); if (svm.Qty <= 0) { ModelState.AddModelError("Qty", "Please Check Qty"); } else if (svm.Rate <= 0 && settings.isMandatoryRate == true) { ModelState.AddModelError("Rate", "Please Check Rate"); } else if (svm.Amount <= 0 && settings.isMandatoryRate == true) { ModelState.AddModelError("Amount", "Please Check Amount"); } if (svm.DueDate < temp.DocDate) { ModelState.AddModelError("DueDate", "DueDate greater than DocDate"); } if (svm.SaleOrderLineId <= 0) { ViewBag.LineMode = "Create"; } else { ViewBag.LineMode = "Edit"; } if (ModelState.IsValid) { if (svm.SaleOrderLineId <= 0) { StockViewModel StockViewModel = new StockViewModel(); //Posting in Stock if (settings.isPostedInStock.HasValue && settings.isPostedInStock == true) { StockViewModel.StockHeaderId = temp.StockHeaderId ?? 0; StockViewModel.DocHeaderId = temp.SaleOrderHeaderId; StockViewModel.DocLineId = s.SaleOrderLineId; StockViewModel.DocTypeId = temp.DocTypeId; StockViewModel.StockHeaderDocDate = temp.DocDate; StockViewModel.StockDocDate = temp.DocDate; StockViewModel.DocNo = temp.DocNo; StockViewModel.DivisionId = temp.DivisionId; StockViewModel.SiteId = temp.SiteId; StockViewModel.CurrencyId = null; StockViewModel.HeaderProcessId = null; StockViewModel.PersonId = temp.SaleToBuyerId; StockViewModel.ProductId = s.ProductId; StockViewModel.HeaderFromGodownId = null; StockViewModel.HeaderGodownId = null; StockViewModel.GodownId = temp.GodownId ?? 0; StockViewModel.ProcessId = null; StockViewModel.LotNo = null; StockViewModel.CostCenterId = null; StockViewModel.Qty_Iss = 0; StockViewModel.Qty_Rec = s.Qty; StockViewModel.Rate = s.Rate; StockViewModel.ExpiryDate = null; StockViewModel.Specification = s.Specification; StockViewModel.Dimension1Id = s.Dimension1Id; StockViewModel.Dimension2Id = s.Dimension2Id; StockViewModel.Dimension3Id = s.Dimension3Id; StockViewModel.Dimension4Id = s.Dimension4Id; StockViewModel.Remark = s.Remark; StockViewModel.ProductUidId = null; StockViewModel.Status = temp.Status; StockViewModel.CreatedBy = temp.CreatedBy; StockViewModel.CreatedDate = DateTime.Now; StockViewModel.ModifiedBy = temp.ModifiedBy; StockViewModel.ModifiedDate = DateTime.Now; string StockPostingError = ""; StockPostingError = new StockService(_unitOfWork).StockPost(ref StockViewModel); if (StockPostingError != "") { ModelState.AddModelError("", StockPostingError); return(PartialView("_Create", svm)); } s.StockId = StockViewModel.StockId; if (temp.StockHeaderId == null) { temp.StockHeaderId = StockViewModel.StockHeaderId; } } s.CreatedDate = DateTime.Now; s.ModifiedDate = DateTime.Now; s.CreatedBy = User.Identity.Name; s.ModifiedBy = User.Identity.Name; s.ObjectState = Model.ObjectState.Added; _SaleOrderLineService.Create(s); new SaleOrderLineStatusService(_unitOfWork).CreateLineStatus(s.SaleOrderLineId); SaleOrderHeader header = new SaleOrderHeaderService(_unitOfWork).Find(s.SaleOrderHeaderId); if (temp.StockHeaderId != null && temp.StockHeaderId != 0) { header.StockHeaderId = temp.StockHeaderId; } if (header.Status != (int)StatusConstants.Drafted && header.Status != (int)StatusConstants.Import) { header.Status = (int)StatusConstants.Modified; header.ModifiedDate = DateTime.Now; header.ModifiedBy = User.Identity.Name; } new SaleOrderHeaderService(_unitOfWork).Update(header); try { _unitOfWork.Save(); } catch (Exception ex) { string message = _exception.HandleException(ex); TempData["CSEXCL"] += message; PrepareViewBag(temp); return(PartialView("_Create", svm)); } LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel { DocTypeId = header.DocTypeId, DocId = header.SaleOrderHeaderId, DocLineId = s.SaleOrderLineId, ActivityType = (int)ActivityTypeContants.Added, DocNo = header.DocNo, DocDate = header.DocDate, DocStatus = header.Status, })); return(RedirectToAction("_Create", new { id = s.SaleOrderHeaderId })); } else { List <LogTypeViewModel> LogList = new List <LogTypeViewModel>(); SaleOrderHeader header = new SaleOrderHeaderService(_unitOfWork).Find(svm.SaleOrderHeaderId); StringBuilder logstring = new StringBuilder(); int status = header.Status; SaleOrderLine temp1 = _SaleOrderLineService.Find(svm.SaleOrderLineId); SaleOrderLine ExRec = new SaleOrderLine(); ExRec = Mapper.Map <SaleOrderLine>(temp1); //End of Tracking the Modifications:: if (temp1.StockId != null) { StockViewModel StockViewModel = new StockViewModel(); StockViewModel.StockHeaderId = temp.StockHeaderId ?? 0; StockViewModel.StockId = temp1.StockId ?? 0; StockViewModel.DocHeaderId = temp1.SaleOrderHeaderId; StockViewModel.DocLineId = temp1.SaleOrderLineId; StockViewModel.DocTypeId = temp.DocTypeId; StockViewModel.StockHeaderDocDate = temp.DocDate; StockViewModel.StockDocDate = temp.DocDate; StockViewModel.DocNo = temp.DocNo; StockViewModel.DivisionId = temp.DivisionId; StockViewModel.SiteId = temp.SiteId; StockViewModel.CurrencyId = null; StockViewModel.HeaderProcessId = null; StockViewModel.PersonId = temp.SaleToBuyerId; StockViewModel.ProductId = s.ProductId; StockViewModel.HeaderFromGodownId = null; StockViewModel.HeaderGodownId = temp.GodownId; StockViewModel.GodownId = temp.GodownId ?? 0; StockViewModel.ProcessId = null; StockViewModel.LotNo = null; StockViewModel.CostCenterId = null; StockViewModel.Qty_Iss = 0; StockViewModel.Qty_Rec = s.Qty; StockViewModel.Rate = temp1.Rate; StockViewModel.ExpiryDate = null; StockViewModel.Specification = temp1.Specification; StockViewModel.Dimension1Id = temp1.Dimension1Id; StockViewModel.Dimension2Id = temp1.Dimension2Id; StockViewModel.Dimension3Id = temp1.Dimension3Id; StockViewModel.Dimension4Id = temp1.Dimension4Id; StockViewModel.Remark = s.Remark; StockViewModel.ProductUidId = null; StockViewModel.Status = temp.Status; StockViewModel.CreatedBy = temp1.CreatedBy; StockViewModel.CreatedDate = temp1.CreatedDate; StockViewModel.ModifiedBy = User.Identity.Name; StockViewModel.ModifiedDate = DateTime.Now; string StockPostingError = ""; StockPostingError = new StockService(_unitOfWork).StockPost(ref StockViewModel); if (StockPostingError != "") { ModelState.AddModelError("", StockPostingError); return(PartialView("_Create", svm)); } } temp1.DueDate = svm.DueDate; temp1.ProductId = svm.ProductId ?? 0; temp1.Specification = svm.Specification; temp1.Dimension1Id = svm.Dimension1Id; temp1.Dimension2Id = svm.Dimension2Id; temp1.Dimension3Id = svm.Dimension3Id; temp1.Dimension4Id = svm.Dimension4Id; temp1.Qty = svm.Qty ?? 0; temp1.DealQty = svm.DealQty ?? 0; temp1.DealUnitId = svm.DealUnitId; temp1.UnitConversionMultiplier = svm.UnitConversionMultiplier; temp1.Rate = svm.Rate ?? 0; temp1.Amount = svm.Amount ?? 0; temp1.Remark = svm.Remark; temp1.ModifiedDate = DateTime.Now; temp1.ModifiedBy = User.Identity.Name; _SaleOrderLineService.Update(temp1); LogList.Add(new LogTypeViewModel { ExObj = ExRec, Obj = temp1, }); if (header.Status != (int)StatusConstants.Drafted && header.Status != (int)StatusConstants.Import) { header.Status = (int)StatusConstants.Modified; header.ModifiedBy = User.Identity.Name; header.ModifiedDate = DateTime.Now; new SaleOrderHeaderService(_unitOfWork).Update(header); } XElement Modifications = new ModificationsCheckService().CheckChanges(LogList); try { _unitOfWork.Save(); } catch (Exception ex) { string message = _exception.HandleException(ex); TempData["CSEXCL"] += message; PrepareViewBag(temp); return(PartialView("_Create", svm)); } //Saving the Activity Log LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel { DocTypeId = temp.DocTypeId, DocId = temp1.SaleOrderHeaderId, DocLineId = temp1.SaleOrderLineId, ActivityType = (int)ActivityTypeContants.Modified, DocNo = temp.DocNo, xEModifications = Modifications, DocDate = temp.DocDate, DocStatus = temp.Status, })); //End of Saving the Activity Log return(Json(new { success = true })); } } ViewBag.Status = temp.Status; PrepareViewBag(temp); return(PartialView("_Create", svm)); }
public void CreateSaleOrder(int SaleEnquiryHeaderId) { SaleEnquiryHeader EnquiryHeader = new SaleEnquiryHeaderService(_unitOfWork).Find(SaleEnquiryHeaderId); SaleEnquirySettings Settings = new SaleEnquirySettingsService(_unitOfWork).GetSaleEnquirySettingsForDucument(EnquiryHeader.DocTypeId, EnquiryHeader.DivisionId, EnquiryHeader.SiteId); SaleOrderHeader OrderHeader = new SaleOrderHeader(); OrderHeader.DocTypeId = (int)Settings.SaleOrderDocTypeId; OrderHeader.DocDate = EnquiryHeader.DocDate; OrderHeader.DocNo = EnquiryHeader.DocNo; OrderHeader.DivisionId = EnquiryHeader.DivisionId; OrderHeader.SiteId = EnquiryHeader.SiteId; OrderHeader.BuyerOrderNo = EnquiryHeader.BuyerEnquiryNo; OrderHeader.SaleToBuyerId = EnquiryHeader.SaleToBuyerId; OrderHeader.BillToBuyerId = EnquiryHeader.BillToBuyerId; OrderHeader.CurrencyId = EnquiryHeader.CurrencyId; OrderHeader.Priority = EnquiryHeader.Priority; OrderHeader.UnitConversionForId = EnquiryHeader.UnitConversionForId; OrderHeader.ShipMethodId = EnquiryHeader.ShipMethodId; OrderHeader.ShipAddress = EnquiryHeader.ShipAddress; OrderHeader.DeliveryTermsId = EnquiryHeader.DeliveryTermsId; OrderHeader.Remark = EnquiryHeader.Remark; OrderHeader.DueDate = EnquiryHeader.DueDate; OrderHeader.ActualDueDate = EnquiryHeader.ActualDueDate; OrderHeader.Advance = EnquiryHeader.Advance; OrderHeader.ReferenceDocId = EnquiryHeader.SaleEnquiryHeaderId; OrderHeader.ReferenceDocTypeId = EnquiryHeader.DocTypeId; OrderHeader.CreatedDate = DateTime.Now; OrderHeader.ModifiedDate = DateTime.Now; OrderHeader.ModifiedDate = DateTime.Now; OrderHeader.ModifiedBy = User.Identity.Name; OrderHeader.Status = (int)StatusConstants.Submitted; OrderHeader.ReviewBy = User.Identity.Name; OrderHeader.ReviewCount = 1; //OrderHeader.LockReason = "Sale order is created for enquiry.Now you can't modify enquiry, changes can be done in sale order."; new SaleOrderHeaderService(_unitOfWork).Create(OrderHeader); IEnumerable <SaleEnquiryLine> LineList = new SaleEnquiryLineService(_unitOfWork).GetSaleEnquiryLineListForHeader(SaleEnquiryHeaderId).Where(m => m.ProductId != null); int i = 0; foreach (SaleEnquiryLine Line in LineList) { SaleOrderLine OrderLine = new SaleOrderLine(); OrderLine.SaleOrderLineId = i; i = i - 1; OrderLine.DueDate = Line.DueDate; OrderLine.ProductId = Line.ProductId ?? 0; OrderLine.Specification = Line.Specification; OrderLine.Dimension1Id = Line.Dimension1Id; OrderLine.Dimension2Id = Line.Dimension2Id; OrderLine.Qty = Line.Qty; OrderLine.DealQty = Line.DealQty; OrderLine.DealUnitId = Line.DealUnitId; OrderLine.UnitConversionMultiplier = Line.UnitConversionMultiplier; OrderLine.Rate = Line.Rate; OrderLine.Amount = Line.Amount; OrderLine.Remark = Line.Remark; OrderLine.ReferenceDocTypeId = EnquiryHeader.DocTypeId; OrderLine.ReferenceDocLineId = Line.SaleEnquiryLineId; OrderLine.CreatedDate = DateTime.Now; OrderLine.ModifiedDate = DateTime.Now; OrderLine.CreatedBy = User.Identity.Name; OrderLine.ModifiedBy = User.Identity.Name; new SaleOrderLineService(_unitOfWork).Create(OrderLine); new SaleOrderLineStatusService(_unitOfWork).CreateLineStatus(OrderLine.SaleOrderLineId); Line.LockReason = "Sale order is created for enquiry.Now you can't modify enquiry, changes can be done in sale order."; new SaleEnquiryLineService(_unitOfWork).Update(Line); } }