每个财政年度，发票号码应以1开头 [英] Invoice no should be started with 1 for every finacial year
本文介绍了每个财政年度，发票号码应以1开头的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我有一张有发票的访问表，没有主键和自动递增的值（在代码中我只写了cloumn和Inctrement +1）我希望每个金融年都应该开始发票（来自4月1日至3月31日是金融年份）
字段名称数据类型：
INVOICENO数字
状态文本
CUSTOMERNAME文字
ADDRESS1文字
ADDRESS2文字
TINNO文字
PONO文字
运输文字
BILLDATE DTAe /时间
InvoiceType文字
PODATE日期/时间
totalGrossAmt text
totalVatAmt文件
BILLAMT文本
TRANSPORTAMT文本
OTHERAMT textr
FINALAMT文本
ROUNDOFF文字
GRANDTOTAL文字
状态文字
税务文本
我尝试过：
i have one access table having invoice no it has a primary key and auto incremented value(Taking Max no in cloumn and Inctrement +1 in code only i am write) i want invoice no should be started for every finacial year (from april 1st to march 31 is finacial year )
Field Name Datatype:
INVOICENO Number
STATE Text
CUSTOMERNAME Text
ADDRESS1 TEXT
ADDRESS2 text
TINNO Text
PONO Text
TRANSPORT text
BILLDATE Dtae/Time
InvoiceType Text
PODATE date/time
totalGrossAmt text
totalVatAmt Text
BILLAMT Text
TRANSPORTAMT text
OTHERAMT textr
FINALAMT Text
ROUNDOFF text
GRANDTOTAL Text
STATUS Text
TAX Text
What I have tried:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
using System.Configuration;
using System.Globalization;
using System.Collections;
using System.Threading;
namespace Victory_Printing
{
public partial class TAXINVOICE : Form
{
public TAXINVOICE()
{
InitializeComponent();
ddlTransaction.SelectedIndex = 1;
FillInvoiceID();
this.ActiveControl = txtCustName;
}
int Ocredit;
int invoice = 1;
int rupees;
string text;
public static string numb;
DataTable Products = new DataTable();
DataTable productdt = new DataTable();
public static int productnum;
AutoCompleteStringCollection namesCollection = new AutoCompleteStringCollection();
AutoCompleteStringCollection descriptionCollection = new AutoCompleteStringCollection();
private void btnSave_Click(object sender, EventArgs e)
{
//PopupForm popup = new PopupForm();
// DialogResult dialogresult = popup.ShowDialog();
// if (dialogresult == DialogResult.OK)
// {
// Console.WriteLine("You clicked OK");
// }
// else if (dialogresult == DialogResult.Cancel)
// {
// Console.WriteLine("You clicked either Cancel or X button in the top right corner");
// }
// popup.Dispose();
//DataTable dt = new DataTable();
DataTable dtb = new DataTable();
DataRow dr0 = dtb.NewRow();
DataRow dr1 = dtb.NewRow();
DataRow dr2 = dtb.NewRow();
DataRow dr3 = dtb.NewRow();
DataRow dr4 = dtb.NewRow();
DataRow dr5 = dtb.NewRow();
DataRow dr6 = dtb.NewRow();
DataRow dr7 = dtb.NewRow();
DataRow dr8 = dtb.NewRow();
DataRow dr9 = dtb.NewRow();
DataRow dr10 = dtb.NewRow();
DataRow dr11 = dtb.NewRow();
DataRow dr12 = dtb.NewRow();
DataRow dr13 = dtb.NewRow();
DataRow dr14 = dtb.NewRow();
DataRow dr15 = dtb.NewRow();
DataRow dr16 = dtb.NewRow();
DataRow dr17 = dtb.NewRow();
DataRow dr18 = dtb.NewRow();
// DataRow dr16 = dt.NewRow();
/* Row 1 */
dtb.Columns.Add("SNo");
dtb.Columns.Add("DESCRIPTION");
dtb.Columns.Add("QTY");
dtb.Columns.Add("UOM");
dtb.Columns.Add("PRICE");
dtb.Columns.Add("GROSS AMT");
dtb.Columns.Add("VAT%");
dtb.Columns.Add("VAT AMT");
dtb.Columns.Add("TOTAL");
dr0[0] = txtSno1.Text;
dr0[1] = txtDescription1.Text;
dr0[2] = txtqty1.Text;
dr0[3] = cbUOM1.SelectedItem;
dr0[4] = txtPrice1.Text;
dr0[5] = txtGrossAmt1.Text;
dr0[6] = txtVAT1.Text;
dr0[7] = txtVatAmt1.Text;
dr0[8] = txtTotal1.Text;
dr1[0] = txtSno2.Text;
dr1[1] = txtDescription2.Text;
dr1[2] = txtqty2.Text;
dr1[3] = cbUOM2.SelectedItem;
dr1[4] = txtPrice2.Text;
dr1[5] = txtGrossAmt2.Text;
dr1[6] = txtVAT2.Text;
dr1[7] = txtVatAmt2.Text;
dr1[8] = txtTotal2.Text;
dr2[0] = txtSno3.Text;
dr2[1] = txtDescription3.Text;
dr2[2] = txtqty3.Text;
dr2[3] = cbUOM3.SelectedItem;
dr2[4] = txtPrice3.Text;
dr2[5] = txtGrossAmt3.Text;
dr2[6] = txtVAT3.Text;
dr2[7] = txtVatAmt3.Text;
dr2[8] = txtTotal3.Text;
dr3[0] = txtSno4.Text;
dr3[1] = txtDescription4.Text;
dr3[2] = txtqty4.Text;
dr3[3] = cbUOM4.SelectedItem;
dr3[4] = txtPrice4.Text;
dr3[5] = txtGrossAmt4.Text;
dr3[6] = txtVAT4.Text;
dr3[7] = txtVatAmt4.Text;
dr3[8] = txtTotal4.Text;
dr4[0] = txtSno5.Text;
dr4[1] = txtDescription5.Text;
dr4[2] = txtqty5.Text;
dr4[3] = cbUOM5.SelectedItem;
dr4[4] = txtPrice5.Text;
dr4[5] = txtGrossAmt5.Text;
dr4[6] = txtVAT5.Text;
dr4[7] = txtVatAmt5.Text;
dr4[8] = txtTotal5.Text;
dr5[0] = txtSno6.Text;
dr5[1] = txtDescription6.Text;
dr5[2] = txtqty6.Text;
dr5[3] = cbUOM6.SelectedItem;
dr5[4] = txtPrice6.Text;
dr5[5] = txtGrossAmt6.Text;
dr5[6] = txtVAT6.Text;
dr5[7] = txtVatAmt6.Text;
dr5[8] = txtTotal6.Text;
dr6[0] = txtSno7.Text;
dr6[1] = txtDescription7.Text;
dr6[2] = txtqty7.Text;
dr6[3] = cbUOM7.SelectedItem;
dr6[4] = txtPrice7.Text;
dr6[5] = txtGrossAmt7.Text;
dr6[6] = txtVAT7.Text;
dr6[7] = txtVatAmt7.Text;
dr6[8] = txtTotal7.Text;
dr7[0] = txtSno8.Text;
dr7[1] = txtDescription8.Text;
dr7[2] = txtqty8.Text;
dr7[3] = cbUOM8.SelectedItem;
dr7[4] = txtPrice8.Text;
dr7[5] = txtGrossAmt8.Text;
dr7[6] = txtVAT8.Text;
dr7[7] = txtVatAmt8.Text;
dr7[8] = txtTotal8.Text;
dr8[0] = txtSno9.Text;
dr8[1] = txtDescription9.Text;
dr8[2] = txtqty9.Text;
dr8[3] = cbUOM9.SelectedItem;
dr8[4] = txtPrice9.Text;
dr8[5] = txtGrossAmt9.Text;
dr8[6] = txtVAT9.Text;
dr8[7] = txtVatAmt9.Text;
dr8[8] = txtTotal9.Text;
dr9[0] = txtSno10.Text;
dr9[1] = txtDescription10.Text;
dr9[2] = txtqty10.Text;
dr9[3] = cbUOM10.SelectedItem;
dr9[4] = txtPrice10.Text;
dr9[5] = txtGrossAmt10.Text;
dr9[6] = txtVAT10.Text;
dr9[7] = txtVatAmt10.Text;
dr9[8] = txtTotal10.Text;
dr10[0] = txtSno11.Text;
dr10[1] = txtDescription11.Text;
dr10[2] = txtqty11.Text;
dr10[3] = cbUOM11.SelectedItem;
dr10[4] = txtPrice11.Text;
dr10[5] = txtGrossAmt11.Text;
dr10[6] = txtVAT11.Text;
dr10[7] = txtVatAmt11.Text;
dr10[8] = txtTotal11.Text;
dr11[0] = txtSno12.Text;
dr11[1] = txtDescription12.Text;
dr11[2] = txtqty12.Text;
dr11[3] = cbUOM12.SelectedItem;
dr11[4] = txtPrice12.Text;
dr11[5] = txtGrossAmt12.Text;
dr11[6] = txtVAT12.Text;
dr11[7] = txtVatAmt12.Text;
dr11[8] = txtTotal12.Text;
dr12[0] = txtSno13.Text;
dr12[1] = txtDescription13.Text;
dr12[2] = txtqty13.Text;
dr12[3] = cbUOM13.SelectedItem;
dr12[4] = txtPrice13.Text;
dr12[5] = txtGrossAmt13.Text;
dr12[6] = txtVAT13.Text;
dr12[7] = txtVatAmt13.Text;
dr12[8] = txtTotal13.Text;
dr13[0] = txtSno14.Text;
dr13[1] = txtDescription14.Text;
dr13[2] = txtqty14.Text;
dr13[3] = cbUOM14.SelectedItem;
dr13[4] = txtPrice14.Text;
dr13[5] = txtGrossAmt14.Text;
dr13[6] = txtVAT14.Text;
dr13[7] = txtVatAmt14.Text;
dr13[8] = txtTotal14.Text;
dr14[0] = txtSno15.Text;
dr14[1] = txtDescription15.Text;
dr14[2] = txtqty15.Text;
dr14[3] = cbUOM15.SelectedItem;
dr14[4] = txtPrice15.Text;
dr14[5] = txtGrossAmt15.Text;
dr14[6] = txtVAT15.Text;
dr14[7] = txtVatAmt15.Text;
dr14[8] = txtTotal15.Text;
dr15[0] = txtSno16.Text;
dr15[1] = txtDescription16.Text;
dr15[2] = txtqty16.Text;
dr15[3] = cbUOM16.SelectedItem;
dr15[4] = txtPrice16.Text;
dr15[5] = txtGrossAmt16.Text;
dr15[6] = txtVAT16.Text;
dr15[7] = txtVatAmt16.Text;
dr15[8] = txtTotal16.Text;
dr16[0] = txtSno17.Text;
dr16[1] = txtDescription17.Text;
dr16[2] = txtqty17.Text;
dr16[3] = cbUOM17.SelectedItem;
dr16[4] = txtPrice17.Text;
dr16[5] = txtGrossAmt17.Text;
dr16[6] = txtVAT17.Text;
dr16[7] = txtVatAmt17.Text;
dr16[8] = txtTotal17.Text;
dr17[0] = txtSno18.Text;
dr17[1] = txtDescription18.Text;
dr17[2] = txtqty18.Text;
dr17[3] = cbUOM18.SelectedItem;
dr17[4] = txtPrice18.Text;
dr17[5] = txtGrossAmt18.Text;
dr17[6] = txtVAT18.Text;
dr17[7] = txtVatAmt18.Text;
dr17[8] = txtTotal18.Text;
dr18[0] = txtSno19.Text;
dr18[1] = txtDescription19.Text;
dr18[2] = txtqty19.Text;
dr18[3] = cbUOM19.SelectedItem;
dr18[4] = txtPrice19.Text;
dr18[5] = txtGrossAmt19.Text;
dr18[6] = txtVAT19.Text;
dr18[7] = txtVatAmt19.Text;
dr18[8] = txtTotal19.Text;
if (cbUOM1.SelectedValue != "Select")
{
dtb.Rows.Add(dr0);
}
if (cbUOM2.SelectedValue != "Select")
{
dtb.Rows.Add(dr1);
}
if (cbUOM3.SelectedValue != "Select")
{
dtb.Rows.Add(dr2);
}
if (cbUOM4.SelectedValue != "Select")
{
dtb.Rows.Add(dr3);
}
if (cbUOM5.SelectedValue != "Select")
{
dtb.Rows.Add(dr4);
}
if (cbUOM6.SelectedValue != "Select")
{
dtb.Rows.Add(dr5);
}
if (cbUOM7.SelectedValue != "Select")
{
dtb.Rows.Add(dr6);
}
if (cbUOM8.SelectedValue != "Select")
{
dtb.Rows.Add(dr7);
}
if (cbUOM9.SelectedValue != "Select")
{
dtb.Rows.Add(dr8);
}
if (cbUOM10.SelectedValue != "Select")
{
dtb.Rows.Add(dr9);
}
if (cbUOM11.SelectedValue != "Select")
{
dtb.Rows.Add(dr10);
}
if (cbUOM12.SelectedValue != "Select")
{
dtb.Rows.Add(dr11);
}
if (cbUOM13.SelectedValue != "Select")
{
dtb.Rows.Add(dr12);
}
if (cbUOM14.SelectedValue != "Select")
{
dtb.Rows.Add(dr13);
}
if (cbUOM15.SelectedValue != "Select")
{
dtb.Rows.Add(dr14);
}
if (cbUOM16.SelectedValue != "Select")
{
dtb.Rows.Add(dr15);
}
if (cbUOM17.SelectedValue != "Select")
{
dtb.Rows.Add(dr16);
}
if (cbUOM18.SelectedValue != "Select")
{
dtb.Rows.Add(dr17);
}
if (cbUOM19.SelectedValue != "Select")
{
dtb.Rows.Add(dr18);
}
//if (printDlg.ShowDialog() == DialogResult.OK)
// printDoc.Print();
decimal a = 0, b = String.IsNullOrEmpty(txtFinalAmt.Text) ? 0 : decimal.Parse(txtFinalAmt.Text.Trim());
rupees = Convert.ToInt32(b);
DialogResult dialogResult = MessageBox.Show("Are You Sure??", "Do you want to save?", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
//do something
int num = Convert.ToInt32(txtInvoice.Text);
string counterSales_InsertRow = "INSERT INTO TAXINVOICE(INVOICENO,STATE ,CUSTOMERNAME ,ADDRESS1,ADDRESS2,TINNO,PONO,TRANSPORT,InvoiceType,BILLDATE,PODATE,totalGrossAmt,totalVatAmt,BILLAMT,TRANSPORTAMT,OTHERAMT,FINALAMT,ROUNDOFF,GRANDTOTAL,TAX,CurrentYear,CreatedOn)VALUES (@INVOICENO,@STATE,@CUSTOMERNAME,@ADDRESS1,@ADDRESS2,@TINNO,@PONO,@TRANSPORT,@InvoiceType,@BILLDATE,@PODATE,@totalGrossAmt,@totalVatAmt,@BILLAMT,@TRANSPORTAMT,@OTHERAMT,@FINALAMT,@ROUNDOFF,@GRANDTOTAL,@TAX,@CurrentYear,@CreatedOn);";
OleDbParameter[] parameters = new OleDbParameter[22];
parameters[0] = new OleDbParameter("@INVOICENO", num);
//parameters[0] = new OleDbParameter("@INVOICENO", OleDbType.Integer).Value = num;
parameters[1] = new OleDbParameter("@STATE", comboBox1.Text);
parameters[2] = new OleDbParameter("@CUSTOMERNAME", txtCustName.Text.ToUpper());
parameters[3] = new OleDbParameter("@ADDRESS1", txtAddress1.Text);
parameters[4] = new OleDbParameter("@ADDRESS2", txtAddress2.Text);
parameters[5] = new OleDbParameter("@TINNO", txtTINnum.Text);
parameters[6] = new OleDbParameter("@PONO", txtPOnum.Text);
parameters[7] = new OleDbParameter("@TRANSPORT", tbTransportValue.Text.ToUpper());
parameters[8] = new OleDbParameter("@InvoiceType", ddlTransaction.SelectedItem);
parameters[9] = new OleDbParameter("@BILLDATE", Convert.ToDateTime(dtToday.Text));
parameters[10] = new OleDbParameter("@PODATE", CreatedDate.Text);
parameters[11] = new OleDbParameter("@totalGrossAmt", txtTotalGrossAmt.Text);
parameters[12] = new OleDbParameter("@totalVatAmt", txtTotalVATAMT.Text);
parameters[13] = new OleDbParameter("@BILLAMT", txtTotals.Text);
parameters[14] = new OleDbParameter("@TRANSPORTAMT", txtTransport.Text);
parameters[15] = new OleDbParameter("@OTHERAMT", txtOthers.Text);
parameters[16] = new OleDbParameter("@FINALAMT", txtTotals.Text);
parameters[17] = new OleDbParameter("@ROUNDOFF", txtRoundOff.Text);
parameters[18] = new OleDbParameter("@GRANDTOTAL", txtGrandTotal.Text);
parameters[19] = new OleDbParameter("@TAX", txtVAT1.Text);
parameters[20] = new OleDbParameter("@CurrentYear", DateTime.Now.Year);
parameters[21] = new OleDbParameter("@CreatedOn", Convert.ToDateTime(dtToday.Text));
ExecuteOtherGoodsDatabaseTransaction(counterSales_InsertRow, parameters);
InsertAllInvoiceItems();
// string Productscount = "select count()";
GlobalClass.dtHeaders = new DataTable();
Headers dsh = new Headers();
GlobalClass.dtHeaders = dsh.Tables[0];
//numb = ConvertNumbertoWords(number) + "Only";
//for (int i = 0; i < 5; i++)
numb = rupeestoword(rupees);
// rupees(rupees);
foreach (DataRow Datarow in dtb.Rows)
{
DataRow dr = GlobalClass.dtHeaders.NewRow();
dr["CustomerName"] = " " + txtCustName.Text.ToUpper();
dr["Address1"] = " " + txtAddress1.Text;
dr["Address2"] = " " + txtAddress2.Text;
dr["TIN"] = txtTINnum.Text.ToUpper();
dr["InvoiceNo"] = txtInvoice.Text.ToUpper();
dr["InvoiceDate"] = Convert.ToDateTime(dtToday.Text).ToString("dd/MM/yy");
dr["PONo"] = txtPOnum.Text.ToUpper();
dr["Dated"] = CreatedDate.Text;
dr["Transport"] = tbTransportValue.Text.Trim().ToUpper();
dr["SNO"] = Datarow.ItemArray[0];
dr["DESCRIPTION"] = Datarow.ItemArray[1].ToString().ToUpper();
dr["QTY"] = Datarow.ItemArray[2].ToString();
dr["UOM"] = Datarow.ItemArray[3].ToString();
dr["PRICE"] = Datarow.ItemArray[4].ToString();
dr["GROSSAMT"] = Datarow.ItemArray[5].ToString();
dr["VAT"] = Datarow.ItemArray[6].ToString();
dr["VATAMT"] = Datarow.ItemArray[7].ToString();
dr["TOTAL"] = Datarow.ItemArray[8].ToString();
dr["GROSSTOTAL"] = txtTotalGrossAmt.Text;
dr["VATTOTAL"] = txtTotalVATAMT.Text;
dr["TOTALAMT"] = txtTotals.Text;
dr["FINALAMOUNT"] = txtTotals.Text;
dr["AMTINWORDS"] = CultureInfo.CurrentCulture.TextInfo.ToTitleCase(numb.ToLower());
dr["TRANSPORT"] = txtTransport.Text.ToUpper();
dr["OTHERS"] = txtOthers.Text;
dr["ROUNDOFF"] = txtRoundOff.Text;
dr["GRANDTOTAL"] = txtGrandTotal.Text + ".00";
dr["INVOICETYPE"] = ddlTransaction.Text.ToUpper();
GlobalClass.dtHeaders.Rows.Add(dr);
}
Form4 frm = new Form4();
frm.Show();
this.Hide();
clear();
}
else if (dialogResult == DialogResult.No)
{
//this.Close();
}
}
public void clear()
{
// textBox1.Text = "";
txtAddress1.Text = "";
txtAddress2.Text = "";
txtCustName.Text = "";
txtPOnum.Text = "";
txtTINnum.Text = "";
txtTransport.Text = "0.00";
txtOthers.Text = "0.00";
txtFinalAmt.Text = "0.00";
txtGrandTotal.Text = "0.00";
txtRoundOff.Text = "";
tbTransportValue.Text = "";
txtDescription1.Text = "";
txtDescription2.Text = "";
txtDescription3.Text = "";
txtDescription4.Text = "";
txtDescription5.Text = "";
txtDescription6.Text = "";
txtDescription7.Text = "";
txtDescription8.Text = "";
txtDescription9.Text = "";
txtDescription10.Text = "";
txtDescription11.Text = "";
txtDescription12.Text = "";
txtDescription13.Text = "";
txtDescription15.Text = "";
txtDescription14.Text = "";
txtDescription16.Text = "";
txtDescription18.Text = "";
txtDescription17.Text = "";
txtDescription19.Text = "";
txtqty1.Text = "";
txtqty2.Text = "";
txtqty3.Text = "";
txtqty4.Text = "";
txtqty5.Text = "";
txtqty6.Text = "";
txtqty7.Text = "";
txtqty8.Text = "";
txtqty9.Text = "";
txtqty10.Text = "";
txtqty11.Text = "";
txtqty12.Text = "";
txtqty13.Text = "";
txtqty14.Text = "";
txtqty15.Text = "";
txtqty16.Text = "";
txtqty17.Text = "";
txtqty18.Text = "";
txtqty19.Text = "";
txtPrice1.Text = "";
txtPrice2.Text = "";
txtPrice3.Text = "";
txtPrice4.Text = "";
txtPrice5.Text = "";
txtPrice6.Text = "";
txtPrice7.Text = "";
txtPrice8.Text = "";
txtPrice9.Text = "";
txtPrice10.Text = "";
txtPrice11.Text = "";
txtPrice12.Text = "";
txtPrice13.Text = "";
txtPrice14.Text = "";
txtPrice15.Text = "";
txtPrice16.Text = "";
txtPrice17.Text = "";
txtPrice18.Text = "";
txtPrice19.Text = "";
txtSno1.Text = "";
txtSno2.Text = "";
txtSno3.Text = "";
txtSno4.Text = "";
txtSno5.Text = "";
txtSno6.Text = "";
txtSno7.Text = "";
txtSno8.Text = "";
txtSno9.Text = "";
txtSno10.Text = "";
txtSno11.Text = "";
txtSno12.Text = "";
txtSno13.Text = "";
txtSno14.Text = "";
txtSno15.Text = "";
txtSno16.Text = "";
txtSno17.Text = "";
txtSno18.Text = "";
txtSno19.Text = "";
txtGrossAmt1.Text = "";
txtGrossAmt2.Text = "";
txtGrossAmt3.Text = "";
txtGrossAmt4.Text = "";
txtGrossAmt5.Text = "";
txtGrossAmt6.Text = "";
txtGrossAmt7.Text = "";
txtGrossAmt8.Text = "";
txtGrossAmt9.Text = "";
txtGrossAmt10.Text = "";
txtGrossAmt11.Text = "";
txtGrossAmt12.Text = "";
txtGrossAmt13.Text = "";
txtGrossAmt14.Text = "";
txtGrossAmt15.Text = "";
txtGrossAmt16.Text = "";
txtGrossAmt17.Text = "";
txtGrossAmt18.Text = "";
txtGrossAmt19.Text = "";
txtVatAmt1.Text = "";
txtVatAmt2.Text = "";
txtVatAmt3.Text = "";
txtVatAmt4.Text = "";
txtVatAmt5.Text = "";
txtVatAmt6.Text = "";
txtVatAmt7.Text = "";
txtVatAmt8.Text = "";
txtVatAmt9.Text = "";
txtVatAmt10.Text = "";
txtVatAmt11.Text = "";
txtVatAmt12.Text = "";
txtVatAmt13.Text = "";
txtVatAmt14.Text = "";
txtVatAmt15.Text = "";
txtVatAmt16.Text = "";
txtVatAmt17.Text = "";
txtVatAmt18.Text = "";
txtVatAmt19.Text = "";
txtTotal1.Text = "";
txtTotal2.Text = "";
txtTotal3.Text = "";
txtTotal4.Text = "";
txtTotal5.Text = "";
txtTotal6.Text = "";
txtTotal7.Text = "";
txtTotal8.Text = "";
txtTotal9.Text = "";
txtTotal10.Text = "";
txtTotal11.Text = "";
txtTotal12.Text = "";
txtTotal13.Text = "";
txtTotal14.Text = "";
txtTotal15.Text = "";
txtTotal16.Text = "";
txtTotal17.Text = "";
txtTotal18.Text = "";
txtTotal19.Text = "";
txtVAT1.Text = "";
txtVAT2.Text = "";
txtVAT3.Text = "";
txtVAT4.Text = "";
txtVAT5.Text = "";
txtVAT6.Text = "";
txtVAT7.Text = "";
txtVAT8.Text = "";
txtVAT9.Text = "";
txtVAT10.Text = "";
txtVAT11.Text = "";
txtVAT12.Text = "";
txtVAT13.Text = "";
txtVAT14.Text = "";
txtVAT15.Text = "";
txtVAT16.Text = "";
txtVAT17.Text = "";
txtVAT18.Text = "";
txtVAT19.Text = "";
cbUOM1.SelectedValue = "";
cbUOM2.SelectedValue = "";
cbUOM3.SelectedValue = "";
cbUOM4.SelectedValue = "";
cbUOM5.SelectedValue = "";
cbUOM6.SelectedValue = "";
cbUOM7.SelectedValue = "";
cbUOM8.SelectedValue = "";
cbUOM9.SelectedValue = "";
cbUOM10.SelectedValue = "";
cbUOM11.SelectedValue = "";
cbUOM12.SelectedValue = "";
cbUOM13.SelectedValue = "";
cbUOM14.SelectedValue = "";
cbUOM15.SelectedValue = "";
cbUOM16.SelectedValue = "";
cbUOM17.SelectedValue = "";
cbUOM18.SelectedValue = "";
cbUOM19.SelectedValue = "";
FillInvoiceID();
}
private void ExecuteOtherGoodsDatabaseTransaction(string command, OleDbParameter[] parameter)
{
string @filelocation = ConfigurationManager.AppSettings["FilePath"].ToString();
OleDbConnection conn = new OleDbConnection(@filelocation);
//OleDbConnection con = new OleDbConnection(@filelocation);
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
cmd.CommandText = command;
cmd.Parameters.AddRange(parameter);
cmd.CommandType = CommandType.Text;
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
private void InsertAllInvoiceItems()
{
for (int controlIndex = 1; controlIndex <= 19; controlIndex++)
{
string name = "txtDescription" + controlIndex;
TextBox txtBox = this.Controls.Find(name, true)[0] as TextBox;
string insertedproductName = txtBox.Text;
name = "txtqty" + controlIndex;
txtBox = this.Controls.Find(name, true)[0] as TextBox;
string insertedquantity = txtBox.Text;
name = "cbUOM" + controlIndex;
ComboBox cmb = this.Controls.Find(name, true)[0] as ComboBox;
string uom = cmb.Text;
name = "txtPrice" + controlIndex;
txtBox = this.Controls.Find(name, true)[0] as TextBox;
string insertedprice = txtBox.Text;
name = "txtGrossAmt" + controlIndex;
txtBox = this.Controls.Find(name, true)[0] as TextBox;
string insertedGrossAmt = txtBox.Text;
name = "txtVAT" + controlIndex;
txtBox = this.Controls.Find(name, true)[0] as TextBox;
string insertedvat = txtBox.Text;
name = "txtVatAmt" + controlIndex;
txtBox = this.Controls.Find(name, true)[0] as TextBox;
string insertedVATamt = txtBox.Text;
name = "txtTotal" + controlIndex;
txtBox = this.Controls.Find(name, true)[0] as TextBox;
string insertedtotal = txtBox.Text;
if (!string.IsNullOrEmpty(insertedproductName))
{
int insertedProductId = GetProductId(insertedproductName);
//InsertIntoInvoiceItems(txtInvoice.Text.Trim(), insertedProductId, insertedquantity, insertedprice, insertedGrossAmt, insertedvat, insertedVATamt, insertedtotal);
InsertIntoInvoiceItems(txtInvoice.Text.Trim(), insertedProductId, insertedquantity, uom, insertedprice, insertedGrossAmt, insertedvat, insertedVATamt, insertedtotal);
}
}
}
private void InsertIntoInvoiceItems(string invoiceNumber, int productId, string quantity, string uom, string price, string GrossAmt, string vat, string vatamount, string total)
{
string InsertInvoiceItems = "INSERT INTO InvoiceItems(InvoiceNumber,ProductId ,Quantity,UOM ,UnitPrice,GrossAmount,VAT,VatAmount,Total)VALUES (@InvoiceNumber,@ProductId,@Quantity,@Uom,@UnitPrice,@GrossAmount,@VAT,@VatAmount,@Total);";
OleDbParameter[] paramet = new OleDbParameter[9];
paramet[0] = new OleDbParameter("@InvoiceNumber", invoiceNumber);
paramet[1] = new OleDbParameter("@ProductId", productId);
paramet[2] = new OleDbParameter("@Quantity", quantity);
paramet[3] = new OleDbParameter("@Uom", uom);
paramet[4] = new OleDbParameter("@UnitPrice", price);
paramet[5] = new OleDbParameter("@GrossAmount", GrossAmt);
paramet[6] = new OleDbParameter("@VAT", vat);
paramet[7] = new OleDbParameter("@VatAmount", vatamount);
paramet[8] = new OleDbParameter("@Total", total);
ExecuteOtherGoodsDatabaseTransaction(InsertInvoiceItems, paramet);
}
private void InsertIntoInvoiceItems(string invoiceNumber, int productId, string quantity, string price, string GrossAmt, string vat, string vatamount, string total)
{
string InsertInvoiceItems = "INSERT INTO InvoiceItems(InvoiceNumber,ProductId ,Quantity ,UnitPrice,GrossAmount,VAT,VatAmount,Total)VALUES (@InvoiceNumber,@ProductId,@Quantity,@UnitPrice,@GrossAmount,@VAT,@VatAmount,@Total);";
OleDbParameter[] paramet = new OleDbParameter[8];
paramet[0] = new OleDbParameter("@InvoiceNumber", invoiceNumber);
paramet[1] = new OleDbParameter("@ProductId", productId);
paramet[2] = new OleDbParameter("@Quantity", quantity);
paramet[3] = new OleDbParameter("@UnitPrice", price);
paramet[4] = new OleDbParameter("@GrossAmount", GrossAmt);
paramet[5] = new OleDbParameter("@VAT", vat);
paramet[6] = new OleDbParameter("@VatAmount", vatamount);
paramet[7] = new OleDbParameter("@Total", total);
ExecuteOtherGoodsDatabaseTransaction(InsertInvoiceItems, paramet);
}
private int GetProductId(string name)
{
int productId = 0;
try
{
productId = fetchProductId(name);
if (productId == 0)
{
if (insertProduct(name))
{
Thread.Sleep(750);
productId = fetchProductId(name);
}
}
}
catch (Exception ex)
{
}
return productId;
}
private bool insertProduct(string name)
{
bool isInsert = false;
string connectionstring = ConfigurationManager.AppSettings["FilePath"].ToString();
string getproductid = "INSERT INTO Products(ProductName) VALUES('" + name.ToString().ToUpper() + "')";
OleDbConnection oledproductidcon = new OleDbConnection(connectionstring);
//OleDbConnection c2 = new OleDbConnection(co);
if (oledproductidcon.State == ConnectionState.Open)
{
oledproductidcon.Close();
}
oledproductidcon.Open();
OleDbCommand oledbproductcmd = new OleDbCommand(getproductid, oledproductidcon);
int rows = oledbproductcmd.ExecuteNonQuery();
if (rows > 0)
{
isInsert = true;
}
return isInsert;
}
private int fetchProductId(string name)
{
int returnProductId = 0;
string connectionstring = ConfigurationManager.AppSettings["FilePath"].ToString();
string getproductid = "SELECT ProductId FROM Products where lcase(ProductName)='" + name.ToLower().ToString() + "'";
OleDbConnection oledproductidcon = new OleDbConnection(connectionstring);
//OleDbConnection c2 = new OleDbConnection(co);
if (oledproductidcon.State == ConnectionState.Open)
{
oledproductidcon.Close();
}
oledproductidcon.Open();
OleDbCommand oledbproductcmd = new OleDbCommand(getproductid, oledproductidcon);
object obj = oledbproductcmd.ExecuteScalar();
if (obj != null)
{
returnProductId = int.Parse(obj.ToString());
}
oledproductidcon.Close();
return returnProductId;
}
private DataTable getqtyandprice(string name)
{
// CommandText = @"SELECT i.Quantity,i.UnitPrice FROM InvoiceItems i INNER JOIN (Products INNER JOIN "
//+ " InvoiceItems ON Products.ProductId = InvoiceItems.ProductId) ON TAXINVOICE.INVOICENO = "
//+ " InvoiceItems.InvoiceNumber WHERE TAXINVOICE.CUSTOMERNAME = '" + customerName + "'";
string s = "SELECT top 1 InvoiceItems.Quantity, InvoiceItems.UnitPrice,InvoiceItems.UOM ,InvoiceItems.Total FROM TAXINVOICE INNER JOIN (InvoiceItems INNER JOIN Products ON InvoiceItems.ProductId = Products.ProductId) ON TAXINVOICE.INVOICENO = InvoiceItems.InvoiceNumber WHERE TAXINVOICE.customername ='" + txtCustName.Text.ToString() + "' AND Products.ProductName ='" + name.ToString() + " 'order by TAXINVOICE.invoiceno desc";
//string s = "SELECT i.UnitPrice FROM Products p INNER JOIN InvoiceItems i on p.ProductId = i.ProductId where ProductName='" + name.ToString() + "'";
string @filelocations = ConfigurationManager.AppSettings["FilePath"].ToString();
OleDbConnection connections = new OleDbConnection(@filelocations);
//OleDbConnection qpcon = new OleDbConnection();
OleDbCommand qpcmd = new OleDbCommand(s, connections);
OleDbDataAdapter qpdatadpter = new OleDbDataAdapter(qpcmd);
//DataSet datset = new DataSet();
DataTable qpdataset = new DataTable();
qpdatadpter.Fill(qpdataset);
return qpdataset;
}
private void Quantity_Changed(object sender, EventArgs e)
{
TextBox txtqty = (TextBox)sender;
string txtName = txtqty.Name.Replace("txtqty", "");
//GetAndCalculateTotal(txtqty.Name.Substring(txtqty.Name.Length - 1));
GetAndCalculateTotal(txtName);
}
private void Price_Changed(object sender, EventArgs e)
{
TextBox txtqty = (TextBox)sender;
string txtName = txtqty.Name.Replace("txtPrice", "");
//GetAndCalculateTotal(txtqty.Name.Substring(txtqty.Name.Length - 1));
GetAndCalculateTotal(txtName);
}
private decimal CalculateGrossAmt(decimal qty, decimal price)
{
decimal value = qty * price;
return value;
}
private void TextBoxAcceptOnlyNumbers(object sender, KeyPressEventArgs e)
{
if (!char.IsControl(e.KeyChar) && !char.IsDigit(e.KeyChar) && e.KeyChar != '.')
{
e.Handled = true;
}
if (e.KeyChar == '.' && (sender as TextBox).Text.IndexOf('.') > -1)
{
e.Handled = true;
}
}
private decimal CalculateVATAmt(decimal GrossAmt, decimal vat)
{
//int vat = 5;
decimal value = ((GrossAmt * vat) / 100);
return value;
}
private decimal CalculateTotal(decimal GrossAmt, decimal totalamount)
{
//int vat = 5;
decimal value = GrossAmt + totalamount;
return value;
}
private void GetAndCalculateTotal(string selectedNumber)
{
decimal qtyValue = 0;
decimal priceValue = 0;
//decimal discValue = 0;
string ItemVal = "";
decimal GrossAmt = 0;
decimal totalamount = 0;
decimal vatpercent = 0;
switch (selectedNumber)
{
case "1":
qtyValue = String.IsNullOrEmpty(txtqty1.Text) ? 0 : decimal.Parse(txtqty1.Text.Trim());
priceValue = String.IsNullOrEmpty(txtPrice1.Text) ? 0 : decimal.Parse(txtPrice1.Text.Trim());
txtGrossAmt1.Text = ((float)CalculateGrossAmt(qtyValue, priceValue)).ToString("0.00");
GrossAmt = Convert.ToDecimal(txtGrossAmt1.Text);
vatpercent = String.IsNullOrEmpty(txtVAT1.Text) ? 0 : decimal.Parse(txtVAT1.Text.Trim());
txtVatAmt1.Text = ((float)CalculateVATAmt(GrossAmt, vatpercent)).ToString("0.00");
totalamount = Convert.ToDecimal(txtVatAmt1.Text);
txtTotal1.Text = ((float)CalculateTotal(GrossAmt, totalamount)).ToString("0.00");
break;
case "2":
qtyValue = String.IsNullOrEmpty(txtqty2.Text) ? 0 : decimal.Parse(txtqty2.Text.Trim());
priceValue = String.IsNullOrEmpty(txtPrice2.Text) ? 0 : decimal.Parse(txtPrice2.Text.Trim());
txtGrossAmt2.Text = ((float)CalculateGrossAmt(qtyValue, priceValue)).ToString("0.00");
GrossAmt = Convert.ToDecimal(txtGrossAmt2.Text);
vatpercent = String.IsNullOrEmpty(txtVAT2.Text) ? 0 : decimal.Parse(txtVAT2.Text.Trim());
txtVatAmt2.Text = ((float)CalculateVATAmt(GrossAmt, vatpercent)).ToString("0.00");
totalamount = Convert.ToDecimal(txtVatAmt2.Text);
txtTotal2.Text = ((float)CalculateTotal(GrossAmt, totalamount)).ToString("0.00");
// lblTotal.Text = (decimal.Parse(lblTotal.Text) + decimal.Parse(tbFTotal2.Text.Trim())).ToString();
break;
case "3":
qtyValue = String.IsNullOrEmpty(txtqty3.Text) ? 0 : decimal.Parse(txtqty3.Text.Trim());
priceValue = String.IsNullOrEmpty(txtPrice3.Text) ? 0 : decimal.Parse(txtPrice3.Text.Trim());
txtGrossAmt3.Text = ((float)CalculateGrossAmt(qtyValue, priceValue)).ToString("0.00");
GrossAmt = Convert.ToDecimal(txtGrossAmt3.Text);
vatpercent = String.IsNullOrEmpty(txtVAT3.Text) ? 0 : decimal.Parse(txtVAT3.Text.Trim());
txtVatAmt3.Text = ((float)CalculateVATAmt(GrossAmt, vatpercent)).ToString("0.00");
totalamount = Convert.ToDecimal(txtVatAmt3.Text);
txtTotal3.Text = ((float)CalculateTotal(GrossAmt, totalamount)).ToString("0.00");
// lblTotal.Text = decimal.Parse(lblTotal.Text) + decimal.Parse(tbFTotal3.Text.Trim()).ToString();
break;
case "4":
qtyValue = String.IsNullOrEmpty(txtqty4.Text) ? 0 : decimal.Parse(txtqty4.Text.Trim());
priceValue = String.IsNullOrEmpty(txtPrice4.Text) ? 0 : decimal.Parse(txtPrice4.Text.Trim());
txtGrossAmt4.Text = ((float)CalculateGrossAmt(qtyValue, priceValue)).ToString("0.00");
GrossAmt = Convert.ToDecimal(txtGrossAmt4.Text);
vatpercent = String.IsNullOrEmpty(txtVAT4.Text) ? 0 : decimal.Parse(txtVAT4.Text.Trim());
txtVatAmt4.Text = ((float)CalculateVATAmt(GrossAmt, vatpercent)).ToString("0.00");
totalamount = Convert.ToDecimal(txtVatAmt4.Text);
txtTotal4.Text = ((float)CalculateTotal(GrossAmt, totalamount)).ToString("0.00");
//tbFTotal4.Text = CalculateTotal(qtyValue, priceValue, discValue).ToString();
// lblTotal.Text = decimal.Parse(lblTotal.Text) + decimal.Parse(tbFTotal4.Text.Trim()).ToString();
break;
case "5":
qtyValue = String.IsNullOrEmpty(txtqty5.Text) ? 0 : decimal.Parse(txtqty5.Text.Trim());
priceValue = String.IsNullOrEmpty(txtPrice5.Text) ? 0 : decimal.Parse(txtPrice5.Text.Trim());
txtGrossAmt5.Text = ((float)CalculateGrossAmt(qtyValue, priceValue)).ToString("0.00");
GrossAmt = Convert.ToDecimal(txtGrossAmt5.Text);
vatpercent = String.IsNullOrEmpty(txtVAT5.Text) ? 0 : decimal.Parse(txtVAT5.Text.Trim());
txtVatAmt5.Text = ((float)CalculateVATAmt(GrossAmt, vatpercent)).ToString("0.00");
totalamount = Convert.ToDecimal(txtVatAmt5.Text);
txtTotal5.Text = ((float)CalculateTotal(GrossAmt, totalamount)).ToString("0.00");
// lblTotal.Text = decimal.Parse(lblTotal.Text) + decimal.Parse(tbFTotal5.Text.Trim()).ToString();
break;
case "6":
qtyValue = String.IsNullOrEmpty(txtqty6.Text) ? 0 : decimal.Parse(txtqty6.Text.Trim());
priceValue = String.IsNullOrEmpty(txtPrice6.Text) ? 0 : decimal.Parse(txtPrice6.Text.Trim());
txtGrossAmt6.Text = ((float)CalculateGrossAmt(qtyValue, priceValue)).ToString("0.00");
GrossAmt = Convert.ToDecimal(txtGrossAmt6.Text);
vatpercent = String.IsNullOrEmpty(txtVAT6.Text) ? 0 : decimal.Parse(txtVAT6.Text.Trim());
txtVatAmt6.Text = ((float)CalculateVATAmt(GrossAmt, vatpercent)).ToString("0.00");
totalamount = Convert.ToDecimal(txtVatAmt6.Text);
txtTotal6.Text = ((float)CalculateTotal(GrossAmt, totalamount)).ToString("0.00");
// lblTotal.Text = decimal.Parse(lblTotal.Text) + decimal.Parse(tbFTotal6.Text.Trim()).ToString();
break;
case "7":
qtyValue = String.IsNullOrEmpty(txtqty7.Text) ? 0 : decimal.Parse(txtqty7.Text.Trim());
priceValue = String.IsNullOrEmpty(txtPrice7.Text) ? 0 : decimal.Parse(txtPrice7.Text.Trim());
txtGrossAmt7.Text = ((float)CalculateGrossAmt(qtyValue, priceValue)).ToString("0.00");
GrossAmt = Convert.ToDecimal(txtGrossAmt7.Text);
vatpercent = String.IsNullOrEmpty(txtVAT7.Text) ? 0 : decimal.Parse(txtVAT7.Text.Trim());
txtVatAmt7.Text = ((float)CalculateVATAmt(GrossAmt, vatpercent)).ToString("0.00");
totalamount = Convert.ToDecimal(txtVatAmt7.Text);
txtTotal7.Text = ((float)CalculateTotal(GrossAmt, totalamount)).ToString("0.00");
//lblTotal.Text = decimal.Parse(lblTotal.Text) + decimal.Parse(tbFTotal7.Text.Trim()).ToString();
break;
case "8":
qtyValue = String.IsNullOrEmpty(txtqty8.Text) ? 0 : decimal.Parse(txtqty8.Text.Trim());
priceValue = String.IsNullOrEmpty(txtPrice8.Text) ? 0 : decimal.Parse(txtPrice8.Text.Trim());
txtGrossAmt8.Text = ((float)CalculateGrossAmt(qtyValue, priceValue)).ToString("0.00");
GrossAmt = Convert.ToDecimal(txtGrossAmt8.Text);
vatpercent = String.IsNullOrEmpty(txtVAT8.Text) ? 0 : decimal.Parse(txtVAT8.Text.Trim());
txtVatAmt8.Text = ((float)CalculateVATAmt(GrossAmt, vatpercent)).ToString("0.00");
totalamount = Convert.ToDecimal(txtVatAmt8.Text);
txtTotal8.Text = ((float)CalculateTotal(GrossAmt, totalamount)).ToString("0.00");
// lblTotal.Text = decimal.Parse(lblTotal.Text) + decimal.Parse(tbFTotal8.Text.Trim()).ToString();
break;
case "9":
qtyValue = String.IsNullOrEmpty(txtqty9.Text) ? 0 : decimal.Parse(txtqty9.Text.Trim());
priceValue = String.IsNullOrEmpty(txtPrice9.Text) ? 0 : decimal.Parse(txtPrice9.Text.Trim());
txtGrossAmt9.Text = ((float)CalculateGrossAmt(qtyValue, priceValue)).ToString("0.00");
GrossAmt = Convert.ToDecimal(txtGrossAmt9.Text);
vatpercent = String.IsNullOrEmpty(txtVAT9.Text) ? 0 : decimal.Parse(txtVAT9.Text.Trim());
txtVatAmt9.Text = ((float)CalculateVATAmt(GrossAmt, vatpercent)).ToString("0.00");
totalamount = Convert.ToDecimal(txtVatAmt9.Text);
txtTotal9.Text = ((float)CalculateTotal(GrossAmt, totalamount)).ToString("0.00");
//lblTotal.Text = (decimal.Parse(lblTotal.Text) + decimal.Parse(tbFTotal1.Text.Trim())).ToString();
break;
case "10":
qtyValue = String.IsNullOrEmpty(txtqty10.Text) ? 0 : decimal.Parse(txtqty10.Text.Trim());
priceValue = String.IsNullOrEmpty(txtPrice10.Text) ? 0 : decimal.Parse(txtPrice10.Text.Trim());
txtGrossAmt10.Text = ((float)CalculateGrossAmt(qtyValue, priceValue)).ToString("0.00");
GrossAmt = Convert.ToDecimal(txtGrossAmt10.Text);
vatpercent = String.IsNullOrEmpty(txtVAT10.Text) ? 0 : decimal.Parse(txtVAT10.Text.Trim());
txtVatAmt10.Text = ((float)CalculateVATAmt(GrossAmt, vatpercent)).ToString("0.00");
totalamount = Convert.ToDecimal(txtVatAmt10.Text);
txtTotal10.Text = ((float)CalculateTotal(GrossAmt, totalamount)).ToString("0.00");
// lblTotal.Text = (decimal.Parse(lblTotal.Text) + decimal.Parse(tbFTotal2.Text.Trim())).ToString();
break;
case "11":
qtyValue = String.IsNullOrEmpty(txtqty11.Text) ? 0 : decimal.Parse(txtqty11.Text.Trim());
priceValue = String.IsNullOrEmpty(txtPrice11.Text) ? 0 : decimal.Parse(txtPrice11.Text.Trim());
txtGrossAmt11.Text = ((float)CalculateGrossAmt(qtyValue, priceValue)).ToString("0.00");
GrossAmt = Convert.ToDecimal(txtGrossAmt11.Text);
vatpercent = String.IsNullOrEmpty(txtVAT11.Text) ? 0 : decimal.Parse(txtVAT11.Text.Trim());
txtVatAmt11.Text = ((float)CalculateVATAmt(GrossAmt, vatpercent)).ToString("0.00");
totalamount = Convert.ToDecimal(txtVatAmt11.Text);
txtTotal11.Text = ((float)CalculateTotal(GrossAmt, totalamount)).ToString("0.00");
// lblTotal.Text = decimal.Parse(lblTotal.Text) + decimal.Parse(tbFTotal3.Text.Trim()).ToString();
break;
case "12":
qtyValue = String.IsNullOrEmpty(txtqty12.Text) ? 0 : decimal.Parse(txtqty12.Text.Trim());
priceValue = String.IsNullOrEmpty(txtPrice12.Text) ? 0 : decimal.Parse(txtPrice12.Text.Trim());
txtGrossAmt12.Text = ((float)CalculateGrossAmt(qtyValue, priceValue)).ToString("0.00");
GrossAmt = Convert.ToDecimal(txtGrossAmt12.Text);
vatpercent = String.IsNullOrEmpty(txtVAT12.Text) ? 0 : decimal.Parse(txtVAT12.Text.Trim());
txtVatAmt12.Text = ((float)CalculateVATAmt(GrossAmt, vatpercent)).ToString("0.00");
totalamount = Convert.ToDecimal(txtVatAmt12.Text);
txtTotal12.Text = ((float)CalculateTotal(GrossAmt, totalamount)).ToString("0.00");
//tbFTotal4.Text = CalculateTotal(qtyValue, priceValue, discValue).ToString();
// lblTotal.Text = decimal.Parse(lblTotal.Text) + decimal.Parse(tbFTotal4.Text.Trim()).ToString();
break;
case "13":
qtyValue = String.IsNullOrEmpty(txtqty13.Text) ? 0 : decimal.Parse(txtqty13.Text.Trim());
priceValue = String.IsNullOrEmpty(txtPrice13.Text) ? 0 : decimal.Parse(txtPrice13.Text.Trim());
txtGrossAmt13.Text = ((float)CalculateGrossAmt(qtyValue, priceValue)).ToString("0.00");
GrossAmt = Convert.ToDecimal(txtGrossAmt13.Text);
vatpercent = String.IsNullOrEmpty(txtVAT13.Text) ? 0 : decimal.Parse(txtVAT13.Text.Trim());
txtVatAmt13.Text = ((float)CalculateVATAmt(GrossAmt, vatpercent)).ToString("0.00");
totalamount = Convert.ToDecimal(txtVatAmt13.Text);
txtTotal13.Text = ((float)CalculateTotal(GrossAmt, totalamount)).ToString("0.00");
// lblTotal.Text = decimal.Parse(lblTotal.Text) + decimal.Parse(tbFTotal5.Text.Trim()).ToString();
break;
case "14":
qtyValue = String.IsNullOrEmpty(txtqty14.Text) ? 0 : decimal.Parse(txtqty14.Text.Trim());
priceValue = String.IsNullOrEmpty(txtPrice14.Text) ? 0 : decimal.Parse(txtPrice14.Text.Trim());
txtGrossAmt14.Text = ((float)CalculateGrossAmt(qtyValue, priceValue)).ToString("0.00");
GrossAmt = Convert.ToDecimal(txtGrossAmt14.Text);
vatpercent = String.IsNullOrEmpty(txtVAT14.Text) ? 0 : decimal.Parse(txtVAT14.Text.Trim());
txtVatAmt14.Text = ((float)CalculateVATAmt(GrossAmt, vatpercent)).ToString("0.00");
totalamount = Convert.ToDecimal(txtVatAmt14.Text);
txtTotal14.Text = ((float)CalculateTotal(GrossAmt, totalamount)).ToString("0.00");
// lblTotal.Text = decimal.Parse(lblTotal.Text) + decimal.Parse(tbFTotal6.Text.Trim()).ToString();
break;
case "15":
qtyValue = String.IsNullOrEmpty(txtqty15.Text) ? 0 : decimal.Parse(txtqty15.Text.Trim());
priceValue = String.IsNullOrEmpty(txtPrice15.Text) ? 0 : decimal.Parse(txtPrice15.Text.Trim());
txtGrossAmt15.Text = ((float)CalculateGrossAmt(qtyValue, priceValue)).ToString("0.00");
GrossAmt = Convert.ToDecimal(txtGrossAmt15.Text);
vatpercent = String.IsNullOrEmpty(txtVAT15.Text) ? 0 : decimal.Parse(txtVAT15.Text.Trim());
txtVatAmt15.Text = ((float)CalculateVATAmt(GrossAmt, vatpercent)).ToString("0.00");
totalamount = Convert.ToDecimal(txtVatAmt15.Text);
txtTotal15.Text = ((float)CalculateTotal(GrossAmt, totalamount)).ToString("0.00");
//lblTotal.Text = decimal.Parse(lblTotal.Text) + decimal.Parse(tbFTotal7.Text.Trim()).ToString();
break;
case "16":
qtyValue = String.IsNullOrEmpty(txtqty16.Text) ? 0 : decimal.Parse(txtqty16.Text.Trim());
priceValue = String.IsNullOrEmpty(txtPrice16.Text) ? 0 : decimal.Parse(txtPrice16.Text.Trim());
txtGrossAmt16.Text = ((float)CalculateGrossAmt(qtyValue, priceValue)).ToString("0.00");
GrossAmt = Convert.ToDecimal(txtGrossAmt16.Text);
vatpercent = String.IsNullOrEmpty(txtVAT16.Text) ? 0 : decimal.Parse(txtVAT16.Text.Trim());
txtVatAmt16.Text = ((float)CalculateVATAmt(GrossAmt, vatpercent)).ToString("0.00");
totalamount = Convert.ToDecimal(txtVatAmt16.Text);
txtTotal16.Text = ((float)CalculateTotal(GrossAmt, totalamount)).ToString("0.00");
// lblTotal.Text = decimal.Parse(lblTotal.Text) + decimal.Parse(tbFTotal8.Text.Trim()).ToString();
break;
case "17":
qtyValue = String.IsNullOrEmpty(txtqty17.Text) ? 0 : decimal.Parse(txtqty17.Text.Trim());
priceValue = String.IsNullOrEmpty(txtPrice17.Text) ? 0 : decimal.Parse(txtPrice17.Text.Trim());
txtGrossAmt17.Text = ((float)CalculateGrossAmt(qtyValue, priceValue)).ToString("0.00");
GrossAmt = Convert.ToDecimal(txtGrossAmt17.Text);
vatpercent = String.IsNullOrEmpty(txtVAT17.Text) ? 0 : decimal.Parse(txtVAT17.Text.Trim());
txtVatAmt17.Text = ((float)CalculateVATAmt(GrossAmt, vatpercent)).ToString("0.00");
totalamount = Convert.ToDecimal(txtVatAmt17.Text);
txtTotal17.Text = ((float)CalculateTotal(GrossAmt, totalamount)).ToString("0.00");
// lblTotal.Text = decimal.Parse(lblTotal.Text) + decimal.Parse(tbFTotal8.Text.Trim()).ToString();
break;
case "18":
qtyValue = String.IsNullOrEmpty(txtqty18.Text) ? 0 : decimal.Parse(txtqty18.Text.Trim());
priceValue = String.IsNullOrEmpty(txtPrice18.Text) ? 0 : decimal.Parse(txtPrice18.Text.Trim());
txtGrossAmt18.Text = ((float)CalculateGrossAmt(qtyValue, priceValue)).ToString("0.00");
GrossAmt = Convert.ToDecimal(txtGrossAmt18.Text);
vatpercent = String.IsNullOrEmpty(txtVAT18.Text) ? 0 : decimal.Parse(txtVAT18.Text.Trim());
txtVatAmt18.Text = ((float)CalculateVATAmt(GrossAmt, vatpercent)).ToString("0.00");
totalamount = Convert.ToDecimal(txtVatAmt18.Text);
txtTotal18.Text = ((float)CalculateTotal(GrossAmt, totalamount)).ToString("0.00");
// lblTotal.Text = decimal.Parse(lblTotal.Text) + decimal.Parse(tbFTotal8.Text.Trim()).ToString();
break;
case "19":
qtyValue = String.IsNullOrEmpty(txtqty19.Text) ? 0 : decimal.Parse(txtqty19.Text.Trim());
priceValue = String.IsNullOrEmpty(txtPrice19.Text) ? 0 : decimal.Parse(txtPrice19.Text.Trim());
txtGrossAmt19.Text = ((float)CalculateGrossAmt(qtyValue, priceValue)).ToString("0.00");
GrossAmt = Convert.ToDecimal(txtGrossAmt19.Text);
vatpercent = String.IsNullOrEmpty(txtVAT19.Text) ? 0 : decimal.Parse(txtVAT19.Text.Trim());
txtVatAmt19.Text = ((float)CalculateVATAmt(GrossAmt, vatpercent)).ToString("0.00");
totalamount = Convert.ToDecimal(txtVatAmt19.Text);
txtTotal19.Text = ((float)CalculateTotal(GrossAmt, totalamount)).ToString("0.00");
// lblTotal.Text = decimal.Parse(lblTotal.Text) + decimal.Parse(tbFTotal8.Text.Trim()).ToString();
break;
}
txtTotalGrossAmt.Text = ((string.IsNullOrEmpty(txtGrossAmt1.Text.Trim()) ? 0 : decimal.Parse(txtGrossAmt1.Text.Trim())) + (string.IsNullOrEmpty(txtGrossAmt2.Text.Trim()) ? 0 : decimal.Parse(txtGrossAmt2.Text.Trim())) +
(string.IsNullOrEmpty(txtGrossAmt3.Text.Trim()) ? 0 : decimal.Parse(txtGrossAmt3.Text.Trim())) +
(string.IsNullOrEmpty(txtGrossAmt4.Text.Trim()) ? 0 : decimal.Parse(txtGrossAmt4.Text.Trim())) +
(string.IsNullOrEmpty(txtGrossAmt5.Text.Trim()) ? 0 : decimal.Parse(txtGrossAmt5.Text.Trim())) +
(string.IsNullOrEmpty(txtGrossAmt6.Text.Trim()) ? 0 : decimal.Parse(txtGrossAmt6.Text.Trim())) +
(string.IsNullOrEmpty(txtGrossAmt7.Text.Trim()) ? 0 : decimal.Parse(txtGrossAmt7.Text.Trim())) +
(string.IsNullOrEmpty(txtGrossAmt8.Text.Trim()) ? 0 : decimal.Parse(txtGrossAmt8.Text.Trim())) +
(string.IsNullOrEmpty(txtGrossAmt9.Text.Trim()) ? 0 : decimal.Parse(txtGrossAmt9.Text.Trim())) +
(string.IsNullOrEmpty(txtGrossAmt10.Text.Trim()) ? 0 : decimal.Parse(txtGrossAmt10.Text.Trim())) +
(string.IsNullOrEmpty(txtGrossAmt11.Text.Trim()) ? 0 : decimal.Parse(txtGrossAmt11.Text.Trim())) +
(string.IsNullOrEmpty(txtGrossAmt12.Text.Trim()) ? 0 : decimal.Parse(txtGrossAmt12.Text.Trim())) +
(string.IsNullOrEmpty(txtGrossAmt13.Text.Trim()) ? 0 : decimal.Parse(txtGrossAmt13.Text.Trim())) +
(string.IsNullOrEmpty(txtGrossAmt14.Text.Trim()) ? 0 : decimal.Parse(txtGrossAmt14.Text.Trim())) +
(string.IsNullOrEmpty(txtGrossAmt15.Text.Trim()) ? 0 : decimal.Parse(txtGrossAmt15.Text.Trim())) + (string.IsNullOrEmpty(txtGrossAmt16.Text.Trim()) ? 0 : decimal.Parse(txtGrossAmt16.Text.Trim())) +
(string.IsNullOrEmpty(txtGrossAmt17.Text.Trim()) ? 0 : decimal.Parse(txtGrossAmt17.Text.Trim())) + (string.IsNullOrEmpty(txtGrossAmt18.Text.Trim()) ? 0 : decimal.Parse(txtGrossAmt18.Text.Trim())) + (string.IsNullOrEmpty(txtGrossAmt19.Text.Trim()) ? 0 : decimal.Parse(txtGrossAmt19.Text.Trim()))).ToString();
txtTotalVATAMT.Text = ((string.IsNullOrEmpty(txtVatAmt1.Text.Trim()) ? 0 : decimal.Parse(txtVatAmt1.Text.Trim())) + (string.IsNullOrEmpty(txtVatAmt2.Text.Trim()) ? 0 : decimal.Parse(txtVatAmt2.Text.Trim())) +
(string.IsNullOrEmpty(txtVatAmt3.Text.Trim()) ? 0 : decimal.Parse(txtVatAmt3.Text.Trim())) +
(string.IsNullOrEmpty(txtVatAmt4.Text.Trim()) ? 0 : decimal.Parse(txtVatAmt4.Text.Trim())) +
(string.IsNullOrEmpty(txtVatAmt5.Text.Trim()) ? 0 : decimal.Parse(txtVatAmt5.Text.Trim())) +
(string.IsNullOrEmpty(txtVatAmt6.Text.Trim()) ? 0 : decimal.Parse(txtVatAmt6.Text.Trim())) +
(string.IsNullOrEmpty(txtVatAmt7.Text.Trim()) ? 0 : decimal.Parse(txtVatAmt7.Text.Trim())) +
(string.IsNullOrEmpty(txtVatAmt8.Text.Trim()) ? 0 : decimal.Parse(txtVatAmt8.Text.Trim())) +
(string.IsNullOrEmpty(txtVatAmt9.Text.Trim()) ? 0 : decimal.Parse(txtVatAmt9.Text.Trim())) +
(string.IsNullOrEmpty(txtVatAmt10.Text.Trim()) ? 0 : decimal.Parse(txtVatAmt10.Text.Trim())) +
(string.IsNullOrEmpty(txtVatAmt11.Text.Trim()) ? 0 : decimal.Parse(txtVatAmt11.Text.Trim())) +
(string.IsNullOrEmpty(txtVatAmt12.Text.Trim()) ? 0 : decimal.Parse(txtVatAmt12.Text.Trim())) +
(string.IsNullOrEmpty(txtVatAmt13.Text.Trim()) ? 0 : decimal.Parse(txtVatAmt13.Text.Trim())) +
(string.IsNullOrEmpty(txtVatAmt14.Text.Trim()) ? 0 : decimal.Parse(txtVatAmt14.Text.Trim())) +
(string.IsNullOrEmpty(txtVatAmt15.Text.Trim()) ? 0 : decimal.Parse(txtVatAmt15.Text.Trim())) + (string.IsNullOrEmpty(txtVatAmt16.Text.Trim()) ? 0 : decimal.Parse(txtVatAmt16.Text.Trim())) +
(string.IsNullOrEmpty(txtVatAmt17.Text.Trim()) ? 0 : decimal.Parse(txtVatAmt17.Text.Trim())) + (string.IsNullOrEmpty(txtVatAmt18.Text.Trim()) ? 0 : decimal.Parse(txtVatAmt18.Text.Trim())) + (string.IsNullOrEmpty(txtVatAmt19.Text.Trim()) ? 0 : decimal.Parse(txtVatAmt19.Text.Trim()))).ToString();
txtTotals.Text = ((string.IsNullOrEmpty(txtTotal1.Text.Trim()) ? 0 : decimal.Parse(txtTotal1.Text.Trim())) + (string.IsNullOrEmpty(txtTotal2.Text.Trim()) ? 0 : decimal.Parse(txtTotal2.Text.Trim())) +
(string.IsNullOrEmpty(txtTotal3.Text.Trim()) ? 0 : decimal.Parse(txtTotal3.Text.Trim())) +
(string.IsNullOrEmpty(txtTotal4.Text.Trim()) ? 0 : decimal.Parse(txtTotal4.Text.Trim())) +
(string.IsNullOrEmpty(txtTotal5.Text.Trim()) ? 0 : decimal.Parse(txtTotal5.Text.Trim())) +
(string.IsNullOrEmpty(txtTotal6.Text.Trim()) ? 0 : decimal.Parse(txtTotal6.Text.Trim())) +
(string.IsNullOrEmpty(txtTotal7.Text.Trim()) ? 0 : decimal.Parse(txtTotal7.Text.Trim())) +
(string.IsNullOrEmpty(txtTotal8.Text.Trim()) ? 0 : decimal.Parse(txtTotal8.Text.Trim())) +
(string.IsNullOrEmpty(txtTotal9.Text.Trim()) ? 0 : decimal.Parse(txtTotal9.Text.Trim())) +
(string.IsNullOrEmpty(txtTotal10.Text.Trim()) ? 0 : decimal.Parse(txtTotal10.Text.Trim())) +
(string.IsNullOrEmpty(txtTotal11.Text.Trim()) ? 0 : decimal.Parse(txtTotal11.Text.Trim())) +
(string.IsNullOrEmpty(txtTotal12.Text.Trim()) ? 0 : decimal.Parse(txtTotal12.Text.Trim())) +
(string.IsNullOrEmpty(txtTotal13.Text.Trim()) ? 0 : decimal.Parse(txtTotal13.Text.Trim())) +
(string.IsNullOrEmpty(txtTotal14.Text.Trim()) ? 0 : decimal.Parse(txtTotal14.Text.Trim())) +
(string.IsNullOrEmpty(txtTotal15.Text.Trim()) ? 0 : decimal.Parse(txtTotal15.Text.Trim())) + (string.IsNullOrEmpty(txtTotal16.Text.Trim()) ? 0 : decimal.Parse(txtTotal16.Text.Trim())) +
(string.IsNullOrEmpty(txtTotal17.Text.Trim()) ? 0 : decimal.Parse(txtTotal17.Text.Trim())) + (string.IsNullOrEmpty(txtTotal18.Text.Trim()) ? 0 : decimal.Parse(txtTotal18.Text.Trim())) + (string.IsNullOrEmpty(txtTotal19.Text.Trim()) ? 0 : decimal.Parse(txtTotal19.Text.Trim()))).ToString();
txtGrandTotal.Text = txtFinalAmt.Text;
txtFinalAmt.Text = txtTotals.Text;
//lbltotalamount.Text = txtTotals.Text;
//decimal b = String.IsNullOrEmpty(txtTotals.Text) ? 0 : decimal.Parse(txtTotals.Text.Trim());
//decimal a = String.IsNullOrEmpty(lblOldBal.Text) ? 0 : decimal.Parse(lblOldBal.Text.Trim());
//txtFinalAmt.Text = (a+b).ToString();
//txtGrandTotal.Text = (a + b).ToString();
//finalcalculation();
//finalbill();
roundoff();
}
public void roundoff()
{
string outPut = "0";
text = txtFinalAmt.Text;
decimal value;
if (decimal.TryParse(text, out value))
{
if (value.ToString().Split('.').Length == 2)
{
outPut = value.ToString().Split('.')[1].Substring(0, value.ToString().Split('.')[1].Length);
}
if (Convert.ToInt32(outPut) >= 50)
{
value = Convert.ToInt32(value.ToString().Split('.')[0].Substring(0, value.ToString().Split('.')[0].Length)) + 1;
}
//else if (Convert.ToInt32(outPut) == 0)
//{
// value = 0;
//}
else
{
value = Convert.ToInt32(value.ToString().Split('.')[0].Substring(0, value.ToString().Split('.')[0].Length));
}
//value = Math.Round(value);
decimal x = String.IsNullOrEmpty(txtFinalAmt.Text) ? 0 : decimal.Parse(txtFinalAmt.Text.Trim());
decimal y = (x - value);
if (x <= value)
{
string var = y.ToString();
var = var.Replace("-", "");
txtRoundOff.Text = "+ " + var;
//decimal add1 = Convert.ToDecimal(var);
////decimal add2 = String.IsNullOrEmpty(txtGrandTotal.Text) ? 0 : decimal.Parse(txtGrandTotal.Text.Trim());
//decimal add3 = String.IsNullOrEmpty(txtFinalAmt.Text) ? 0 : decimal.Parse(txtFinalAmt.Text.Trim());
//decimal sum = add3 + add1;
text = value.ToString();
txtGrandTotal.Text = text.ToString();
}
else
{
string var = y.ToString();
var = var.Replace("+", "");
txtRoundOff.Text = "- " + var;
//decimal add1 = Convert.ToDecimal(var);
////decimal add2 = String.IsNullOrEmpty(txtGrandTotal.Text) ? 0 : decimal.Parse(txtGrandTotal.Text.Trim());
//decimal add3 = String.IsNullOrEmpty(txtFinalAmt.Text) ? 0 : decimal.Parse(txtFinalAmt.Text.Trim());
//decimal sum = add3 - add1;
text = value.ToString();
txtGrandTotal.Text = text.ToString();
}
//text = value.ToString();
}
}
private void txtTransport_TextChanged(object sender, EventArgs e)
{
//int a = Convert.ToInt32(txtTransport.Text);
decimal a = String.IsNullOrEmpty(txtTransport.Text) ? 0 : decimal.Parse(txtTransport.Text.Trim());
decimal b = String.IsNullOrEmpty(txtOthers.Text) ? 0 : decimal.Parse(txtOthers.Text.Trim());
decimal c = String.IsNullOrEmpty(txtTotals.Text) ? 0 : decimal.Parse(txtTotals.Text.Trim());
// decimal d = String.IsNullOrEmpty(lblOldBal.Text) ? 0 : decimal.Parse(lblOldBal.Text.Trim());
txtFinalAmt.Text = (a + b + c).ToString();
//txtGrandTotal.Text = (a + b + c).ToString();
roundoff();
}
private void txtOthers_TextChanged(object sender, EventArgs e)
{
decimal a = String.IsNullOrEmpty(txtTransport.Text) ? 0 : decimal.Parse(txtTransport.Text.Trim());
decimal b = String.IsNullOrEmpty(txtOthers.Text) ? 0 : decimal.Parse(txtOthers.Text.Trim());
decimal c = String.IsNullOrEmpty(txtTotals.Text) ? 0 : decimal.Parse(txtTotals.Text.Trim());
//decimal d = String.IsNullOrEmpty(lblOldBal.Text) ? 0 : decimal.Parse(lblOldBal.Text.Trim());
txtFinalAmt.Text = (a + b + c).ToString();
//txtGrandTotal.Text = (a + b + c).ToString();
roundoff();
}
public string rupeestoword(Int64 rupee)
{
string result = "";
Int64 res;
if ((rupees / 10000000) > 0)
{
res = rupees / 10000000;
rupees = rupees % 10000000;
result = result + ' ' + rupeestowords(res) + " Crore";
}
if ((rupees / 100000) > 0)
{
res = rupees / 100000;
rupees = rupees % 100000;
result = result + ' ' + rupeestowords(res) + " Lack";
}
if ((rupees / 1000) > 0)
{
res = rupees / 1000;
rupees = rupees % 1000;
result = result + ' ' + rupeestowords(res) + " Thousand";
}
if ((rupees / 100) > 0)
{
res = rupees / 100;
rupees = rupees % 100;
result = result + ' ' + rupeestowords(res) + " Hundred";
}
if ((rupees % 10) >= 0)
{
res = rupees % 100;
result = result + " " + rupeestowords(res);
}
result = result + ' ' + " Rupees only";
return result;
}
public string rupeestowords(Int64 rupees)
{
string result = "";
if ((rupees >= 1) && (rupees <= 10))
{
if ((rupees % 10) == 1) result = "One";
if ((rupees % 10) == 2) result = "Two";
if ((rupees % 10) == 3) result = "Three";
if ((rupees % 10) == 4) result = "Four";
if ((rupees % 10) == 5) result = "Five";
if ((rupees % 10) == 6) result = "Six";
if ((rupees % 10) == 7) result = "Seven";
if ((rupees % 10) == 8) result = "Eight";
if ((rupees % 10) == 9) result = "Nine";
if ((rupees % 10) == 0) result = "Ten";
}
if (rupees > 9 && rupees < 20)
{
if (rupees == 11) result = "Eleven";
if (rupees == 12) result = "Twelve";
if (rupees == 13) result = "Thirteen";
if (rupees == 14) result = "Forteen";
if (rupees == 15) result = "Fifteen";
if (rupees == 16) result = "Sixteen";
if (rupees == 17) result = "Seventeen";
if (rupees == 18) result = "Eighteen";
if (rupees == 19) result = "Nineteen";
}
if (rupees > 20 && (rupees / 10) == 2 && (rupees % 10) == 0) result = "Twenty";
if (rupees > 20 && (rupees / 10) == 3 && (rupees % 10) == 0) result = "Thirty";
if (rupees > 20 && (rupees / 10) == 4 && (rupees % 10) == 0) result = "Forty";
if (rupees > 20 && (rupees / 10) == 5 && (rupees % 10) == 0) result = "Fifty";
if (rupees > 20 && (rupees / 10) == 6 && (rupees % 10) == 0) result = "Sixty";
if (rupees > 20 && (rupees / 10) == 7 && (rupees % 10) == 0) result = "Seventy";
if (rupees > 20 && (rupees / 10) == 8 && (rupees % 10) == 0) result = "Eighty";
if (rupees > 20 && (rupees / 10) == 9 && (rupees % 10) == 0) result = "Ninty";
if (rupees > 20 && (rupees / 10) == 2 && (rupees % 10) != 0)
{
if ((rupees % 10) == 1) result = "Twenty One";
if ((rupees % 10) == 2) result = "Twenty Two";
if ((rupees % 10) == 3) result = "Twenty Three";
if ((rupees % 10) == 4) result = "Twenty Four";
if ((rupees % 10) == 5) result = "Twenty Five";
if ((rupees % 10) == 6) result = "Twenty Six";
if ((rupees % 10) == 7) result = "Twenty Seven";
if ((rupees % 10) == 8) result = "Twenty Eight";
if ((rupees % 10) == 9) result = "Twenty Nine";
}
if (rupees > 20 && (rupees / 10) == 3 && (rupees % 10) != 0)
{
if ((rupees % 10) == 1) result = "Thirty One";
if ((rupees % 10) == 2) result = "Thirty Two";
if ((rupees % 10) == 3) result = "Thirty Three";
if ((rupees % 10) == 4) result = "Thirty Four";
if ((rupees % 10) == 5) result = "Thirty Five";
if ((rupees % 10) == 6) result = "Thirty Six";
if ((rupees % 10) == 7) result = "Thirty Seven";
if ((rupees % 10) == 8) result = "Thirty Eight";
if ((rupees % 10) == 9) result = "Thirty Nine";
}
if (rupees > 20 && (rupees / 10) == 4 && (rupees % 10) != 0)
{
if ((rupees % 10) == 1) result = "Forty One";
if ((rupees % 10) == 2) result = "Forty Two";
if ((rupees % 10) == 3) result = "Forty Three";
if ((rupees % 10) == 4) result = "Forty Four";
if ((rupees % 10) == 5) result = "Forty Five";
if ((rupees % 10) == 6) result = "Forty Six";
if ((rupees % 10) == 7) result = "Forty Seven";
if ((rupees % 10) == 8) result = "Forty Eight";
if ((rupees % 10) == 9) result = "Forty Nine";
}
if (rupees > 20 && (rupees / 10) == 5 && (rupees % 10) != 0)
{
if ((rupees % 10) == 1) result = "Fifty One";
if ((rupees % 10) == 2) result = "Fifty Two";
if ((rupees % 10) == 3) result = "Fifty Three";
if ((rupees % 10) == 4) result = "Fifty Four";
if ((rupees % 10) == 5) result = "Fifty Five";
if ((rupees % 10) == 6) result = "Fifty Six";
if ((rupees % 10) == 7) result = "Fifty Seven";
if ((rupees % 10) == 8) result = "Fifty Eight";
if ((rupees % 10) == 9) result = "Fifty Nine";
}
if (rupees > 20 && (rupees / 10) == 6 && (rupees % 10) != 0)
{
if ((rupees % 10) == 1) result = "Sixty One";
if ((rupees % 10) == 2) result = "Sixty Two";
if ((rupees % 10) == 3) result = "Sixty Three";
if ((rupees % 10) == 4) result = "Sixty Four";
if ((rupees % 10) == 5) result = "Sixty Five";
if ((rupees % 10) == 6) result = "Sixty Six";
if ((rupees % 10) == 7) result = "Sixty Seven";
if ((rupees % 10) == 8) result = "Sixty Eight";
if ((rupees % 10) == 9) result = "Sixty Nine";
}
if (rupees > 20 && (rupees / 10) == 7 && (rupees % 10) != 0)
{
if ((rupees % 10) == 1) result = "Seventy One";
if ((rupees % 10) == 2) result = "Seventy Two";
if ((rupees % 10) == 3) result = "Seventy Three";
if ((rupees % 10) == 4) result = "Seventy Four";
if ((rupees % 10) == 5) result = "Seventy Five";
if ((rupees % 10) == 6) result = "Seventy Six";
if ((rupees % 10) == 7) result = "Seventy Seven";
if ((rupees % 10) == 8) result = "Seventy Eight";
if ((rupees % 10) == 9) result = "Seventy Nine";
}
if (rupees > 20 && (rupees / 10) == 8 && (rupees % 10) != 0)
{
if ((rupees % 10) == 1) result = "Eighty One";
if ((rupees % 10) == 2) result = "Eighty Two";
if ((rupees % 10) == 3) result = "Eighty Three";
if ((rupees % 10) == 4) result = "Eighty Four";
if ((rupees % 10) == 5) result = "Eighty Five";
if ((rupees % 10) == 6) result = "Eighty Six";
if ((rupees % 10) == 7) result = "Eighty Seven";
if ((rupees % 10) == 8) result = "Eighty Eight";
if ((rupees % 10) == 9) result = "Eighty Nine";
}
if (rupees > 20 && (rupees / 10) == 9 && (rupees % 10) != 0)
{
if ((rupees % 10) == 1) result = "Ninty One";
if ((rupees % 10) == 2) result = "Ninty Two";
if ((rupees % 10) == 3) result = "Ninty Three";
if ((rupees % 10) == 4) result = "Ninty Four";
if ((rupees % 10) == 5) result = "Ninty Five";
if ((rupees % 10) == 6) result = "Ninty Six";
if ((rupees % 10) == 7) result = "Ninty Seven";
if ((rupees % 10) == 8) result = "Ninty Eight";
if ((rupees % 10) == 9) result = "Ninty Nine";
}
return result;
}
private void FillInvoiceID()
{
string con = ConfigurationManager.AppSettings["FilePath"].ToString();
OleDbConnection c1 = new OleDbConnection(con);
if (c1.State == ConnectionState.Open)
{
c1.Close();
}
c1.Open();
//string retInvoiceIDQuery = "SELECT Max(INVOICENO) as INVOICENO FROM TAXINVOICE";
string retInvoiceIDQuery = "SELECT Max(INVOICENO) as INVOICENO, Max(CurrentYear) as CurrentYear, Max(CreatedOn) as CreatedOn FROM TAXINVOICE";
//string retInvoiceIDQuery = "SELECT Max(CreatedOn) as CreatedOn FROM TAXINVOICE";
OleDbCommand commd = new OleDbCommand(retInvoiceIDQuery, c1);
OleDbDataAdapter datadp = new OleDbDataAdapter(commd);
DataTable datset = new DataTable();
datadp.Fill(datset);
if (datset.Rows[0][0] != null && string.IsNullOrEmpty(datset.Rows[0][0].ToString()))
{
datset.Rows[0][0] = "0";
}
OleDbDataAdapter cmdNew = new OleDbDataAdapter("SELECT CreatedOn FROM TAXINVOICE where createdon=#" + datset.Rows[0]["CreatedOn"].ToString() + "#", c1);
DataTable dtCreatedOn = new DataTable();
cmdNew.Fill(dtCreatedOn);
int existedYear = Convert.ToInt32(datset.Rows[0]["CurrentYear"].ToString());
int currentYear = DateTime.Now.Year;
int currentMonth = DateTime.Now.Month;
if (dtCreatedOn.Rows.Count == 1 && existedYear == currentYear && currentMonth == 4)
{
//DateTime cnvCreated = Convert.ToDateTime(dtCreatedOn.Rows[0]["CreatedOn"].ToString());
//if (cnvCreated.Day == 1)
//{
//}
//else
//{
// invoice = 1;
//}
invoice = 1;
}
//if (existedYear == currentYear && currentMonth == 4)
//{
// invoice = 1;
//}
else
{
if (dtCreatedOn.Rows.Count == 0)
{
invoice = 1;
}
else
{
invoice = Convert.ToInt32(datset.Rows[0]["INVOICENO"].ToString()) + 1;
}
}
txtInvoice.Text = invoice.ToString();
c1.Close();
}
private void txtDescription1_Leave(object sender, EventArgs e)
{
DataTable qpdataset1 = new DataTable();
if (!txtDescription1.Text.Equals(String.Empty) && (comboBox1.Text.Equals("VAT SALES")))
{
txtVAT1.Text = "5";
txtSno1.Text = "1";
}
else if (!txtDescription1.Text.Equals(String.Empty) && (comboBox1.Text.Equals("CST SALES")))
{
//txtVAT1.Text = "";
//txtSno1.Text = "";
//txtVatAmt1.Text = "";
//txtVAT1.Text = "";
//txtTotal1.Text = "";
//txtqty1.Text = "";
//txtPrice1.Text = "";
//txtGrossAmt1.Text = "";
txtVAT1.Text = "2";
txtSno1.Text = "1";
}
else
{
txtVAT1.Text = "";
txtSno1.Text = "";
txtVatAmt1.Text = "";
txtVAT1.Text = "";
txtTotal1.Text = "";
txtqty1.Text = "";
txtPrice1.Text = "";
txtGrossAmt1.Text = "";
}
string desname = txtDescription1.Text.ToString();
qpdataset1 = getqtyandprice(desname);
DataSet dsCustomerChecking = GetRequiredDataTable("SELECT * FROM TAXINVOICE where CUSTOMERNAME = '" + txtCustName.Text.Trim() + "'");
if (dsCustomerChecking.Tables[0].Rows.Count > 0)
{
if (qpdataset1.Rows.Count > 0)
{
////txtqty1.Text = qpdataset1.Rows[0]["Quantity"].ToString();
//if (qpdataset1.Rows[0]["UnitPrice"].ToString().Contains("."))
//{
// txtPrice1.Text = qpdataset1.Rows[0]["UnitPrice"].ToString();
//}
//else
//{
// txtPrice1.Text = qpdataset1.Rows[0]["UnitPrice"].ToString() + ".00";
//}
txtPrice1.Text = qpdataset1.Rows[0]["UnitPrice"].ToString();
cbUOM1.Text = qpdataset1.Rows[0]["UOM"].ToString();
}
}
}
private void txtDescription2_Leave(object sender, EventArgs e)
{
DataTable qpdataset2 = new DataTable();
if (!txtDescription2.Text.Equals(String.Empty) && (comboBox1.Text.Equals("VAT SALES")))
{
txtVAT2.Text = "5";
txtSno2.Text = "2";
}
else if (!txtDescription2.Text.Equals(String.Empty) && (comboBox1.Text.Equals("CST SALES")))
{
txtVAT2.Text = "2";
txtSno2.Text = "2";
}
else
{
txtVAT2.Text = "";
txtSno2.Text = "";
txtVatAmt2.Text = "";
txtVAT2.Text = "";
txtTotal2.Text = "";
txtqty2.Text = "";
txtPrice2.Text = "";
txtGrossAmt2.Text = "";
}
string desname = txtDescription2.Text.ToString();
qpdataset2 = getqtyandprice(desname);
DataSet dsCustomerChecking = GetRequiredDataTable("SELECT * FROM TAXINVOICE where CUSTOMERNAME = '" + txtCustName.Text.Trim() + "'");
if (dsCustomerChecking.Tables[0].Rows.Count > 0)
{
if (qpdataset2.Rows.Count > 0)
{
//txtqty2.Text = qpdataset2.Rows[0]["Quantity"].ToString();
txtPrice2.Text = qpdataset2.Rows[0]["UnitPrice"].ToString();
cbUOM2.Text = qpdataset2.Rows[0]["UOM"].ToString();
}
}
}
private void txtDescription3_Leave(object sender, EventArgs e)
{
DataTable qpdataset3 = new DataTable();
if (!txtDescription3.Text.Equals(String.Empty) && (comboBox1.Text.Equals("VAT SALES")))
{
txtVAT3.Text = "5";
txtSno3.Text = "3";
}
else if (!txtDescription3.Text.Equals(String.Empty) && (comboBox1.Text.Equals("CST SALES")))
{
txtVAT3.Text = "2";
txtSno3.Text = "3";
//txtVAT3.Text = "";
//txtSno3.Text = "";
//txtVatAmt3.Text = "";
//txtVAT3.Text = "";
//txtTotal3.Text = "";
//txtqty3.Text = "";
//txtPrice3.Text = "";
//txtGrossAmt3.Text = "";
}
else
{
txtVAT3.Text = "";
txtSno3.Text = "";
txtVatAmt3.Text = "";
txtVAT3.Text = "";
txtTotal3.Text = "";
txtqty3.Text = "";
txtPrice3.Text = "";
txtGrossAmt3.Text = "";
}
string desname = txtDescription3.Text.ToString();
qpdataset3 = getqtyandprice(desname);
DataSet dsCustomerChecking = GetRequiredDataTable("SELECT * FROM TAXINVOICE where CUSTOMERNAME = '" + txtCustName.Text.Trim() + "'");
if (dsCustomerChecking.Tables[0].Rows.Count > 0)
{
if (qpdataset3.Rows.Count > 0)
{
// txtqty3.Text = qpdataset3.Rows[0]["Quantity"].ToString();
txtPrice3.Text = qpdataset3.Rows[0]["UnitPrice"].ToString();
cbUOM3.Text = qpdataset3.Rows[0]["UOM"].ToString();
}
}
}
private void txtDescription4_Leave(object sender, EventArgs e)
{
DataTable qpdataset4 = new DataTable();
if (!txtDescription4.Text.Equals(String.Empty) && (comboBox1.Text.Equals("VAT SALES")))
{
txtVAT4.Text = "5";
txtSno4.Text = "4";
}
else if (!txtDescription4.Text.Equals(String.Empty) && (comboBox1.Text.Equals("CST SALES")))
{
txtVAT4.Text = "2";
txtSno4.Text = "4";
//txtVAT4.Text = "";
//txtSno4.Text = "";
//txtVatAmt4.Text = "";
//txtVAT4.Text = "";
//txtTotal4.Text = "";
//txtqty4.Text = "";
//txtPrice4.Text = "";
//txtGrossAmt4.Text = "";
}
else
{
txtVAT4.Text = "";
txtSno4.Text = "";
txtVatAmt4.Text = "";
txtVAT4.Text = "";
txtTotal4.Text = "";
txtqty4.Text = "";
txtPrice4.Text = "";
txtGrossAmt4.Text = "";
}
string desname = txtDescription4.Text.ToString();
qpdataset4 = getqtyandprice(desname);
DataSet dsCustomerChecking = GetRequiredDataTable("SELECT * FROM TAXINVOICE where CUSTOMERNAME = '" + txtCustName.Text.Trim() + "'");
if (dsCustomerChecking.Tables[0].Rows.Count > 0)
{
if (qpdataset4.Rows.Count > 0)
{
//txtqty4.Text = qpdataset4.Rows[0]["Quantity"].ToString();
txtPrice4.Text = qpdataset4.Rows[0]["UnitPrice"].ToString();
cbUOM4.Text = qpdataset4.Rows[0]["UOM"].ToString();
}
}
}
private void txtDescription5_Leave(object sender, EventArgs e)
{
DataTable qpdataset5 = new DataTable();
if (!txtDescription5.Text.Equals(String.Empty) && (comboBox1.Text.Equals("VAT SALES")))
{
txtVAT5.Text = "5";
txtSno5.Text = "5";
}
else if (!txtDescription5.Text.Equals(String.Empty) && (comboBox1.Text.Equals("CST SALES")))
{
txtVAT5.Text = "2";
txtSno5.Text = "5";
//txtVAT5.Text = "";
//txtSno5.Text = "";
//txtVatAmt5.Text = "";
//txtVAT5.Text = "";
//txtTotal5.Text = "";
//txtqty5.Text = "";
//txtPrice5.Text = "";
//txtGrossAmt5.Text = "";
}
else
{
txtVAT5.Text = "";
txtSno5.Text = "";
txtVatAmt5.Text = "";
txtVAT5.Text = "";
txtTotal5.Text = "";
txtqty5.Text = "";
txtPrice5.Text = "";
txtGrossAmt5.Text = "";
}
string desname = txtDescription5.Text.ToString();
qpdataset5 = getqtyandprice(desname);
DataSet dsCustomerChecking = GetRequiredDataTable("SELECT * FROM TAXINVOICE where CUSTOMERNAME = '" + txtCustName.Text.Trim() + "'");
if (dsCustomerChecking.Tables[0].Rows.Count > 0)
{
if (qpdataset5.Rows.Count > 0)
{
//txtqty5.Text = qpdataset5.Rows[0]["Quantity"].ToString();
txtPrice5.Text = qpdataset5.Rows[0]["UnitPrice"].ToString();
cbUOM5.Text = qpdataset5.Rows[0]["UOM"].ToString();
}
}
}
private void txtDescription6_Leave(object sender, EventArgs e)
{
DataTable qpdataset6 = new DataTable();
if (!txtDescription6.Text.Equals(String.Empty) && (comboBox1.Text.Equals("VAT SALES")))
{
txtVAT6.Text = "5";
txtSno6.Text = "6";
}
else if (!txtDescription6.Text.Equals(String.Empty) && (comboBox1.Text.Equals("CST SALES")))
{
txtVAT6.Text = "2";
txtSno6.Text = "6";
//txtVAT6.Text = "";
//txtSno6.Text = "";
//txtVatAmt6.Text = "";
//txtVAT6.Text = "";
//txtTotal6.Text = "";
//txtqty6.Text = "";
//txtPrice6.Text = "";
//txtGrossAmt6.Text = "";
}
else
{
txtVAT6.Text = "";
txtSno6.Text = "";
txtVatAmt6.Text = "";
txtVAT6.Text = "";
txtTotal6.Text = "";
txtqty6.Text = "";
txtPrice6.Text = "";
txtGrossAmt6.Text = "";
}
string desname = txtDescription6.Text.ToString();
qpdataset6 = getqtyandprice(desname);
DataSet dsCustomerChecking = GetRequiredDataTable("SELECT * FROM TAXINVOICE where CUSTOMERNAME = '" + txtCustName.Text.Trim() + "'");
if (dsCustomerChecking.Tables[0].Rows.Count > 0)
{
if (qpdataset6.Rows.Count > 0)
{
// txtqty6.Text = qpdataset6.Rows[0]["Quantity"].ToString();
txtPrice6.Text = qpdataset6.Rows[0]["UnitPrice"].ToString();
cbUOM6.Text = qpdataset6.Rows[0]["UOM"].ToString();
}
}
}
private void txtDescription7_Leave(object sender, EventArgs e)
{
DataTable qpdataset7 = new DataTable();
if (!txtDescription7.Text.Equals(String.Empty) && (comboBox1.Text.Equals("VAT SALES")))
{
txtVAT7.Text = "5";
txtSno7.Text = "7";
}
else if (!txtDescription7.Text.Equals(String.Empty) && (comboBox1.Text.Equals("CST SALES")))
{
txtVAT7.Text = "2";
txtSno7.Text = "7";
//txtVAT7.Text = "";
//txtSno7.Text = "";
//txtVatAmt7.Text = "";
//txtVAT7.Text = "";
//txtTotal7.Text = "";
//txtqty7.Text = "";
//txtPrice7.Text = "";
//txtGrossAmt7.Text = "";
}
else
{
txtVAT7.Text = "";
txtSno7.Text = "";
txtVatAmt7.Text = "";
txtVAT7.Text = "";
txtTotal7.Text = "";
txtqty7.Text = "";
txtPrice7.Text = "";
txtGrossAmt7.Text = "";
}
string desname = txtDescription7.Text.ToString();
qpdataset7 = getqtyandprice(desname);
DataSet dsCustomerChecking = GetRequiredDataTable("SELECT * FROM TAXINVOICE where CUSTOMERNAME = '" + txtCustName.Text.Trim() + "'");
if (dsCustomerChecking.Tables[0].Rows.Count > 0)
{
if (qpdataset7.Rows.Count > 0)
{
// txtqty7.Text = qpdataset7.Rows[0]["Quantity"].ToString();
txtPrice7.Text = qpdataset7.Rows[0]["UnitPrice"].ToString();
cbUOM7.Text = qpdataset7.Rows[0]["UOM"].ToString();
}
}
}
private void txtDescription8_Leave(object sender, EventArgs e)
{
DataTable qpdataset8 = new DataTable();
if (!txtDescription8.Text.Equals(String.Empty) && (comboBox1.Text.Equals("VAT SALES")))
{
txtVAT8.Text = "5";
txtSno8.Text = "8";
}
else if (!txtDescription8.Text.Equals(String.Empty) && (comboBox1.Text.Equals("CST SALES")))
{
txtVAT8.Text = "2";
txtSno8.Text = "8";
//txtVAT8.Text = "";
//txtSno8.Text = "";
//txtVatAmt8.Text = "";
//txtVAT8.Text = "";
//txtTotal8.Text = "";
//txtqty8.Text = "";
//txtPrice8.Text = "";
//txtGrossAmt8.Text = "";
}
else
{
txtVAT8.Text = "";
txtSno8.Text = "";
txtVatAmt8.Text = "";
txtVAT8.Text = "";
txtTotal8.Text = "";
txtqty8.Text = "";
txtPrice8.Text = "";
txtGrossAmt8.Text = "";
}
string desname = txtDescription8.Text.ToString();
qpdataset8 = getqtyandprice(desname);
DataSet dsCustomerChecking = GetRequiredDataTable("SELECT * FROM TAXINVOICE where CUSTOMERNAME = '" + txtCustName.Text.Trim() + "'");
if (dsCustomerChecking.Tables[0].Rows.Count > 0)
{
if (qpdataset8.Rows.Count > 0)
{
// txtqty8.Text = qpdataset8.Rows[0]["Quantity"].ToString();
txtPrice8.Text = qpdataset8.Rows[0]["UnitPrice"].ToString();
cbUOM8.Text = qpdataset8.Rows[0]["UOM"].ToString();
}
}
}
private void txtDescription9_Leave(object sender, EventArgs e)
{
DataTable qpdataset9 = new DataTable();
if (!txtDescription9.Text.Equals(String.Empty) && (comboBox1.Text.Equals("VAT SALES")))
{
txtVAT9.Text = "5";
txtSno9.Text = "9";
}
else if (!txtDescription9.Text.Equals(String.Empty) && (comboBox1.Text.Equals("CST SALES")))
{
txtVAT9.Text = "2";
txtSno9.Text = "9";
//txtVAT9.Text = "";
//txtSno9.Text = "";
//txtVatAmt9.Text = "";
//txtVAT9.Text = "";
//txtTotal9.Text = "";
//txtqty9.Text = "";
//txtPrice9.Text = "";
//txtGrossAmt9.Text = "";
}
else
{
txtVAT9.Text = "";
txtSno9.Text = "";
txtVatAmt9.Text = "";
txtVAT9.Text = "";
txtTotal9.Text = "";
txtqty9.Text = "";
txtPrice9.Text = "";
txtGrossAmt9.Text = "";
}
string desname = txtDescription9.Text.ToString();
qpdataset9 = getqtyandprice(desname);
DataSet dsCustomerChecking = GetRequiredDataTable("SELECT * FROM TAXINVOICE where CUSTOMERNAME = '" + txtCustName.Text.Trim() + "'");
if (dsCustomerChecking.Tables[0].Rows.Count > 0)
{
if (qpdataset9.Rows.Count > 0)
{
// txtqty9.Text = qpdataset9.Rows[0]["Quantity"].ToString();
txtPrice9.Text = qpdataset9.Rows[0]["UnitPrice"].ToString();
cbUOM9.Text = qpdataset9.Rows[0]["UOM"].ToString();
}
}
}
private void txtDescription10_Leave(object sender, EventArgs e)
{
DataTable qpdataset10 = new DataTable();
if (!txtDescription10.Text.Equals(String.Empty) && (comboBox1.Text.Equals("VAT SALES")))
{
txtVAT10.Text = "5";
txtSno10.Text = "10";
}
else if (!txtDescription10.Text.Equals(String.Empty) && (comboBox1.Text.Equals("CST SALES")))
{
txtVAT10.Text = "2";
txtSno10.Text = "10";
//txtVAT10.Text = "";
//txtSno10.Text = "";
//txtVatAmt10.Text = "";
//txtVAT10.Text = "";
//txtTotal10.Text = "";
//txtqty10.Text = "";
//txtPrice10.Text = "";
//txtGrossAmt10.Text = "";
}
else
{
txtVAT10.Text = "";
txtSno10.Text = "";
txtVatAmt10.Text = "";
txtVAT10.Text = "";
txtTotal10.Text = "";
txtqty10.Text = "";
txtPrice10.Text = "";
txtGrossAmt10.Text = "";
}
string desname = txtDescription10.Text.ToString();
qpdataset10 = getqtyandprice(desname);
DataSet dsCustomerChecking = GetRequiredDataTable("SELECT * FROM TAXINVOICE where CUSTOMERNAME = '" + txtCustName.Text.Trim() + "'");
if (dsCustomerChecking.Tables[0].Rows.Count > 0)
{
if (qpdataset10.Rows.Count > 0)
{
//txtqty10.Text = qpdataset10.Rows[0]["Quantity"].ToString();
txtPrice10.Text = qpdataset10.Rows[0]["UnitPrice"].ToString();
cbUOM10.Text = qpdataset10.Rows[0]["UOM"].ToString();
}
}
}
private void txtDescription11_Leave(object sender, EventArgs e)
{
DataTable qpdataset11 = new DataTable();
if (!txtDescription11.Text.Equals(String.Empty) && (comboBox1.Text.Equals("VAT SALES")))
{
txtVAT11.Text = "5";
txtSno11.Text = "11";
}
else if (!txtDescription11.Text.Equals(String.Empty) && (comboBox1.Text.Equals("CST SALES")))
{
txtVAT11.Text = "2";
txtSno11.Text = "11";
//txtVAT11.Text = "";
//txtSno11.Text = "";
//txtVatAmt11.Text = "";
//txtVAT11.Text = "";
//txtTotal11.Text = "";
//txtqty11.Text = "";
//txtPrice11.Text = "";
//txtGrossAmt11.Text = "";
}
else
{
txtVAT11.Text = "";
txtSno11.Text = "";
txtVatAmt11.Text = "";
txtVAT11.Text = "";
txtTotal11.Text = "";
txtqty11.Text = "";
txtPrice11.Text = "";
txtGrossAmt11.Text = "";
}
string desname = txtDescription11.Text.ToString();
qpdataset11 = getqtyandprice(desname);
DataSet dsCustomerChecking = GetRequiredDataTable("SELECT * FROM TAXINVOICE where CUSTOMERNAME = '" + txtCustName.Text.Trim() + "'");
if (dsCustomerChecking.Tables[0].Rows.Count > 0)
{
if (qpdataset11.Rows.Count > 0)
{
// txtqty11.Text = qpdataset11.Rows[0]["Quantity"].ToString();
txtPrice11.Text = qpdataset11.Rows[0]["UnitPrice"].ToString();
cbUOM11.Text = qpdataset11.Rows[0]["UOM"].ToString();
}
}
}
private void txtDescription12_Leave(object sender, EventArgs e)
{
DataTable qpdataset12 = new DataTable();
if (!txtDescription12.Text.Equals(String.Empty) && (comboBox1.Text.Equals("VAT SALES")))
{
txtVAT12.Text = "5";
txtSno12.Text = "12";
}
else if (!txtDescription12.Text.Equals(String.Empty) && (comboBox1.Text.Equals("CST SALES")))
{
txtVAT12.Text = "2";
txtSno12.Text = "12";
//txtVAT12.Text = "";
//txtSno12.Text = "";
//txtVatAmt12.Text = "";
//txtVAT12.Text = "";
//txtTotal12.Text = "";
//txtqty12.Text = "";
//txtPrice12.Text = "";
//txtGrossAmt12.Text = "";
}
else
{
txtVAT12.Text = "";
txtSno12.Text = "";
txtVatAmt12.Text = "";
txtVAT12.Text = "";
txtTotal12.Text = "";
txtqty12.Text = "";
txtPrice12.Text = "";
txtGrossAmt12.Text = "";
}
string desname = txtDescription12.Text.ToString();
qpdataset12 = getqtyandprice(desname);
DataSet dsCustomerChecking = GetRequiredDataTable("SELECT * FROM TAXINVOICE where CUSTOMERNAME = '" + txtCustName.Text.Trim() + "'");
if (dsCustomerChecking.Tables[0].Rows.Count > 0)
{
if (qpdataset12.Rows.Count > 0)
{
// txtqty12.Text = qpdataset12.Rows[0]["Quantity"].ToString();
txtPrice12.Text = qpdataset12.Rows[0]["UnitPrice"].ToString();
cbUOM12.Text = qpdataset12.Rows[0]["UOM"].ToString();
}
}
}
private void txtDescription13_Leave(object sender, EventArgs e)
{
DataTable qpdataset13 = new DataTable();
if (!txtDescription13.Text.Equals(String.Empty) && (comboBox1.Text.Equals("VAT SALES")))
{
txtVAT13.Text = "5";
txtSno13.Text = "13";
}
else if (!txtDescription13.Text.Equals(String.Empty) && (comboBox1.Text.Equals("CST SALES")))
{
txtVAT13.Text = "2";
txtSno13.Text = "13";
//txtVAT13.Text = "";
//txtSno13.Text = "";
//txtVatAmt13.Text = "";
//txtVAT13.Text = "";
//txtTotal13.Text = "";
//txtqty13.Text = "";
//txtPrice13.Text = "";
//txtGrossAmt13.Text = "";
}
else
{
txtVAT13.Text = "";
txtSno13.Text = "";
txtVatAmt13.Text = "";
txtVAT13.Text = "";
txtTotal13.Text = "";
txtqty13.Text = "";
txtPrice13.Text = "";
txtGrossAmt13.Text = "";
}
string desname = txtDescription13.Text.ToString();
qpdataset13 = getqtyandprice(desname);
DataSet dsCustomerChecking = GetRequiredDataTable("SELECT * FROM TAXINVOICE where CUSTOMERNAME = '" + txtCustName.Text.Trim() + "'");
if (dsCustomerChecking.Tables[0].Rows.Count > 0)
{
if (qpdataset13.Rows.Count > 0)
{
// txtqty13.Text = qpdataset13.Rows[0]["Quantity"].ToString();
txtPrice13.Text = qpdataset13.Rows[0]["UnitPrice"].ToString();
cbUOM13.Text = qpdataset13.Rows[0]["UOM"].ToString();
}
}
}
private void txtDescription14_Leave(object sender, EventArgs e)
{
DataTable qpdataset14 = new DataTable();
if (!txtDescription14.Text.Equals(String.Empty) && (comboBox1.Text.Equals("VAT SALES")))
{
txtVAT14.Text = "5";
txtSno14.Text = "14";
}
else if (!txtDescription14.Text.Equals(String.Empty) && (comboBox1.Text.Equals("CST SALES")))
{
//txtVAT14.Text = "";
//txtSno14.Text = "";
//txtVatAmt14.Text = "";
//txtVAT14.Text = "";
//txtTotal14.Text = "";
//txtqty14.Text = "";
//txtPrice14.Text = "";
//txtGrossAmt14.Text = "";
txtVAT14.Text = "2";
txtSno14.Text = "14";
}
else
{
txtVAT14.Text = "";
txtSno14.Text = "";
txtVatAmt14.Text = "";
txtVAT14.Text = "";
txtTotal14.Text = "";
txtqty14.Text = "";
txtPrice14.Text = "";
txtGrossAmt14.Text = "";
}
string desname = txtDescription14.Text.ToString();
qpdataset14 = getqtyandprice(desname);
DataSet dsCustomerChecking = GetRequiredDataTable("SELECT * FROM TAXINVOICE where CUSTOMERNAME = '" + txtCustName.Text.Trim() + "'");
if (dsCustomerChecking.Tables[0].Rows.Count > 0)
{
if (qpdataset14.Rows.Count > 0)
{
// txtqty14.Text = qpdataset14.Rows[0]["Quantity"].ToString();
txtPrice14.Text = qpdataset14.Rows[0]["UnitPrice"].ToString();
cbUOM14.Text = qpdataset14.Rows[0]["UOM"].ToString();
}
}
}
private void txtDescription15_Leave(object sender, EventArgs e)
{
DataTable qpdataset15 = new DataTable();
if (!txtDescription15.Text.Equals(String.Empty) && (comboBox1.Text.Equals("VAT SALES")))
{
txtVAT15.Text = "5";
txtSno15.Text = "15";
}
else if (!txtDescription15.Text.Equals(String.Empty) && (comboBox1.Text.Equals("CST SALES")))
{
txtVAT15.Text = "2";
txtSno15.Text = "15";
//txtVAT15.Text = "";
//txtSno15.Text = "";
//txtVatAmt15.Text = "";
//txtVAT15.Text = "";
//txtTotal15.Text = "";
//txtqty15.Text = "";
//txtPrice15.Text = "";
//txtGrossAmt15.Text = "";
}
else
{
txtVAT15.Text = "";
txtSno15.Text = "";
txtVatAmt15.Text = "";
txtVAT15.Text = "";
txtTotal15.Text = "";
txtqty15.Text = "";
txtPrice15.Text = "";
txtGrossAmt15.Text = "";
}
string desname = txtDescription15.Text.ToString();
qpdataset15 = getqtyandprice(desname);
DataSet dsCustomerChecking = GetRequiredDataTable("SELECT * FROM TAXINVOICE where CUSTOMERNAME = '" + txtCustName.Text.Trim() + "'");
if (dsCustomerChecking.Tables[0].Rows.Count > 0)
{
if (qpdataset15.Rows.Count > 0)
{
// txtqty15.Text = qpdataset15.Rows[0]["Quantity"].ToString();
txtPrice15.Text = qpdataset15.Rows[0]["UnitPrice"].ToString();
cbUOM15.Text = qpdataset15.Rows[0]["UOM"].ToString();
}
}
}
private void txtDescription16_Leave(object sender, EventArgs e)
{
DataTable qpdataset16 = new DataTable();
if (!txtDescription16.Text.Equals(String.Empty) && (comboBox1.Text.Equals("VAT SALES")))
{
txtVAT16.Text = "5";
txtSno16.Text = "16";
}
else if (!txtDescription16.Text.Equals(String.Empty) && (comboBox1.Text.Equals("CST SALES")))
{
txtVAT16.Text = "2";
txtSno16.Text = "16";
//txtVAT16.Text = "";
//txtSno16.Text = "";
//txtVatAmt16.Text = "";
//txtVAT16.Text = "";
//txtTotal16.Text = "";
//txtqty16.Text = "";
//txtPrice16.Text = "";
//txtGrossAmt16.Text = "";
}
else
{
txtVAT16.Text = "";
txtSno16.Text = "";
txtVatAmt16.Text = "";
txtVAT16.Text = "";
txtTotal16.Text = "";
txtqty16.Text = "";
txtPrice16.Text = "";
txtGrossAmt16.Text = "";
}
string desname = txtDescription16.Text.ToString();
qpdataset16 = getqtyandprice(desname);
DataSet dsCustomerChecking = GetRequiredDataTable("SELECT * FROM TAXINVOICE where CUSTOMERNAME = '" + txtCustName.Text.Trim() + "'");
if (dsCustomerChecking.Tables[0].Rows.Count > 0)
{
if (qpdataset16.Rows.Count > 0)
{
// txtqty16.Text = qpdataset16.Rows[0]["Quantity"].ToString();
txtPrice16.Text = qpdataset16.Rows[0]["UnitPrice"].ToString();
cbUOM16.Text = qpdataset16.Rows[0]["UOM"].ToString();
}
}
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
//string co = ConfigurationManager.AppSettings["FilePath"].ToString();
//OleDbConnection c2 = new OleDbConnection(co);
////OleDbConnection c2 = new OleDbConnection(co);
//if (c2.State == ConnectionState.Open)
//{
// c2.Close();
//}
//c2.Open();
//string MOBILE = textBox1.Text;
//string s1 = "SELECT * FROM TAXINVOICE where MOBILENUMBER = '" + MOBILE.ToString() + "'";
//OleDbCommand commad = new OleDbCommand(s1, c2);
//OleDbDataAdapter datadpter = new OleDbDataAdapter(commad);
////DataSet datset = new DataSet();
//DataSet ds2 = new DataSet();
//datadpter.Fill(ds2);
//if (ds2.Tables[0].Rows.Count > 0)
//{
// txtCustName.Text = ds2.Tables[0].Rows[0]["CUSTOMERNAME"].ToString();
// txtAddress.Text = ds2.Tables[0].Rows[0]["ADDRESS"].ToString();
// txtTINnum.Text = ds2.Tables[0].Rows[0]["TINNO"].ToString();
// txtPOnum.Text = ds2.Tables[0].Rows[0]["PONO"].ToString();
// CreatedDate.Text = ds2.Tables[0].Rows[0]["CREATEDDATE"].ToString();
// // IsUserExisted = 0;
//}
////dataAdapter1.Dispose();
////cmd1.Dispose();
////con.Close();
}
private void txtDescription17_Leave(object sender, EventArgs e)
{
DataTable qpdataset17 = new DataTable();
if (!txtDescription17.Text.Equals(String.Empty) && (comboBox1.Text.Equals("VAT SALES")))
{
txtVAT17.Text = "5";
txtSno17.Text = "17";
}
else if (!txtDescription17.Text.Equals(String.Empty) && (comboBox1.Text.Equals("CST SALES")))
{
txtVAT17.Text = "2";
txtSno17.Text = "17";
//txtVAT17.Text = "";
//txtSno17.Text = "";
//txtVatAmt17.Text = "";
//txtVAT17.Text = "";
//txtTotal17.Text = "";
//txtqty17.Text = "";
//txtPrice17.Text = "";
//txtGrossAmt17.Text = "";
}
else
{
txtVAT17.Text = "";
txtSno17.Text = "";
txtVatAmt17.Text = "";
txtVAT17.Text = "";
txtTotal17.Text = "";
txtqty17.Text = "";
txtPrice17.Text = "";
txtGrossAmt17.Text = "";
}
string desname = txtDescription17.Text.ToString();
qpdataset17 = getqtyandprice(desname);
DataSet dsCustomerChecking = GetRequiredDataTable("SELECT * FROM TAXINVOICE where CUSTOMERNAME = '" + txtCustName.Text.Trim() + "'");
if (dsCustomerChecking.Tables[0].Rows.Count > 0)
{
if (qpdataset17.Rows.Count > 0)
{
// txtqty17.Text = qpdataset17.Rows[0]["Quantity"].ToString();
txtPrice17.Text = qpdataset17.Rows[0]["UnitPrice"].ToString();
cbUOM17.Text = qpdataset17.Rows[0]["UOM"].ToString();
}
}
}
private void txtDescription18_Leave(object sender, EventArgs e)
{
DataTable qpdataset18 = new DataTable();
if (!txtDescription18.Text.Equals(String.Empty) && (comboBox1.Text.Equals("VAT SALES")))
{
txtVAT18.Text = "5";
txtSno18.Text = "18";
}
else if (!txtDescription18.Text.Equals(String.Empty) && (comboBox1.Text.Equals("CST SALES")))
{
txtVAT18.Text = "2";
txtSno18.Text = "18";
//txtVAT18.Text = "";
//txtSno18.Text = "";
//txtVatAmt18.Text = "";
//txtVAT18.Text = "";
//txtTotal18.Text = "";
//txtqty18.Text = "";
//txtPrice18.Text = "";
//txtGrossAmt18.Text = "";
}
else
{
txtVAT18.Text = "";
txtSno18.Text = "";
txtVatAmt18.Text = "";
txtVAT18.Text = "";
txtTotal18.Text = "";
txtqty18.Text = "";
txtPrice18.Text = "";
txtGrossAmt18.Text = "";
}
string desname = txtDescription18.Text.ToString();
qpdataset18 = getqtyandprice(desname);
DataSet dsCustomerChecking = GetRequiredDataTable("SELECT * FROM TAXINVOICE where CUSTOMERNAME = '" + txtCustName.Text.Trim() + "'");
if (dsCustomerChecking.Tables[0].Rows.Count > 0)
{
if (qpdataset18.Rows.Count > 0)
{
// txtqty18.Text = qpdataset18.Rows[0]["Quantity"].ToString();
txtPrice18.Text = qpdataset18.Rows[0]["UnitPrice"].ToString();
cbUOM18.Text = qpdataset18.Rows[0]["UOM"].ToString();
}
}
}
private void txtDescription19_Leave(object sender, EventArgs e)
{
DataTable qpdataset19 = new DataTable();
if (!txtDescription19.Text.Equals(String.Empty) && (comboBox1.Text.Equals("VAT SALES")))
{
txtVAT19.Text = "5";
txtSno19.Text = "19";
}
else if (!txtDescription19.Text.Equals(String.Empty) && (comboBox1.Text.Equals("CST SALES")))
{
txtVAT19.Text = "2";
txtSno19.Text = "19";
}
else
{
txtVAT19.Text = "";
txtSno19.Text = "";
txtVatAmt19.Text = "";
txtVAT19.Text = "";
txtTotal19.Text = "";
txtqty19.Text = "";
txtPrice19.Text = "";
txtGrossAmt19.Text = "";
}
string desname = txtDescription19.Text.ToString();
qpdataset19 = getqtyandprice(desname);
DataSet dsCustomerChecking = GetRequiredDataTable("SELECT * FROM TAXINVOICE where CUSTOMERNAME = '" + txtCustName.Text.Trim() + "'");
if (dsCustomerChecking.Tables[0].Rows.Count > 0)
{
if (qpdataset19.Rows.Count > 0)
{
// txtqty19.Text = qpdataset19.Rows[0]["Quantity"].ToString();
txtPrice19.Text = qpdataset19.Rows[0]["UnitPrice"].ToString();
cbUOM19.Text = qpdataset19.Rows[0]["UOM"].ToString();
}
}
}
public bool isNumber(char ch, string text)
{
bool res = true;
char decimalChar = Convert.ToChar(CultureInfo.CurrentCulture.NumberFormat.NumberDecimalSeparator);
//check if it´s a decimal separator and if doesn´t already have one in the text string
if (ch == decimalChar && text.IndexOf(decimalChar) != -1)
{
res = false;
return res;
}
//check if it´s a digit, decimal separator and backspace
if (!Char.IsDigit(ch) && ch != decimalChar && ch != (char)Keys.Back)
res = false;
return res;
}
private void txtTransport_Leave(object sender, EventArgs e)
{
decimal value = String.IsNullOrEmpty(txtTransport.Text) ? 0 : decimal.Parse(txtTransport.Text.Trim());
if (!txtTransport.Text.Equals(String.Empty))
{
if (value.ToString().Contains("."))
{
txtTransport.Text = value.ToString();
}
else
{
txtTransport.Text = value.ToString() + ".00";
}
}
}
private void txtOthers_Leave(object sender, EventArgs e)
{
decimal value = String.IsNullOrEmpty(txtOthers.Text) ? 0 : decimal.Parse(txtOthers.Text.Trim());
if (!txtOthers.Text.Equals(String.Empty))
{
if (value.ToString().Contains("."))
{
txtOthers.Text = value.ToString();
}
else
{
txtOthers.Text = value.ToString() + ".00";
}
}
}
private void txtPrice1_Leave(object sender, EventArgs e)
{
decimal value = String.IsNullOrEmpty(txtPrice1.Text) ? 0 : decimal.Parse(txtPrice1.Text.Trim());
if (!txtPrice1.Text.Equals(String.Empty))
{
if (value.ToString().Contains("."))
{
txtPrice1.Text = value.ToString();
}
else
{
txtPrice1.Text = value.ToString() + ".00";
}
}
}
private void txtPrice2_Leave(object sender, EventArgs e)
{
decimal value = String.IsNullOrEmpty(txtPrice2.Text) ? 0 : decimal.Parse(txtPrice2.Text.Trim());
if (!txtPrice2.Text.Equals(String.Empty))
{
if (value.ToString().Contains("."))
{
txtPrice2.Text = value.ToString();
}
else
{
txtPrice2.Text = value.ToString() + ".00";
}
}
}
private void txtPrice3_Leave(object sender, EventArgs e)
{
decimal value = String.IsNullOrEmpty(txtPrice3.Text) ? 0 : decimal.Parse(txtPrice3.Text.Trim());
if (!txtPrice3.Text.Equals(String.Empty))
{
if (value.ToString().Contains("."))
{
txtPrice3.Text = value.ToString();
}
else
{
txtPrice3.Text = value.ToString() + ".00";
}
}
}
private void txtPrice4_Leave(object sender, EventArgs e)
{
decimal value = String.IsNullOrEmpty(txtPrice4.Text) ? 0 : decimal.Parse(txtPrice4.Text.Trim());
if (!txtPrice4.Text.Equals(String.Empty))
{
if (value.ToString().Contains("."))
{
txtPrice4.Text = value.ToString();
}
else
{
txtPrice4.Text = value.ToString() + ".00";
}
}
}
private void txtPrice5_Leave(object sender, EventArgs e)
{
decimal value = String.IsNullOrEmpty(txtPrice5.Text) ? 0 : decimal.Parse(txtPrice5.Text.Trim());
if (!txtPrice5.Text.Equals(String.Empty))
{
if (value.ToString().Contains("."))
{
txtPrice5.Text = value.ToString();
}
else
{
txtPrice5.Text = value.ToString() + ".00";
}
}
}
private void txtPrice6_Leave(object sender, EventArgs e)
{
decimal value = String.IsNullOrEmpty(txtPrice6.Text) ? 0 : decimal.Parse(txtPrice6.Text.Trim());
if (!txtPrice6.Text.Equals(String.Empty))
{
if (value.ToString().Contains("."))
{
txtPrice6.Text = value.ToString();
}
else
{
txtPrice6.Text = value.ToString() + ".00";
}
}
}
private void txtPrice7_Leave(object sender, EventArgs e)
{
decimal value = String.IsNullOrEmpty(txtPrice7.Text) ? 0 : decimal.Parse(txtPrice7.Text.Trim());
if (!txtPrice7.Text.Equals(String.Empty))
{
if (value.ToString().Contains("."))
{
txtPrice7.Text = value.ToString();
}
else
{
txtPrice7.Text = value.ToString() + ".00";
}
}
}
private void txtPrice8_Leave(object sender, EventArgs e)
{
decimal value = String.IsNullOrEmpty(txtPrice8.Text) ? 0 : decimal.Parse(txtPrice8.Text.Trim());
if (!txtPrice8.Text.Equals(String.Empty))
{
if (value.ToString().Contains("."))
{
txtPrice8.Text = value.ToString();
}
else
{
txtPrice8.Text = value.ToString() + ".00";
}
}
}
private void txtPrice9_Leave(object sender, EventArgs e)
{
decimal value = String.IsNullOrEmpty(txtPrice9.Text) ? 0 : decimal.Parse(txtPrice9.Text.Trim());
if (!txtPrice9.Text.Equals(String.Empty))
{
if (value.ToString().Contains("."))
{
txtPrice9.Text = value.ToString();
}
else
{
txtPrice9.Text = value.ToString() + ".00";
}
}
}
private void txtPrice10_Leave(object sender, EventArgs e)
{
decimal value = String.IsNullOrEmpty(txtPrice10.Text) ? 0 : decimal.Parse(txtPrice10.Text.Trim());
if (!txtPrice10.Text.Equals(String.Empty))
{
if (value.ToString().Contains("."))
{
txtPrice10.Text = value.ToString();
}
else
{
txtPrice10.Text = value.ToString() + ".00";
}
}
}
private void txtPrice11_Leave(object sender, EventArgs e)
{
decimal value = String.IsNullOrEmpty(txtPrice11.Text) ? 0 : decimal.Parse(txtPrice11.Text.Trim());
if (!txtPrice11.Text.Equals(String.Empty))
{
if (value.ToString().Contains("."))
{
txtPrice11.Text = value.ToString();
}
else
{
txtPrice11.Text = value.ToString() + ".00";
}
}
}
private void txtPrice12_Leave(object sender, EventArgs e)
{
decimal value = String.IsNullOrEmpty(txtPrice12.Text) ? 0 : decimal.Parse(txtPrice12.Text.Trim());
if (!txtPrice12.Text.Equals(String.Empty))
{
if (value.ToString().Contains("."))
{
txtPrice12.Text = value.ToString();
}
else
{
txtPrice12.Text = value.ToString() + ".00";
}
}
}
private void txtPrice13_Leave(object sender, EventArgs e)
{
decimal value = String.IsNullOrEmpty(txtPrice13.Text) ? 0 : decimal.Parse(txtPrice13.Text.Trim());
if (!txtPrice13.Text.Equals(String.Empty))
{
if (value.ToString().Contains("."))
{
txtPrice13.Text = value.ToString();
}
else
{
txtPrice13.Text = value.ToString() + ".00";
}
}
}
private void txtPrice14_Leave(object sender, EventArgs e)
{
decimal value = String.IsNullOrEmpty(txtPrice14.Text) ? 0 : decimal.Parse(txtPrice14.Text.Trim());
if (!txtPrice14.Text.Equals(String.Empty))
{
if (value.ToString().Contains("."))
{
txtPrice14.Text = value.ToString();
}
else
{
txtPrice14.Text = value.ToString() + ".00";
}
}
}
private void txtPrice15_Leave(object sender, EventArgs e)
{
decimal value = String.IsNullOrEmpty(txtPrice15.Text) ? 0 : decimal.Parse(txtPrice15.Text.Trim());
if (!txtPrice15.Text.Equals(String.Empty))
{
if (value.ToString().Contains("."))
{
txtPrice15.Text = value.ToString();
}
else
{
txtPrice15.Text = value.ToString() + ".00";
}
}
}
private void txtPrice16_Leave(object sender, EventArgs e)
{
decimal value = String.IsNullOrEmpty(txtPrice16.Text) ? 0 : decimal.Parse(txtPrice16.Text.Trim());
if (!txtPrice16.Text.Equals(String.Empty))
{
if (value.ToString().Contains("."))
{
txtPrice16.Text = value.ToString();
}
else
{
txtPrice16.Text = value.ToString() + ".00";
}
}
}
private void txtPrice17_Leave(object sender, EventArgs e)
{
decimal value = String.IsNullOrEmpty(txtPrice17.Text) ? 0 : decimal.Parse(txtPrice17.Text.Trim());
if (!txtPrice17.Text.Equals(String.Empty))
{
if (value.ToString().Contains("."))
{
txtPrice17.Text = value.ToString();
}
else
{
txtPrice17.Text = value.ToString() + ".00";
}
}
}
private void txtPrice18_Leave(object sender, EventArgs e)
{
decimal value = String.IsNullOrEmpty(txtPrice18.Text) ? 0 : decimal.Parse(txtPrice18.Text.Trim());
if (!txtPrice18.Text.Equals(String.Empty))
{
if (value.ToString().Contains("."))
{
txtPrice18.Text = value.ToString();
}
else
{
txtPrice18.Text = value.ToString() + ".00";
}
}
}
private void txtPrice19_Leave(object sender, EventArgs e)
{
decimal value = String.IsNullOrEmpty(txtPrice19.Text) ? 0 : decimal.Parse(txtPrice19.Text.Trim());
if (!txtPrice19.Text.Equals(String.Empty))
{
if (value.ToString().Contains("."))
{
txtPrice19.Text = value.ToString();
}
else
{
txtPrice19.Text = value.ToString() + ".00";
}
}
}
private void TAXINVOICE_Load_1(object sender, EventArgs e)
{
FillCustomerNames();
txtCustName.AutoCompleteMode = AutoCompleteMode.Suggest;
txtCustName.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtCustName.AutoCompleteCustomSource = namesCollection;
}
private void FillCustomerNames()
{
namesCollection = new AutoCompleteStringCollection();
string filelocation = ConfigurationManager.AppSettings["FilePath"].ToString();
OleDbDataReader dReader;
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = filelocation;
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = @"SELECT Distinct[CUSTOMERNAME] FROM TAXINVOICE";
// Array namesCollection=
//ArrayList namesCollection = new ArrayList();
conn.Open();
dReader = cmd.ExecuteReader();
if (dReader.HasRows == true)
{
while (dReader.Read())
namesCollection.Add(dReader["CUSTOMERNAME"].ToString());
}
}
private void FillDescriptions(string customerName)
{
descriptionCollection = new AutoCompleteStringCollection();
string filelocation = ConfigurationManager.AppSettings["FilePath"].ToString();
OleDbDataReader dReader;
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = filelocation;
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = @"SELECT Products.ProductName FROM TAXINVOICE INNER JOIN (Products INNER JOIN "
+ " InvoiceItems ON Products.ProductId = InvoiceItems.ProductId) ON TAXINVOICE.INVOICENO = "
+ " InvoiceItems.InvoiceNumber WHERE TAXINVOICE.CUSTOMERNAME = '" + customerName + "'";
// Array namesCollection=
//ArrayList namesCollection = new ArrayList();
conn.Open();
dReader = cmd.ExecuteReader();
if (dReader.HasRows == true)
{
while (dReader.Read())
descriptionCollection.Add(dReader["ProductName"].ToString());
}
// cmd.CommandText = @"SELECT DISTINCT InvoiceItems.Quantity,InvocieItems.UnitPrice,InvoiceItems.VAT FROM TAXINVOICE INNER JOIN (Products INNER JOIN "
//+ " InvoiceItems ON Products.ProductId = InvoiceItems.ProductId) ON TAXINVOICE.INVOICENO = "
//+ " InvoiceItems.InvoiceNumber WHERE TAXINVOICE.CUSTOMERNAME = '" + customerName + "'";
}
private DataSet GetRequiredDataTable(string query)
{
string connection = ConfigurationManager.AppSettings["FilePath"].ToString();
OleDbConnection c3 = new OleDbConnection(connection);
if (c3.State == ConnectionState.Open)
{
c3.Close();
}
c3.Open();
OleDbDataAdapter da = new OleDbDataAdapter(query, c3);
DataSet ds = new DataSet();
da.Fill(ds);
return ds;
}
private void txtCustName_Leave(object sender, EventArgs e)
{
//string connection = ConfigurationManager.AppSettings["FilePath"].ToString();
//OleDbConnection c3 = new OleDbConnection(connection);
//OleDbConnection c2 = new OleDbConnection(co);
//if (c3.State == ConnectionState.Open)
//{
// c3.Close();
//}
//c3.Open();
string custname = txtCustName.Text;
string string1 = "SELECT * FROM TAXINVOICE where CUSTOMERNAME = '" + custname.ToString() + "'";
//OleDbCommand custcommand = new OleDbCommand(string1, c3);
//OleDbDataAdapter custdatadpter = new OleDbDataAdapter(custcommand);
//DataSet datset = new DataSet();
//DataSet custdataset = new DataSet();
//custdatadpter.Fill(custdataset);
DataSet custdataset = GetRequiredDataTable("select * from TAXINVOICE where INVOICENO=(SELECT Max(INVOICENO) FROM TAXINVOICE WHERE CUSTOMERNAME='" + custname.ToString() + "')");
if (custdataset.Tables[0].Rows.Count > 0)
{
txtCustName.Text = custdataset.Tables[0].Rows[0]["CUSTOMERNAME"].ToString();
txtAddress1.Text = custdataset.Tables[0].Rows[0]["ADDRESS1"].ToString();
txtAddress2.Text = custdataset.Tables[0].Rows[0]["ADDRESS2"].ToString();
txtTINnum.Text = custdataset.Tables[0].Rows[0]["TINNO"].ToString();
//txtPOnum.Text = custdataset.Tables[0].Rows[0]["PONO"].ToString();
// CreatedDate.Text = custdataset.Tables[0].Rows[0]["CREATEDDATE"].ToString();
comboBox1.Text = custdataset.Tables[0].Rows[0]["STATE"].ToString();
//txtInvoice.Text = custdataset.Tables[0].Rows[0]["INVOICENO"].ToString();
//ddlTransaction.Text = custdataset.Tables[0].Rows[0]["InvoiceType"].ToString();
// tbTransportValue.Text = custdataset.Tables[0].Rows[0]["TRANSPORT"].ToString();
}
FillDescriptionsWithContent(custname);
//dataAdapter1.Dispose();
//cmd1.Dispose();
//con.Close();
}
private void FillDescriptionsWithContent(string custname)
{
FillDescriptions(custname);
txtDescription1.AutoCompleteMode = AutoCompleteMode.Suggest;
txtDescription1.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtDescription1.AutoCompleteCustomSource = descriptionCollection;
txtDescription2.AutoCompleteMode = AutoCompleteMode.Suggest;
txtDescription2.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtDescription2.AutoCompleteCustomSource = descriptionCollection;
txtDescription3.AutoCompleteMode = AutoCompleteMode.Suggest;
txtDescription3.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtDescription3.AutoCompleteCustomSource = descriptionCollection;
txtDescription4.AutoCompleteMode = AutoCompleteMode.Suggest;
txtDescription4.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtDescription4.AutoCompleteCustomSource = descriptionCollection;
txtDescription5.AutoCompleteMode = AutoCompleteMode.Suggest;
txtDescription5.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtDescription5.AutoCompleteCustomSource = descriptionCollection;
txtDescription6.AutoCompleteMode = AutoCompleteMode.Suggest;
txtDescription6.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtDescription6.AutoCompleteCustomSource = descriptionCollection;
txtDescription7.AutoCompleteMode = AutoCompleteMode.Suggest;
txtDescription7.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtDescription7.AutoCompleteCustomSource = descriptionCollection;
txtDescription8.AutoCompleteMode = AutoCompleteMode.Suggest;
txtDescription8.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtDescription8.AutoCompleteCustomSource = descriptionCollection;
txtDescription9.AutoCompleteMode = AutoCompleteMode.Suggest;
txtDescription9.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtDescription9.AutoCompleteCustomSource = descriptionCollection;
txtDescription10.AutoCompleteMode = AutoCompleteMode.Suggest;
txtDescription10.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtDescription10.AutoCompleteCustomSource = descriptionCollection;
txtDescription11.AutoCompleteMode = AutoCompleteMode.Suggest;
txtDescription11.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtDescription11.AutoCompleteCustomSource = descriptionCollection;
txtDescription12.AutoCompleteMode = AutoCompleteMode.Suggest;
txtDescription12.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtDescription12.AutoCompleteCustomSource = descriptionCollection;
txtDescription13.AutoCompleteMode = AutoCompleteMode.Suggest;
txtDescription13.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtDescription13.AutoCompleteCustomSource = descriptionCollection;
txtDescription14.AutoCompleteMode = AutoCompleteMode.Suggest;
txtDescription14.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtDescription14.AutoCompleteCustomSource = descriptionCollection;
txtDescription15.AutoCompleteMode = AutoCompleteMode.Suggest;
txtDescription15.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtDescription15.AutoCompleteCustomSource = descriptionCollection;
txtDescription16.AutoCompleteMode = AutoCompleteMode.Suggest;
txtDescription16.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtDescription16.AutoCompleteCustomSource = descriptionCollection;
txtDescription17.AutoCompleteMode = AutoCompleteMode.Suggest;
txtDescription17.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtDescription17.AutoCompleteCustomSource = descriptionCollection;
txtDescription18.AutoCompleteMode = AutoCompleteMode.Suggest;
txtDescription18.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtDescription18.AutoCompleteCustomSource = descriptionCollection;
txtDescription19.AutoCompleteMode = AutoCompleteMode.Suggest;
txtDescription19.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtDescription19.AutoCompleteCustomSource = descriptionCollection;
}
private void txtDescription1_KeyPress(object sender, KeyPressEventArgs e)
{
string custname = txtCustName.Text;
}
private void txtVAT_TextChanged(object sender, EventArgs e)
{
TextBox txtVAT = (TextBox)sender;
string txtName = txtVAT.Name.Replace("txtVAT", "");
GetAndCalculateTotal(txtName);
}
private void txtInvoice_TextChanged(object sender, EventArgs e)
{
//int returnProductId = 0;
//string connstring = ConfigurationManager.AppSettings["FilePath"].ToString();
//string invoicenum = "SELECT CUSTOMERNAME FROM TAXINVOICE where INVOICENO=" + txtInvoice.Text.ToString() + "";
//OleDbConnection oledinvoicenum = new OleDbConnection(connstring);
////OleDbConnection c2 = new OleDbConnection(co);
//if (oledinvoicenum.State == ConnectionState.Open)
//{
// oledinvoicenum.Close();
//}
//oledinvoicenum.Open();
//OleDbCommand oledbproductcmd = new OleDbCommand(invoicenum, oledinvoicenum);
//object obj = oledbproductcmd.ExecuteScalar();
//if (obj != null)
//{
// if(!String.IsNullOrEmpty(obj.ToString()))
// {
// MessageBox.Show("InvoiceNo Already Exists");
// txtInvoice.Text = "";
// }
//}
}
private void txtInvoice_Leave(object sender, EventArgs e)
{
if (!String.IsNullOrEmpty(txtInvoice.Text.Trim()))
{
string connstring = ConfigurationManager.AppSettings["FilePath"].ToString();
string invoicenum = "SELECT CUSTOMERNAME FROM TAXINVOICE where INVOICENO=" + txtInvoice.Text.ToString() + "";
OleDbConnection oledinvoicenum = new OleDbConnection(connstring);
//OleDbConnection c2 = new OleDbConnection(co);
if (oledinvoicenum.State == ConnectionState.Open)
{
oledinvoicenum.Close();
}
oledinvoicenum.Open();
OleDbCommand oledbproductcmd = new OleDbCommand(invoicenum, oledinvoicenum);
object obj = oledbproductcmd.ExecuteScalar();
if (obj != null)
{
if (!String.IsNullOrEmpty(obj.ToString()))
{
MessageBox.Show("InvoiceNo Already Exists");
txtInvoice.Text = "";
}
}
}
}
private void TAXINVOICE_FormClosing(object sender, FormClosingEventArgs e)
{
Application.Exit();
}
private void txtCustName_TextChanged(object sender, EventArgs e)
{
}
private void txtAddress1_TextChanged(object sender, EventArgs e)
{
}
private void txtGrossAmt1_TextChanged(object sender, EventArgs e)
{
}
private void txtTotalGrossAmt_TextChanged(object sender, EventArgs e)
{
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
if (comboBox1.SelectedItem == "VAT SALES")
{
ddlTransaction.Text = "CREDIT INVOICE";
}
else
{
ddlTransaction.Text = "CREDIT INVOICE / CST SALES";
}
}
}
}推荐答案
You are already getting the Max number in the Id column and adding 1 to id. So get the Maximum Date on the table and compare it to the system date. If the system date falls into the following financial year then reset the counter.
Note to other members: I am not advocating this method of incrementing the id.就是这样。 See also Invoice no should starting with 1 for every finacial year[^]
You are already getting the Max number in the Id column and adding 1 to id. So get the Maximum Date on the table and compare it to the system date. If the system date falls into the following financial year then reset the counter.
Note to other members: I am not advocating this method of incrementing the id. It is what it is. See also Invoice no should starting with 1 for every finacial year[^]
这篇关于每个财政年度，发票号码应以1开头的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
