private void Cmb_SelectedIndexChanged(object sender, EventArgs e)
{
ComboBox cmb = (ComboBox)sender;
if (cmb.Text == "Receive Payment")
{
string billNo = dgvBills.CurrentRow.Cells["InvoiceNo"].Value.ToString();
string customer = dgvBills.CurrentRow.Cells["Buyer"].Value.ToString();
ReceiptVoucher frmReceiptVoucher = new ReceiptVoucher(billNo, customer);
frmReceiptVoucher.OnClose += GenerateBillingList;
frmReceiptVoucher.ShowDialog();
}
else if (cmb.Text == "Original for Recipient")
{
string billNo = dgvBills.CurrentRow.Cells["InvoiceNo"].Value.ToString();
string suppliers = dgvBills.CurrentRow.Cells["Buyer"].Value.ToString();
InvoiceReportViewer frmInvoiceReportViewer = new InvoiceReportViewer(InvoiceReportViewer._InvoiceCopy.Original, billNo);
frmInvoiceReportViewer.OnClose += GenerateBillingList;
frmInvoiceReportViewer.ShowDialog();
}
else if (cmb.Text == "Duplicate for Transporter")
{
string billNo = dgvBills.CurrentRow.Cells["InvoiceNo"].Value.ToString();
string suppliers = dgvBills.CurrentRow.Cells["Buyer"].Value.ToString();
InvoiceReportViewer frmInvoiceReportViewer = new InvoiceReportViewer(InvoiceReportViewer._InvoiceCopy.Duplicate, billNo);
frmInvoiceReportViewer.OnClose += GenerateBillingList;
frmInvoiceReportViewer.ShowDialog();
}
else if (cmb.Text == "Triplicate for Supplier")
{
string billNo = dgvBills.CurrentRow.Cells["InvoiceNo"].Value.ToString();
string suppliers = dgvBills.CurrentRow.Cells["Buyer"].Value.ToString();
InvoiceReportViewer frmInvoiceReportViewer = new InvoiceReportViewer(InvoiceReportViewer._InvoiceCopy.Triplicate, billNo);
frmInvoiceReportViewer.OnClose += GenerateBillingList;
frmInvoiceReportViewer.ShowDialog();
}
else if (cmb.Text == "Credit Note")
{
string invoiceNo = dgvBills.CurrentRow.Cells["InvoiceNo"].Value.ToString();
CreditNoteIssue creditnoteissu = new CreditNoteIssue(CreditNoteIssue._NoteType.Credit_Note, invoiceNo);
creditnoteissu.OnClose += GenerateBillingList;
creditnoteissu.ShowDialog();
}
else if (cmb.Text == "Cancel")
{
if (UserTools._IsCancel)
{
string invoiceno = dgvBills.CurrentRow.Cells["invoiceno"].Value.ToString();
string status = dgvBills.CurrentRow.Cells["STATUS"].Value.ToString();
Invoice_Direct invoicedirect = new Invoice_Direct(invoiceno, status, "");
invoicedirect.InvoiceCancel();
GenerateBillingList();
}
else
{
MessageBox.Show("Cancel permission denied by Admin", "Permission", MessageBoxButtons.OK, MessageBoxIcon.Stop);
GenerateBillingList();
}
}
}
/// <summary>
/// Data Save
/// </summary>
private void SaveInvoice()
{
mlistQuery.Clear();
#region data
string receivableheadid = AccountHeadTools._ReceivableAccountHeadId;
string salesheadid = AccountHeadTools._SalesLedgerId;
string invoiceNo = lblInvoiceNo.Text.GetDBFormatString();
string invoiceDate = dtpInvoiceDate.Text;
string billingTerms = cmbBillingTerms.Text;
string dueDate = dtpDueDate.Text;
string billingTo = lblNameBilling.Text;
string billingAddress = lblBillingAddress.Text;
string billingGSTIN = lblGSTIn.Text;
string billingState = lblStateNameBilling.Text;
string billingStateCode = lblStateCodeBilling.Text;
string buyerOrderNo = lblBuyrOrderNo.Text;
string buyerOrderDate = lblBuyrOrderDate.Text;
string challanNo = lblChallanNo.Text;
string challanDate = lblChallanDate.Text;
string despatchThrough = lblDespatchThrough.Text;
string vehiclaNo = lblVehiclaNo.Text;
string shippingTo = lblShippedTo.Text;
string shippingAddress = lblShippedAddress.Text;
string shippingState = lblStateNameShipping.Text;
string shippingStateCode = lblStateCodeShipping.Text;
string totalQty = lblTotQuantity.Text;
string totalAmount = lblTotAmount.Text;
string totalDiscount = lblTotalDiscount.Text;
string totalTaxAmount = lblTaxableAmountTotal.Text;
string totalCGST = lblTotalCGST.Text;
string totalSGST = lblTotalSGST.Text;
string totalIGST = lblTotalIGST.Text;
string totalCess = lblTotalCESS.Text;
string totalNet = lblTotalWithTax.Text;
double totalInvoiceAmount = 0d, freightCharges = 0d, pachingCharges = 0d, otherCharges = 0d, overAllDiscount = 0d;
double.TryParse(lblTotalInvoiceAmount.Text, out totalInvoiceAmount);
double.TryParse(txtFreightCharges.Text, out freightCharges);
double.TryParse(txtPackingCharges.Text, out pachingCharges);
double.TryParse(txtOtherCharges.Text, out otherCharges);
double.TryParse(txtDiscount.Text, out overAllDiscount);
string note = "";
string rcm = (ORG_Tools._GSTtype == "Regular") ? "NO" : "YES";
#endregion
string query = "Insert into invoice( SlNo, InvoiceNo, InvoiceDate, LedgerId, BillingTerms, DueDate, " +
"BillingTo, BillingAddress, BillingGSTNO, BillingState, BillingStateCode, BuyerOrderNo, " +
"BuyerOrderDate, ChallanNo, ChallanDate, DispatchThrough, VehiclaNo, ShippingTo, " +
"ShippingAddress, ShippingState, ShippingStateCode, TotalQty, TotalAmount, TotalDiscount, " +
"TotalTaxAmount, TotalCGST, TotalSGST, TotalIGST, TotalCess, NetAmount, FreightChargs, " +
"PackingCharges, OtherCharges, OverAllDiscount, TotalInvoiceAmount,Note,RCM,InvoiceType) " +
"values(" + mInvoiceSlNo + ",'" + invoiceNo + "','" + invoiceDate + "','" +
mCustomerLadgerID + "','" + billingTerms + "','" + dueDate + "','" + billingTo + "','" +
billingAddress + "','" + billingGSTIN + "','" + billingState + "','" + billingStateCode
+ "','" + buyerOrderNo + "','" + buyerOrderDate + "','" + challanNo + "','" + challanDate
+ "','" + despatchThrough + "','" + vehiclaNo + "','" + shippingTo + "','" + shippingAddress
+ "','" + shippingState + "','" + shippingStateCode + "'," + totalQty + "," + totalAmount
+ "," + totalDiscount + "," + totalTaxAmount + "," + totalCGST + "," + totalSGST + "," + totalIGST + "," +
totalCess + "," + totalNet + "," + freightCharges + "," + pachingCharges + "," + otherCharges + "," +
overAllDiscount + "," + totalInvoiceAmount + ",'" + note + "','" + rcm + "','" + mInvoiceType + "')";
mlistQuery.Add(query);
string transectionid = Guid.NewGuid().ToString();
query = "Insert into Transection(TransectionID,LedgerID,AccountHeadIdTo,Date,TransectionType,Amount, " +
"DueDate,VoucherNo,Balance,Status) values('" + transectionid + "','" + mCustomerLadgerID + "','" + receivableheadid + "','" + invoiceDate + "','Invoice'," + mTotalInvoiceAmount + ",'" + dueDate + "','" + invoiceNo + "'," + mTotalAmount + ",'Open')";
mlistQuery.Add(query);
SaveInvoiceDetails(invoiceNo, transectionid);
switch (mInvoiceFrom)
{
case _Invoicefrom.Order:
break;
case _Invoicefrom.Challan:
UpdateChallan();
break;
default:
break;
}
if (SQLHelper.GetInstance().ExecuteTransection(mlistQuery, out msg))
{
if (MessageBox.Show("Invoice saved.\nDo you want to print now ?", "Invoice", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
InvoiceReportViewer frmInvoiceReportViewer = new InvoiceReportViewer(InvoiceReportViewer._InvoiceCopy.Original, lblInvoiceNo.Text);
frmInvoiceReportViewer.OnClose += FrmInvoiceReportViewer_OnClose;
frmInvoiceReportViewer.ShowDialog();
}
}
else
{
MessageBox.Show(msg);
}
}