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;
}
}
