private void FillInvoiceForParty(string partyNo) { _objInvoice = new DAL_Invoices(); var result = _objInvoice.GetInvoiceByPartyNo(new Models.Invoice_RQ() { PartyNo = partyNo }); dgInvoiceList.DataSource = result; this.dgInvoiceList.Columns["InvoiceId"].Visible = false; if (dgInvoiceList.Columns.Count == 6) { AddCoulumn(dgInvoiceList); } }
public DisplayInvoice() { InitializeComponent(); // Loading Invoice List by calling the generic list class List <Invoices> invoiceList = new List <Invoices>(); invoiceList = DAL_Invoices.LoadInvoices(); invoiceListView.DataContext = invoiceList; Detail.Content = invoiceList; if (invoiceList.Count == 0) { this.emptyText.Visibility = Visibility.Visible; } }
private void BindOrderDetails(string invoiceno) { try { DAL_Invoices _objInvoice = new DAL_Invoices(); var invoice = _objInvoice.GetInvoiceByNo(new Invoice_RQ() { InvoiceNo = invoiceno }); if (invoice != null) { btnPrint.Enabled = true; int seq = 1; dtorder.Rows.Clear(); foreach (var item in invoice._objOrderItem) { DataRow dr = dtorder.NewRow(); dr["invoiceOrderItemId"] = item.InvoiceItemID; dr["ArtId"] = item.ArtNo; dr["ArtNo"] = item.ArtNo; dr["Desc"] = item.ArtDesc; // dr["WorkOrderDesc"] = item.WorkOrderDesc; dr["RefillsLink"] = item.RefileInk; dr["Rate"] = item.Rate; dr["Qty"] = item.Quantity; dr["Amount"] = item.Amount; dr["Sequence"] = seq++; dtorder.Rows.Add(dr); } FillOrderItemGrid(); cmbPartyName.SelectedValue = invoice.PartyNo; SetPartyMasterAddress(invoice.PartyNo); //Fill Order Details FillBankDetails(); cmbboxBanks.SelectedValue = Convert.ToInt32(invoice.BankId); InvoiceDate.Text = Convert.ToString(invoice.InvoiceDate); cmbBoxCurrency.SelectedIndex = cmbBoxCurrency.FindString(invoice.InvoiceCurrency); cmbBoxUnit.SelectedIndex = cmbBoxUnit.FindString(invoice.Unit); lblGrandAmout.Text = Convert.ToString(invoice.InvoiceGrandAmt); lblGrandQty.Text = Convert.ToString(invoice.InvoiceGrandQty); //Delivery Term if (invoice.DeliveryTerms != null) { if (invoice.DeliveryTerms == "CIF") { rdbtnCIF.Checked = true; } if (invoice.DeliveryTerms == "CNF") { rdbtnCNF.Checked = true; } if (invoice.DeliveryTerms == "FOB") { rdbtnFOB.Checked = true; } } if (!string.IsNullOrWhiteSpace(invoice.DeliveryType)) { cmbDeliveryBy.SelectedValue = Convert.ToString(invoice.DeliveryType); } txtPort.Text = invoice.Port; if (!string.IsNullOrWhiteSpace(invoice.PartialShip)) { cmbPartialShip.SelectedValue = Convert.ToString(invoice.PartialShip); } if (!string.IsNullOrWhiteSpace(invoice.TransShipment)) { cmbTransShipment.SelectedValue = Convert.ToString(invoice.TransShipment); } txtRemark.Text = invoice.Remark; txtPaymentTerms.Text = invoice.PaymentTerms; txtDeliveryPeriod.Text = invoice.DeliveryPeriod; btnCreate.Text = "Update"; } } catch (Exception ex) { throw ex; } }
private void CreateInvoiceObject(string invoiceNo) { try { Thread.CurrentThread.CurrentCulture = new CultureInfo("en-IN"); Models.Invoice _invoice = new Models.Invoice(); _invoice.BankId = Convert.ToString(cmbboxBanks.SelectedValue); _invoice.InvoiceCurrency = string.Format(cmbBoxCurrency.Text, CultureInfo.InvariantCulture); _invoice.IsActive = true; _invoice.CreatedBy = "System"; _invoice.CreatedOn = DateTime.Today; _invoice.InvoiceDate = DateTime.ParseExact(InvoiceDate.Text, "dd-MM-yyyy", CultureInfo.InvariantCulture); _invoice.InvoiceGrandAmt = Convert.ToDecimal(lblGrandAmout.Text); _invoice.InvoiceGrandQty = Convert.ToDecimal(lblGrandQty.Text); _invoice.PartyNo = (string)cmbPartyName.SelectedValue; _invoice.Unit = cmbBoxUnit.Text; _invoice.DeliveryTerms = lblDeliveryTermsValue.Text; _invoice.PaymentTerms = txtPaymentTerms.Text; _invoice.DeliveryPeriod = txtDeliveryPeriod.Text; _invoice.DeliveryType = Convert.ToString(cmbDeliveryBy.SelectedValue); _invoice.Port = txtPort.Text; _invoice.PartialShip = Convert.ToString(cmbPartialShip.SelectedValue); _invoice.TransShipment = Convert.ToString(cmbTransShipment.SelectedValue); _invoice.Remark = txtRemark.Text; if (dtorder.Rows.Count > 0) { foreach (DataRow dr in dtorder.Rows) { if (Convert.ToInt32(dr["Sequence"]) == 0) { continue; } _invoice._objOrderItem.Add(new InvoiceItemDetails() { Amount = Convert.ToDecimal(dr["Amount"]), ArtDesc = Convert.ToString(dr["Desc"]), //WorkOrderDesc = Convert.ToString(dr["WorkOrderDesc"]), Quantity = Convert.ToInt32(dr["Qty"]), ArtNo = Convert.ToString(dr["ArtNo"]), Rate = Convert.ToDecimal(dr["Rate"]), RefileInk = Convert.ToString(dr["RefillsLink"]), }); } _objInvoice = new DAL_Invoices(); if (string.IsNullOrWhiteSpace(invoiceNo)) { _invoice.InvoiceNo = invoiceNo; var resultCreate = _objInvoice.CreateInvoice(_invoice); if (resultCreate != null && !string.IsNullOrWhiteSpace(resultCreate.MessageText)) { MessageBox.Show(resultCreate.MessageText, "Successful", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1); txtBoxInvoiceNo.Text = resultCreate.InvoiceNo; btnPrint.Enabled = true; // ClearControl(); } else { // lblStatus.Visible = false; } } else { _invoice.InvoiceNo = invoiceNo; var resultUpdate = _objInvoice.UpdateInvoice(_invoice); if (resultUpdate != null && !string.IsNullOrWhiteSpace(resultUpdate.MessageText)) { MessageBox.Show(resultUpdate.MessageText, "Successful", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1); txtBoxInvoiceNo.Text = resultUpdate.InvoiceNo; btnPrint.Enabled = true; // ClearControl(); } else { // lblStatus.Visible = false; } } } else { //MessageBox.Show(item.Info); } } catch (Exception) { throw; } }