/// <summary> /// This method is used to get new PO /// </summary> public void GetNewPO() { VisibilityForImage = Visibility.Collapsed; IsNew = true; ID = 0; SelectedSupplierID = 0; BillToAddress = string.Empty; ShipToAddress = string.Empty; //ValidForDays = 0; OrderNo = GenerateNewOrderNo(); TermsAndConditions = TandC; OrderDate = DateTime.Now.Date; DeliveryDate = DateTime.Now.Date; TotalBeforeTax = 0; TotalTax = 0; TotalAfterTax = 0; TotalBeforeTaxStr = Convert.ToString(0); TotalTaxStr = Convert.ToString(0); TotalAfterTaxStr = Convert.ToString(0); POErrors = string.Empty; AllFieldsEnabled = true; AllFieldsReadonly = false; SupplierEnabled = true;// added on 23 may 2017 PurchaseOrderEntity = new PurchaseOrderEntity(); PODetailsEntity.Clear(); LstSuppliers = supplierRepository.GetAllSupplier().Where(s => s.IsInActive != "Y").ToList(); ProductAndServices = ProductAndServices.OrderBy(x => x.PSName).Where(x => x.IsInActive == "N").ToObservable(); // PODetailsEntity = new ObservableCollection<DataGridViewModel>(); var row = new DataGridViewModel(ProductList.Where(x => x.IsInActive == "N").ToList()); //row.PQQty = 1; //row.PQDiscount = 0; //row.GSTRate = TaxRate; //row.GSTRateStr = Convert.ToString(TaxRate) + "%"; PODetailsEntity.Add(row); OnPropertyChanged("PODetailsEntity"); var lstOptions = pandsRepository.GetOptionDetails(); bool?tax = lstOptions.ShowAmountIncGST; if (tax == true) { ExcludingTax = false; IncludingTax = true; } else { IncludingTax = false; ExcludingTax = true; } }
public void GetDebitNote(object param) { if (param != null) { DebitNoteForm pqf = dnRepository.GetDebitNoteDetails(Convert.ToString(param)); this.ID = pqf.DebitNote.ID; this.DebitNo = pqf.DebitNote.DebitNo; this.DebitDate = pqf.DebitNote.DebitDate; this.SupplierCreditNoteNo = pqf.DebitNote.SupplierCreditNoteNo; this.SupplierCreditNoteDate = pqf.DebitNote.SupplierCreditNoteDate; this.SupplierCreditNoteAmount = pqf.DebitNote.SupplierCreditNoteAmount; this.SelectedSupplierID = pqf.DebitNote.SupplierID; this.PurchaseInvoiceID = pqf.DebitNote.PurchaseInvoiceID; this.PurchaseInvoiceNo = pqf.DebitNote.PurchaseInvoiceNo; this.TermsAndConditions = pqf.DebitNote.TermsAndConditions; this.TotalBeforeTax = pqf.DebitNote.TotalBeforeTax; this.TotalTax = pqf.DebitNote.TotalTax; this.TotalAfterTax = pqf.DebitNote.TotalAfterTax; this.TotalBeforeTaxStr = Convert.ToString(this.TotalBeforeTax); this.TotalTaxStr = Convert.ToString(TotalTax); this.TotalAfterTaxStr = Convert.ToString(TotalAfterTax); this.Status = pqf.DebitNote.Status; this.PQDetailsEntity = new ObservableCollection <DataGridViewModel>(); foreach (var item in pqf.InvoiceDetails) { DataGridViewModel pqEntity = new DataGridViewModel(ProductList); pqEntity.SelectedPSID = Convert.ToString(item.PINo); pqEntity.PandSCode = item.PandSCode; pqEntity.PandSName = item.PandSName; pqEntity.GSTRate = Math.Round(Convert.ToDecimal(item.GSTRate), DecimalPlaces); pqEntity.GSTRateStr = Convert.ToString(pqEntity.GSTRate) + "%"; pqEntity.PQQty = item.PIQty; pqEntity.PQPrice = Convert.ToString(item.Price); pqEntity.PQDiscount = Math.Round((decimal)item.PIDiscount, 2); // PQDEntity.GSTRate = item.GSTRate; pqEntity.PQAmount = item.PIAmount; PQDetailsEntity.Add(pqEntity); } } }
public void GetPurchaseOrder(string pqNo) { // Mouse.OverrideCursor = Cursors.Wait; PurchaseOrderForm pqf = pqRepository.GetPurchaseOrder(pqNo); this.ID = pqf.Order.ID; this.OrderNo = pqf.Order.OrderNo; this.OrderDate = pqf.Order.OrderDate; //this.ValidForDays = pqf.Order.ValidForDays; this.DeliveryDate = pqf.Order.DeliveryDate; this.SelectedSupplierID = pqf.Order.SupplierID; //if (this.SelectedSupplierID > 0) //{ // GetSupplierDetails(); //} this.TermsAndConditions = pqf.Order.TermsAndConditions; this.TotalBeforeTax = pqf.Order.TotalBeforeTax; this.TotalTax = pqf.Order.TotalTax; this.TotalAfterTax = pqf.Order.TotalAfterTax; this.TotalBeforeTaxStr = Convert.ToString(this.TotalBeforeTax); this.TotalTaxStr = Convert.ToString(TotalTax); this.TotalAfterTaxStr = Convert.ToString(TotalAfterTax); if (pqf.Order.ExcIncGST == true) { ExcludingTax = false; IncludingTax = true; // PODEntity.GSTRate = 0; } else { ExcludingTax = true; IncludingTax = false; // PODEntity.GSTRate = TaxRate; } if (PO_Conv_to_PI == true) { AllFieldsReadonly = true; AllFieldsEnabled = false; } else { AllFieldsReadonly = false; AllFieldsEnabled = true; LstSuppliers = supplierRepository.GetAllSupplier().Where(s => s.IsInActive != "Y").ToList(); ProductAndServices = ProductAndServices.OrderBy(x => x.PSName).Where(x => x.IsInActive != "Y").ToObservable(); } this.Status = pqf.Order.Status; if (Status == Convert.ToByte(PO_Status.Cancelled)) { StatusString = "Cancelled"; VisibilityForImage = Visibility.Visible; AllFieldsEnabled = false; AllFieldsReadonly = true; } else if (Status == Convert.ToByte(PO_Status.Collected)) { StatusString = "Collected"; VisibilityForImage = Visibility.Visible; AllFieldsEnabled = false; AllFieldsReadonly = true; } else if (Status == Convert.ToByte(PO_Status.Refunded)) { StatusString = "Refunded"; VisibilityForImage = Visibility.Visible; AllFieldsEnabled = false; AllFieldsReadonly = true; } else { StatusString = ""; VisibilityForImage = Visibility.Collapsed; AllFieldsEnabled = true; AllFieldsReadonly = false; } //this.PO_Conv_to_PO = pqf.Order.PO_Conv_to_PO; this.PO_Conv_to_PI = pqf.Order.PO_Conv_to_PI; SupplierEnabled = false;// added on 23 may 2017 this.PODetailsEntity = new ObservableCollection <DataGridViewModel>(); foreach (var item in pqf.OrderDetails) { DataGridViewModel pqEntity = new DataGridViewModel(ProductList); pqEntity.SelectedPSID = Convert.ToString(item.PONo); pqEntity.PandSCode = item.PandSCode; pqEntity.PandSName = item.PandSName; pqEntity.GSTRate = Math.Round(Convert.ToDecimal(item.GSTRate), DecimalPlaces); pqEntity.GSTRateStr = Convert.ToString(pqEntity.GSTRate) + "%"; pqEntity.PQQty = item.POQty; pqEntity.PQPrice = Convert.ToString(item.Price); pqEntity.PQDiscount = item.PODiscount; // PODEntity.GSTRate = item.GSTRate; pqEntity.PQAmount = item.POAmount; PODetailsEntity.Add(pqEntity); } }
public int ManageDuplicatePandS() { int rowFocusindex = -1; lst = new ObservableCollection <DataGridViewModel>(); lst = PODetailsEntity; var query = lst.GroupBy(x => x.SelectedPSID) .Where(g => g.Count() > 1) .ToList(); if (query.Count > 0 && PODetailsEntity.Count > 1) { var obj1 = query[0].ElementAt(0); var obj2 = query[0].ElementAt(1); int? qty = 1; decimal?productPrice2 = 0; decimal?discountP2 = 0; qty = query[0].ElementAt(0).PQQty + query[0].ElementAt(1).PQQty; productPrice2 = Convert.ToDecimal(query[0].ElementAt(1).PQPrice); discountP2 = query[0].ElementAt(1).PQDiscount; var index1 = lst.IndexOf(query[0].ElementAt(0)); var index2 = lst.IndexOf(query[0].ElementAt(1)); if (productPrice2 != null) { obj1.PQQty = qty; obj1.PQPrice = Convert.ToString(productPrice2); obj1.PQDiscount = discountP2; PODetailsEntity[index1] = obj1; var row = new DataGridViewModel(ProductList); //row.PQQty = 1; //row.GSTRate = TaxRate; //row.GSTRateStr = Convert.ToString(TaxRate) + "%"; PODetailsEntity[index2] = row; rowFocusindex = index2; } //for (int i = 0; i < 2; i++) //{ // var p = PODetailsEntity.Where(e => e.SelectedPSID == obj2.SelectedPSID ).FirstOrDefault(); // if (p.POPrice == null) // { // PODetailsEntity.Remove(p); // } //} OnPropertyChanged("PODetailsEntity"); } else { int count = PODetailsEntity.Count(x => x.SelectedPSID == null); if (count == 0) { var row = new DataGridViewModel(ProductList); //row.PQQty = 1; //row.GSTRate = TaxRate; //row.GSTRateStr = Convert.ToString(TaxRate) + "%"; PODetailsEntity.Add(row); OnPropertyChanged("PODetailsEntity"); rowFocusindex = -1; } else { var emptyRow = lst.Where(y => y.SelectedPSID == null).FirstOrDefault(); rowFocusindex = PODetailsEntity.IndexOf(emptyRow); } } return(rowFocusindex); }
public void GetDebitNote(object param) { OptionsEntity oData = new OptionsEntity(); ISalesOrderListRepository purchaseRepository = new SalesOrderListRepository(); oData = purchaseRepository.GetOptionSettings(); if (param != null) { DebitNoteForm pqf = dnRepository.GetDebitNoteDetails(Convert.ToString(param)); this.ID = pqf.DebitNote.ID; this.DebitNo = pqf.DebitNote.DebitNo; this.DebitDate = pqf.DebitNote.DebitDate; this.SupplierCreditNoteNo = pqf.DebitNote.SupplierCreditNoteNo; if (SupplierCreditNoteDate == null) { this.SupplierCreditNoteDate = pqf.DebitNote.SupplierCreditNoteDate; } else { DateTime DateinStr = (DateTime)pqf.DebitNote.SupplierCreditNoteDate; this.SupplierCreditNoteDateStr = DateinStr.ToString(oData.DateFormat); } this.SupplierCreditNoteAmount = pqf.DebitNote.SupplierCreditNoteAmount; this.SelectedSupplierID = pqf.DebitNote.SupplierID; this.PurchaseInvoiceID = pqf.DebitNote.PurchaseInvoiceID; this.PurchaseInvoiceNo = pqf.DebitNote.PurchaseInvoiceNo; this.TermsAndConditions = pqf.DebitNote.TermsAndConditions; this.TotalBeforeTax = Convert.ToDecimal(pqf.DebitNote.TotalBeforeTax); this.TotalTax = Convert.ToDecimal(pqf.DebitNote.TotalTax); this.TotalAfterTax = Convert.ToDecimal(pqf.DebitNote.TotalAfterTax); this.TotalBeforeTaxStr = Convert.ToString(this.TotalBeforeTax); this.TotalTaxStr = Convert.ToString(TotalTax); this.TotalAfterTaxStr = Convert.ToString(TotalAfterTax); this.Status = pqf.DebitNote.Status; if (this.Status == 1) { RubberStampDN = true; } else { RubberStampDN = false; } this.PQDetailsEntity = new ObservableCollection <DataGridViewModel>(); foreach (var item in pqf.InvoiceDetails) { DataGridViewModel pqEntity = new DataGridViewModel(ProductList); pqEntity.SelectedPSID = Convert.ToString(item.PINo); pqEntity.PandSCode = item.PandSCode; pqEntity.PandSName = item.PandSName; pqEntity.GSTRate = Math.Round(Convert.ToDecimal(item.GSTRate), DecimalPlaces); pqEntity.GSTRateStr = Convert.ToString(pqEntity.GSTRate) + "%"; pqEntity.PQQty = item.PIQty; pqEntity.PQPrice = Convert.ToString(item.Price); pqEntity.PQDiscount = item.PIDiscount; // PQDEntity.GSTRate = item.GSTRate; pqEntity.PQAmount = item.PIAmount; PQDetailsEntity.Add(pqEntity); } } }
public void GetPurchaseQuotation(string pqNo) { // Mouse.OverrideCursor = Cursors.Wait; PurchaseQuotationForm pqf = pqRepository.GetPurchaseQuotation(pqNo); this.ID = pqf.Quotation.ID; this.QuotationNo = pqf.Quotation.QuotationNo; this.QuotationDate = pqf.Quotation.QuotationDate; this.ValidForDays = pqf.Quotation.ValidForDays; this.SelectedSupplierID = pqf.Quotation.SupplierID; //if (this.SelectedSupplierID > 0) //{ // GetSupplierDetails(); //} this.TermsAndConditions = pqf.Quotation.TermsAndConditions; this.TotalBeforeTax = pqf.Quotation.TotalBeforeTax; this.TotalTax = pqf.Quotation.TotalTax; this.TotalAfterTax = pqf.Quotation.TotalAfterTax; this.TotalBeforeTaxStr = Convert.ToString(this.TotalBeforeTax); this.TotalTaxStr = Convert.ToString(TotalTax); this.TotalAfterTaxStr = Convert.ToString(TotalAfterTax); if (pqf.Quotation.ExcIncGST == true) { ExcludingTax = false; IncludingTax = true; // PQDEntity.GSTRate = 0; } else { ExcludingTax = true; IncludingTax = false; // PQDEntity.GSTRate = TaxRate; } this.PQ_Conv_to_PO = pqf.Quotation.PQ_Conv_to_PO; this.PQ_Conv_to_PI = pqf.Quotation.PQ_Conv_to_PI; if (PQ_Conv_to_PO == true || PQ_Conv_to_PI == true) { AllFieldsReadonly = true; AllFieldsEnabled = false; } else { AllFieldsReadonly = false; AllFieldsEnabled = true; LstSuppliers = supplierRepository.GetAllSupplier().Where(s => s.IsInActive != "Y").ToList(); ProductAndServices = ProductAndServices.OrderBy(x => x.PSName).Where(x => x.IsInActive != "Y").ToObservable(); } SupplierEnabled = false; this.PQDetailsEntity = new ObservableCollection <DataGridViewModel>(); foreach (var item in pqf.QuotationDetails) { DataGridViewModel pqEntity = new DataGridViewModel(ProductList); pqEntity.SelectedPSID = Convert.ToString(item.PQNo); pqEntity.PandSCode = item.PandSCode; pqEntity.PandSName = item.PandSName; pqEntity.GSTRate = Math.Round(Convert.ToDecimal(item.GSTRate), DecimalPlaces); pqEntity.GSTRateStr = Convert.ToString(pqEntity.GSTRate) + "%"; pqEntity.PQQty = item.PQQty; pqEntity.PQPrice = Convert.ToString(item.Price); pqEntity.PQDiscount = item.PQDiscount; // PQDEntity.GSTRate = item.GSTRate; pqEntity.PQAmount = item.PQAmount; PQDetailsEntity.Add(pqEntity); } }