public ActionResult Search(PurchaseOrderViewModels model) { try { if (!string.IsNullOrEmpty(model.StoreID) || model.ApplyFrom.HasValue || model.ApplyTo.HasValue) { model.ListItem = _factory.GetData(model.StoreID, listCompanyId, model.ApplyFrom, model.ApplyTo); model.ListItem.ForEach(x => { var currency = lstCur.Where(z => z.Value.Equals(x.Store)).FirstOrDefault(); x.Symbol = currency == null ? "$" : currency.Text; //x.StoreName = lstStore.Where(ww => ww.Value == x.StoreID).Select(ss => ss.Text).FirstOrDefault(); x.StoreName = lstStore.Where(ww => ww.Id == x.StoreID).Select(ss => ss.Name).FirstOrDefault(); }); CurrentUser.StoreId = model.StoreID; } } catch (Exception e) { _logger.Error("PurchaseOrderSearch: " + e); return(new HttpStatusCodeResult(400, e.Message)); } return(PartialView("_ListData", model)); }
public PartialViewResult _ViewPartial(int id) { try { PurchaseOrderViewModels model = new PurchaseOrderViewModels(); model.PurchaseOrder = purchaseorderRepository.FindOneOrderById(id); model.PurchaseOrderItemsList = purchaseorderRepository.FindOneOrderItemById(id); //Bind Branch var BranchList = purchaseorderRepository.GetBranchList().ToList(); model.BranchList = BranchList; //Bind VAT var VATList = purchaseorderRepository.GetVAT().ToList(); model.VATList = VATList; //Bind Product var ProductList = purchaseorderRepository.GetProductList().ToList(); model.ProductList = ProductList; //Bind Businesspartner var BusinessParterList = purchaseorderRepository.GetBusinessPartnerList().ToList(); model.BusinessPartnerList = BusinessParterList; return(PartialView(model)); } catch (Exception ex) { ExceptionHandler.LogException(ex); ViewBag.AppErrorMessage = ex.Message; return(PartialView("Error")); } }
public ActionResult Index() { try { PurchaseOrderViewModels model = new PurchaseOrderViewModels(); model.StoreID = CurrentUser.StoreId; model.ApplyFrom = DateTime.Now; model.ApplyTo = DateTime.Now; return(View(model)); } catch (Exception ex) { _logger.Error("PurchaseOrderIndex: " + ex); return(new HttpStatusCodeResult(400, ex.Message)); } }
// GET: PurchaseOrders public ActionResult Index() { try { LogHandler.WriteLog("Purchase Index page requested by #UserId"); var qList = purchaseorderRepository.GetAllPurchaseOrders().ToList(); PurchaseOrderViewModels model = new PurchaseOrderViewModels(); //model.PurchaseQuotation.Quotation_Status = "Open"; model.PurchaseOrderList = qList; //Bind Branch var BranchList = purchaseorderRepository.GetBranchList().ToList(); model.BranchList = BranchList; //Bind VAT var VATList = purchaseorderRepository.GetVAT().ToList(); model.VATList = VATList; //Bind Product var ProductList = purchaseorderRepository.GetProductList().ToList(); model.ProductList = ProductList; //Bind Businesspartner var BusinessParterList = purchaseorderRepository.GetBusinessPartnerList().ToList(); model.BusinessPartnerList = BusinessParterList; //Bind PurchaseQuotation var qList1 = purchaseorderRepository.GetPurchaseQuotation().ToList(); model.PurchaseQuotationList = qList1; return(View(model)); } catch (Exception ex) { ExceptionHandler.LogException(ex); ViewBag.AppErrorMessage = ex.Message; return(View("Error")); } }
public ActionResult Index(string submitButton, PurchaseOrderViewModels model, HttpPostedFileBase file) { try { //ApplicationUser currentUser = ApplicationUserManager.GetApplicationUser(User.Identity.Name, HttpContext.GetOwinContext()); if (submitButton == "Save") { model.PurchaseOrder.Posting_Date = DateTime.Now; model.PurchaseOrder.Document_Date = DateTime.Now; model.PurchaseOrder.Order_Status = "Open"; model.PurchaseOrder.TargetDocId = "0"; model.PurchaseOrder.Created_Branc_Id = CurrentBranchId; //currentUser.Created_Branch_Id; model.PurchaseOrder.Created_Date = DateTime.Now; model.PurchaseOrder.Created_User_Id = CurrentUser.Id; //currentUser.Created_User_Id; //GetUserId() //model.PurchaseOrder.Modified_User_Id = CurrentUser.Id; ;//currentUser.Modified_User_Id; //model.PurchaseOrder.Modified_Date = DateTime.Now; //model.PurchaseOrder.Modified_Branch_Id = CurrentBranchId;//currentUser.Modified_Branch_Id; var QuotationList = model.PurchaseOrderItemsList.Where(x => x.IsDummy == 0); model.PurchaseOrderItemsList = QuotationList.ToList(); if (purchaseorderRepository.AddNewPurchaseOrder(model.PurchaseOrder, model.PurchaseOrderItemsList, ref ErrorMessage)) { //XMLGenerate_SAPInsert(model); //for (int i = 0; i < model.PurchaseQuotationItemList.Count; i++) //{ // XMLGenerate_Quotation_SAPInsert(model.PurchaseQuotationItemList[i]); //} return(RedirectToAction("Index", "PurchaseOrders")); } else { ViewBag.AppErrorMessage = ErrorMessage; return(View("Error")); } } else if (submitButton == "Update") { model.PurchaseOrder.Posting_Date = DateTime.Now; model.PurchaseOrder.Document_Date = DateTime.Now; //model.PurchaseOrder.Order_Status = "Open"; model.PurchaseOrder.TargetDocId = "0"; //model.PurchaseOrder.Created_Branc_Id = CurrentBranchId;//currentUser.Created_Branch_Id; //model.PurchaseOrder.Created_Date = DateTime.Now; //model.PurchaseOrder.Created_User_Id = CurrentUser.Id;//currentUser.Created_User_Id; //GetUserId() model.PurchaseOrder.Modified_User_Id = CurrentUser.Id; //currentUser.Modified_User_Id; model.PurchaseOrder.Modified_Date = DateTime.Now; model.PurchaseOrder.Modified_Branch_Id = CurrentBranchId; //currentUser.Modified_Branch_Id; var QuotationList = model.PurchaseOrderItemsList.Where(x => x.IsDummy == 0); model.PurchaseOrderItemsList = QuotationList.ToList(); if (purchaseorderRepository.UpdatePurchaseOrder(model.PurchaseOrder, model.PurchaseOrderItemsList, ref ErrorMessage)) { return(RedirectToAction("Index", "PurchaseOrders")); } else { ViewBag.AppErrorMessage = ErrorMessage; return(View("Error")); } } else if (submitButton == " Save") { PurchaseOrderViewModels model1 = new PurchaseOrderViewModels(); model1.PurchaseQuotation = purchaseorderRepository.FindOneQuotationById(model.PurchaseQuotation.Purchase_Quote_Id); model1.PurchaseQuotationItemList = purchaseorderRepository.FindOneQuotationItemById(model.PurchaseQuotation.Purchase_Quote_Id); if (model1.PurchaseQuotation.Vendor == model.PurchaseQuotation.Vendor) { //for BaseDocId for (int j = 0; j < model.PurchaseQuotationItemList.Count; j++) { if (model1.PurchaseQuotationItemList[j].Product_id == model.PurchaseQuotationItemList[j].Product_id) { model.PurchaseOrder.BaseDocId = model.PurchaseQuotation.Purchase_Quote_Id; } } //for BaseDocLink for (int j = 0; j < model.PurchaseQuotationItemList.Count; j++) { if (model1.PurchaseQuotationItemList[j].Product_id == model.PurchaseQuotationItemList[j].Product_id) { model.PurchaseOrderItemsList[j].BaseDocLink = "Y"; } else { model.PurchaseOrderItemsList[j].BaseDocLink = "N"; } model.PurchaseOrder.Purchase_Order_Id = model.PurchaseQuotation.Purchase_Quote_Id; model.PurchaseOrder.Reference_Number = model.PurchaseQuotation.Reference_Number; model.PurchaseOrder.Vendor = model.PurchaseQuotation.Vendor; model.PurchaseOrder.Order_Status = "Open"; model.PurchaseOrder.Posting_Date = DateTime.Now; // model.PurchaseQuotation.Posting_Date; model.PurchaseOrder.Delivery_Date = model.PurchaseQuotation.Valid_Date; model.PurchaseOrder.Document_Date = DateTime.Now; //model.PurchaseQuotation.Posting_Date; model.PurchaseOrder.Ship_To = model.PurchaseQuotation.Ship_To; model.PurchaseOrder.Freight = Convert.ToDecimal(model.PurchaseQuotation.Freight); model.PurchaseOrder.Loading = Convert.ToDecimal(model.PurchaseQuotation.Loading); model.PurchaseOrder.TotalBefDocDisc = model.PurchaseQuotation.TotalBefDocDisc; model.PurchaseOrder.DocDiscAmt = model.PurchaseQuotation.DocDiscAmt; model.PurchaseOrder.TotalBefDocDisc = model.PurchaseQuotation.TotalQtnAmt; model.PurchaseOrder.TaxAmt = model.PurchaseQuotation.TaxAmt; model.PurchaseOrder.Remarks = model.PurchaseQuotation.Remarks; model.PurchaseOrder.TargetDocId = "0"; model.PurchaseOrder.Created_Branc_Id = CurrentBranchId; //currentUser.Created_Branch_Id; model.PurchaseOrder.Created_Date = DateTime.Now; model.PurchaseOrder.Created_User_Id = CurrentUser.Id; //currentUser.Created_User_Id; //GetUserId() //model.PurchaseOrder.Modified_User_Id = CurrentUser.Id;//currentUser.Modified_User_Id; //model.PurchaseOrder.Modified_Date = DateTime.Now; //model.PurchaseOrder.Modified_Branch_Id = CurrentBranchId;//currentUser.Modified_Branch_Id; var QuotationList = model.PurchaseQuotationItemList.Where(x => x.IsDummy == 0); model.PurchaseQuotationItemList = QuotationList.ToList(); model.PurchaseOrderItemsList[j].Product_id = model.PurchaseQuotationItemList[j].Product_id; model.PurchaseOrderItemsList[j].Quantity = Convert.ToInt32(model.PurchaseQuotationItemList[j].Quoted_qty); model.PurchaseOrderItemsList[j].Unit_price = model.PurchaseQuotationItemList[j].Unit_price; model.PurchaseOrderItemsList[j].Discount_percent = model.PurchaseQuotationItemList[j].Discount_percent; model.PurchaseOrderItemsList[j].Vat_Code = model.PurchaseQuotationItemList[j].Vat_Code; model.PurchaseOrderItemsList[j].LineTotal = model.PurchaseQuotationItemList[j].LineTotal; model.PurchaseOrderItemsList[j].Freight_Loading = "0";// model.PurchaseQuotationItemList[i].Freight_Loading; } if (purchaseorderRepository.AddNewPurchaseOrder(model.PurchaseOrder, model.PurchaseOrderItemsList, ref ErrorMessage)) { //return RedirectToAction("Index", "PurchaseOrders"); //for Purchase Quotation/Purchase Quotation item table update for (int j = 0; j < model.PurchaseQuotationItemList.Count; j++) { if (model1.PurchaseQuotationItemList[j].Product_id == model.PurchaseQuotationItemList[j].Product_id && model.PurchaseQuotationItemList[j].Quoted_qty >= model1.PurchaseQuotationItemList[j].Quoted_qty) { model1.PurchaseQuotation.Quotation_Status = "Closed"; if (model1.PurchaseQuotation.TargetDocId == "") { model1.PurchaseQuotation.TargetDocId = Convert.ToString(model.PurchaseOrder.Purchase_Order_Id); } else { model1.PurchaseQuotation.TargetDocId = model1.PurchaseQuotation.TargetDocId + "," + Convert.ToString(model.PurchaseOrder.Purchase_Order_Id); } model1.PurchaseQuotationItemList[j].Quote_Item_Id = model1.PurchaseQuotationItemList[j].Quote_Item_Id; model1.PurchaseQuotationItemList[j].Purchase_Quote_Id = model1.PurchaseQuotationItemList[j].Purchase_Quote_Id; model1.PurchaseQuotationItemList[j].Quoted_date = model1.PurchaseQuotationItemList[j].Quoted_date; model1.PurchaseQuotationItemList[j].Used_qty = model1.PurchaseQuotationItemList[j].Used_qty + Convert.ToInt32(model.PurchaseQuotationItemList[j].Quoted_qty); model1.PurchaseQuotationItemList[j].Product_id = model.PurchaseQuotationItemList[j].Product_id; model1.PurchaseQuotationItemList[j].Unit_price = model.PurchaseQuotationItemList[j].Unit_price; model1.PurchaseQuotationItemList[j].Discount_percent = model.PurchaseQuotationItemList[j].Discount_percent; model1.PurchaseQuotationItemList[j].Vat_Code = model.PurchaseQuotationItemList[j].Vat_Code; model1.PurchaseQuotationItemList[j].LineTotal = model.PurchaseQuotationItemList[j].LineTotal; } else if (model1.PurchaseQuotationItemList[j].Product_id == model.PurchaseQuotationItemList[j].Product_id && model.PurchaseQuotationItemList[j].Quoted_qty < model1.PurchaseQuotationItemList[j].Quoted_qty) { model1.PurchaseQuotation.Quotation_Status = "Open"; if (model1.PurchaseQuotation.TargetDocId == "") { model1.PurchaseQuotation.TargetDocId = Convert.ToString(model.PurchaseOrder.Purchase_Order_Id); } else { model1.PurchaseQuotation.TargetDocId = model1.PurchaseQuotation.TargetDocId + "," + Convert.ToString(model.PurchaseOrder.Purchase_Order_Id); } model1.PurchaseQuotationItemList[j].Quote_Item_Id = model1.PurchaseQuotationItemList[j].Quote_Item_Id; model1.PurchaseQuotationItemList[j].Purchase_Quote_Id = model1.PurchaseQuotationItemList[j].Purchase_Quote_Id; model1.PurchaseQuotationItemList[j].Quoted_date = model1.PurchaseQuotationItemList[j].Quoted_date; model1.PurchaseQuotationItemList[j].Used_qty = model1.PurchaseQuotationItemList[j].Used_qty + Convert.ToInt32(model.PurchaseQuotationItemList[j].Quoted_qty); model1.PurchaseQuotationItemList[j].Product_id = model.PurchaseQuotationItemList[j].Product_id; model1.PurchaseQuotationItemList[j].Unit_price = model.PurchaseQuotationItemList[j].Unit_price; model1.PurchaseQuotationItemList[j].Discount_percent = model.PurchaseQuotationItemList[j].Discount_percent; model1.PurchaseQuotationItemList[j].Vat_Code = model.PurchaseQuotationItemList[j].Vat_Code; model1.PurchaseQuotationItemList[j].LineTotal = model.PurchaseQuotationItemList[j].LineTotal; } } model1.PurchaseQuotation.Creating_Branch = CurrentBranchId; model1.PurchaseQuotation.Created_Branc_Id = CurrentBranchId; //currentUser.Created_Branch_Id; model1.PurchaseQuotation.Created_Date = DateTime.Now; model1.PurchaseQuotation.Created_User_Id = CurrentUser.Id; //currentUser.Created_User_Id; //GetUserId() //model1.PurchaseQuotation.Modified_User_Id = CurrentUser.Id;//currentUser.Modified_User_Id; //model1.PurchaseQuotation.Modified_Date = DateTime.Now; //model1.PurchaseQuotation.Modified_Branch_Id = CurrentBranchId;//currentUser.Modified_Branch_Id; purchaseorderRepository.UpdateQuotation(model1.PurchaseQuotation, model1.PurchaseQuotationItemList, ref ErrorMessage); return(RedirectToAction("Index", "PurchaseOrders")); } else { ViewBag.AppErrorMessage = ErrorMessage; return(View("Error")); } } } return(RedirectToAction("Index", "PurchaseOrders")); } //catch (Exception ex) //{ // ExceptionHandler.LogException(ex); // ViewBag.AppErrorMessage = ex.Message; // return View("Error"); //} catch (OptimisticConcurrencyException ex) { ObjectStateEntry entry = ex.StateEntries[0]; PurchaseOrder post = entry.Entity as PurchaseOrder; //Post is the entity name he is using. Rename it with yours Console.WriteLine("Failed to save {0} because it was changed in the database", post.Purchase_Order_Id); return(View("Error")); } //catch (DbEntityValidationException dbEx) //{ // var errorList = new List<string>(); // foreach (var validationErrors in dbEx.EntityValidationErrors) // { // foreach (var validationError in validationErrors.ValidationErrors) // { // errorList.Add(String.Format("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage)); // } // } // return View("Error"); //} }