using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Text; using System.Data.SqlClient; using System.IO; using System.Web.Mail; using System.Collections.Specialized; public partial class DomHost_CreateQuotation : System.Web.UI.Page { SqlConnection Con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["connectionstring"].ConnectionString); SqlDataAdapter sda = null; Double total = 0; static string Code; static string id; static Double cstcal; protected void codeFunc() { DateTime dt = DateTime.Now; string mon = dt.Month.ToString(); string year = dt.Year.ToString(); Con.Open(); string yearfin = "select financialyear from tbl_Financialyear where year='" + year + "'"; SqlDataAdapter sdyear = new SqlDataAdapter(yearfin, Con); DataSet dsyear = new DataSet(); DataTable dtyear = new DataTable(); sdyear.Fill(dsyear, "year"); dtyear = dsyear.Tables[0]; string yr = dtyear.Rows[0]["financialyear"].ToString(); Con.Close(); Con.Open(); string CmpNM; if (trClientDP.Visible == true) { CmpNM = ddlClient.SelectedItem.Text; } else { CmpNM = txtClient.Text; } string[] dtSplit = CmpNM.Split(' '); //string strShortNM = dtSplit[0] + dtSplit[1] ; string st1 = dtSplit[0].Substring(0, 1).ToUpper(); int count= dtSplit.Length; string st2=""; if (count >= 2) { st2 = dtSplit[1].Substring(0, 1).ToUpper(); } else { st1 = dtSplit[0].Substring(0, 2).ToUpper(); } string strShortNM = st1 + st2; string str1 = "select top 1 ID from Quotation order by ID desc"; SqlCommand cmd = new SqlCommand(str1, Con); string Cid = Convert.ToString(cmd.ExecuteScalar()); if (Cid != "") { string str2 = "select ident_current('MstQuotation') + 1"; SqlCommand cmd1 = new SqlCommand(str2, Con); string Cid1 = Convert.ToString(cmd1.ExecuteScalar()); Code = "QUO/" + strShortNM + "/" + yr + "/" + Cid1.ToString(); } else { Code = "QUO/" + strShortNM + "/" + yr + "/" + 1; } Session["Cd"] = Code; Con.Close(); } protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { SetInitialRow(); Button2.Visible = false; lbltot.Text = "0.00"; lblnet.Text = "0.00"; Label15.Visible = false; btngetnettotal.Visible = false; FillClient(); //Binddrop(); paymode(); } Button1.Visible = false; Label1.Visible = false; Label15.Visible = false; } void paymode() { string mode = "select PayMode from PaymentMode"; if (Con.State == ConnectionState.Closed) { Con.Open(); } sda = new SqlDataAdapter(mode, Con); DataTable dtmode = new DataTable(); sda.Fill(dtmode); rdoDeliveryMode.DataSource = dtmode; rdoDeliveryMode.DataTextField = "PayMode"; rdoDeliveryMode.DataBind(); } void FillClient() { try { Con.Open(); sda = new SqlDataAdapter("select id,ClientName from tbl_ClientMaster", Con); DataTable dt = new DataTable(); sda.Fill(dt); if (dt.Rows.Count > 0) { ddlClient.DataSource = dt; ddlClient.DataTextField = dt.Columns["ClientName"].ToString(); ddlClient.DataValueField = dt.Columns["id"].ToString(); ddlClient.DataBind(); ddlClient.Items.Insert(0, "--Select--"); } } catch (Exception ex) { Label15.Visible = true; Label15.Text = "Contact to Admin : " + ex.Message.ToString(); } finally { Con.Close(); } } protected void ddlClient_SelectedIndexChanged(object sender, EventArgs e) { Con.Open(); string add = "select Id,Address from tbl_ClientMaster where id='" + ddlClient.SelectedValue + "'"; SqlDataAdapter sd = new SqlDataAdapter(add, Con); DataSet dsadd = new DataSet(); DataTable dtadd = new DataTable(); sd.Fill(dsadd, "address"); dtadd = dsadd.Tables[0]; id = dtadd.Rows[0]["Id"].ToString(); txtaddress.Text = dtadd.Rows[0]["Address"].ToString(); Con.Close(); } private void SetInitialRow() { DataTable dt = new DataTable(); DataRow dr = null; dt.Columns.Add(new DataColumn("RowNumber", typeof(string))); dt.Columns.Add(new DataColumn("Column1", typeof(string))); dt.Columns.Add(new DataColumn("Column2", typeof(string))); dt.Columns.Add(new DataColumn("Column3", typeof(string))); dt.Columns.Add(new DataColumn("Column4", typeof(string))); dt.Columns.Add(new DataColumn("Column5", typeof(string))); dt.Columns.Add(new DataColumn("Column6", typeof(string))); dr = dt.NewRow(); dr["RowNumber"] = 1; dr["Column1"] = string.Empty; dr["Column2"] = string.Empty; dr["Column3"] = string.Empty; dr["Column4"] = string.Empty; dr["Column5"] = string.Empty; dr["Column6"] = string.Empty; dt.Rows.Add(dr); //Store the DataTable in ViewState ViewState["CurrentTable"] = dt; Gridview1.DataSource = dt; Gridview1.DataBind(); } public void AddNewRowToGrid() { int rowIndex = 0; if (ViewState["CurrentTable1"] == null) { if (ViewState["CurrentTable"] != null) { DataTable dtCurrentTable = (DataTable)ViewState["CurrentTable"]; DataRow drCurrentRow = null; if (dtCurrentTable.Rows.Count > 0) { for (int i = 1; i <= dtCurrentTable.Rows.Count; i++) { //extract the TextBox values TextBox box2 = (TextBox)Gridview1.Rows[rowIndex].Cells[1].FindControl("TextBox2"); TextBox txtremarks = (TextBox)Gridview1.Rows[rowIndex].Cells[2].FindControl("txtremarks"); DropDownList drp = (DropDownList)Gridview1.Rows[rowIndex].Cells[3].FindControl("DropDownList1"); TextBox box3 = (TextBox)Gridview1.Rows[rowIndex].Cells[4].FindControl("TextBox3"); TextBox box4 = (TextBox)Gridview1.Rows[rowIndex].Cells[5].FindControl("TextBox4"); TextBox lblamount = (TextBox)Gridview1.Rows[rowIndex].Cells[6].FindControl("TextBox7"); drCurrentRow = dtCurrentTable.NewRow(); drCurrentRow["RowNumber"] = i + 1; drCurrentRow["Column1"] = box2.Text; drCurrentRow["Column2"] = txtremarks.Text; drCurrentRow["Column3"] = drp.Text; drCurrentRow["Column4"] = box3.Text; drCurrentRow["Column5"] = box4.Text; drCurrentRow["Column6"] = lblamount.Text; rowIndex++; } dtCurrentTable.Rows.Add(drCurrentRow); ViewState["CurrentTable"] = dtCurrentTable; Gridview1.DataSource = dtCurrentTable; Gridview1.DataBind(); } } else { Response.Write("ViewState is null"); } //Set Previous Data on Postbacks SetPreviousData(); } else { if (ViewState["CurrentTable1"] != null) { DataTable dtCurrentTable = (DataTable)ViewState["CurrentTable1"]; DataRow drCurrentRow = null; if (dtCurrentTable.Rows.Count > 0) { dtCurrentTable.Clear(); DataRow drCurrentRow1 = dtCurrentTable.NewRow(); drCurrentRow1["RowNumber"] = 1; drCurrentRow1["Column1"] = string.Empty; drCurrentRow1["Column2"] = string.Empty; drCurrentRow1["Column3"] = string.Empty; drCurrentRow1["Column4"] = string.Empty; ; dtCurrentTable.Rows.Add(drCurrentRow1); for (int i = 0; i <= Gridview1.Rows.Count - 1; i++) { TextBox box2 = (TextBox)Gridview1.Rows[rowIndex].Cells[1].FindControl("TextBox2"); TextBox txtremarks = (TextBox)Gridview1.Rows[rowIndex].Cells[2].FindControl("txtremarks"); DropDownList drp = (DropDownList)Gridview1.Rows[rowIndex].Cells[3].FindControl("DropDownList1"); TextBox box3 = (TextBox)Gridview1.Rows[rowIndex].Cells[4].FindControl("TextBox3"); TextBox box4 = (TextBox)Gridview1.Rows[rowIndex].Cells[5].FindControl("TextBox4"); TextBox lblamount = (TextBox)Gridview1.Rows[rowIndex].Cells[6].FindControl("TextBox7"); drCurrentRow = dtCurrentTable.NewRow(); drCurrentRow["RowNumber"] = i + 1; drCurrentRow["Column1"] = box2.Text; drCurrentRow["Column2"] = txtremarks.Text; drCurrentRow["Column3"] = drp.Text; drCurrentRow["Column4"] = box3.Text; drCurrentRow["Column5"] = box4.Text; drCurrentRow["Column6"] = lblamount.Text; dtCurrentTable.Rows.Add(drCurrentRow); rowIndex++; } ViewState["CurrentTable"] = dtCurrentTable; Gridview1.DataSource = dtCurrentTable; Gridview1.DataBind(); } } else { Response.Write("ViewState is null"); } //Set Previous Data on Postbacks SetPreviousData(); } } protected void OnText_ChangedQty(object sender, EventArgs e) { Label15.Visible = false; Calculation(); int rowIndex = Gridview1.Rows.Count - 1; TextBox box4 = (TextBox)Gridview1.Rows[rowIndex].Cells[5].FindControl("TextBox4"); SetFocus(box4); } //on text change of description protected void TextBox2_TextChanged(object sender, EventArgs e) { int rowIndex = Gridview1.Rows.Count - 1; TextBox box3 = (TextBox)Gridview1.Rows[rowIndex].Cells[5].FindControl("TextBox2"); SetFocus(box3); } protected void OnText_ChangedRate(object sender, EventArgs e) { Label15.Visible = false; Calculation(); } public void Calculation() { try { Double rate, qty, per; Double amount; int rowIndex = 0; if (ViewState["CurrentTable"] != null) { DataTable dtCurrentTable = (DataTable)ViewState["CurrentTable"]; for (int k = 0; k < dtCurrentTable.Rows.Count; k++) { if (dtCurrentTable.Rows[k].ItemArray[1].ToString() == "Select") { dtCurrentTable.Rows.Remove(dtCurrentTable.Rows[k]); } } if (dtCurrentTable.Rows.Count > 0) { for (int i = 1; i <= dtCurrentTable.Rows.Count; i++) { //extract the TextBox values TextBox box2 = (TextBox)Gridview1.Rows[rowIndex].Cells[1].FindControl("TextBox2"); TextBox txtremarks = (TextBox)Gridview1.Rows[rowIndex].Cells[2].FindControl("txtremarks"); DropDownList drp = (DropDownList)Gridview1.Rows[rowIndex].Cells[3].FindControl("DropDownList1"); TextBox box3 = (TextBox)Gridview1.Rows[rowIndex].Cells[4].FindControl("TextBox3"); TextBox box4 = (TextBox)Gridview1.Rows[rowIndex].Cells[5].FindControl("TextBox4"); if (box3.Text == "") { qty = 0; } else { qty = Convert.ToDouble(box3.Text); } if (box4.Text == "") { rate = 0; } else { rate = Convert.ToDouble(box4.Text); } if (rate == 0) { amount = 0; } else { Double Cal = rate; amount = Convert.ToDouble(qty * Cal); } //TextBox lblamount = new TextBox(); TextBox lblamount = (TextBox)Gridview1.Rows[rowIndex].Cells[6].FindControl("TextBox7"); double tot = Math.Round(amount, 2); lblamount.Text = tot.ToString(); string a = Convert.ToString(amount); if (!a.Contains(".")) { lblamount.Text = a + ".00"; } total = total + tot; double tot1 = Math.Round(total, 2); lbltotal.Text = tot1.ToString(); string t = Convert.ToString(tot1); if (!t.Contains(".")) { lbltotal.Text = t + ".00"; } rowIndex++; } } } } catch (Exception exx) { Label15.Visible = true; Label15.Text = "Invalid Data"; } } private void SetPreviousData() { int rowIndex = 0; if (ViewState["CurrentTable"] != null) { DataTable dt = (DataTable)ViewState["CurrentTable"]; if (dt.Rows.Count > 0) { for (int i = 1; i < dt.Rows.Count; i++) { TextBox box2 = (TextBox)Gridview1.Rows[rowIndex].Cells[1].FindControl("TextBox2"); TextBox txtremarks = (TextBox)Gridview1.Rows[rowIndex].Cells[2].FindControl("txtremarks"); DropDownList drp = (DropDownList)Gridview1.Rows[rowIndex].Cells[3].FindControl("DropDownList1"); TextBox box3 = (TextBox)Gridview1.Rows[rowIndex].Cells[4].FindControl("TextBox3"); TextBox box4 = (TextBox)Gridview1.Rows[rowIndex].Cells[5].FindControl("TextBox4"); TextBox lblamount = (TextBox)Gridview1.Rows[rowIndex].Cells[6].FindControl("TextBox7"); box2.Text = dt.Rows[i]["Column1"].ToString(); txtremarks.Text = dt.Rows[i]["Column2"].ToString(); drp.Text = dt.Rows[i]["Column3"].ToString(); box3.Text = dt.Rows[i]["Column4"].ToString(); box4.Text = dt.Rows[i]["Column5"].ToString(); lblamount.Text = dt.Rows[i]["Column6"].ToString(); rowIndex++; } } //Binddrop(); } } private void SetPreviousData1() { int rowIndex = 0; if (ViewState["CurrentTable1"] != null) { DataTable dt = (DataTable)ViewState["CurrentTable1"]; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { TextBox box2 = (TextBox)Gridview1.Rows[rowIndex].Cells[1].FindControl("TextBox2"); TextBox txtremarks = (TextBox)Gridview1.Rows[rowIndex].Cells[2].FindControl("txtremarks"); DropDownList drp = (DropDownList)Gridview1.Rows[rowIndex].Cells[3].FindControl("DropDownList1"); TextBox box3 = (TextBox)Gridview1.Rows[rowIndex].Cells[4].FindControl("TextBox3"); TextBox box4 = (TextBox)Gridview1.Rows[rowIndex].Cells[5].FindControl("TextBox4"); TextBox lblamount = (TextBox)Gridview1.Rows[rowIndex].Cells[6].FindControl("TextBox7"); box2.Text = dt.Rows[i]["Column1"].ToString(); txtremarks.Text = dt.Rows[i]["Column2"].ToString(); drp.Text = dt.Rows[i]["Column3"].ToString(); box3.Text = dt.Rows[i]["Column4"].ToString(); box4.Text = dt.Rows[i]["Column5"].ToString(); lblamount.Text = dt.Rows[i]["Column6"].ToString(); rowIndex++; } } //Binddrop(); } } private void SetPreviousData2() { int rowIndex = 0; if (ViewState["CurrentTable"] != null) { DataTable dt = (DataTable)ViewState["CurrentTable"]; if (dt.Rows.Count > 0) { for (int i = 1; i < dt.Rows.Count - 1; i++) { TextBox box2 = (TextBox)Gridview1.Rows[rowIndex].Cells[1].FindControl("TextBox2"); TextBox txtremarks = (TextBox)Gridview1.Rows[rowIndex].Cells[2].FindControl("txtremarks"); DropDownList drp = (DropDownList)Gridview1.Rows[rowIndex].Cells[3].FindControl("DropDownList1"); TextBox box3 = (TextBox)Gridview1.Rows[rowIndex].Cells[4].FindControl("TextBox3"); TextBox box4 = (TextBox)Gridview1.Rows[rowIndex].Cells[5].FindControl("TextBox4"); TextBox lblamount = (TextBox)Gridview1.Rows[rowIndex].Cells[6].FindControl("TextBox7"); box2.Text = dt.Rows[i]["Column1"].ToString(); txtremarks.Text = dt.Rows[i]["Column2"].ToString(); drp.Text = dt.Rows[i]["Column3"].ToString(); box3.Text = dt.Rows[i]["Column4"].ToString(); box4.Text = dt.Rows[i]["Column5"].ToString(); lblamount.Text = dt.Rows[i]["Column6"].ToString(); rowIndex++; } } //Binddrop(); } } protected void ImageAdd_Click(object sender, EventArgs e) { if (!Page.IsValid) { return; } AddNewRowToGrid(); } protected void Button1_Click(object sender, EventArgs e) { if (!Page.IsValid) { return; } codeFunc(); StringCollection sc = new StringCollection(); if (ViewState["CurrentTable"] != null) { DataTable dtCurrentTable = (DataTable)ViewState["CurrentTable"]; if (dtCurrentTable.Rows.Count > 0) { for (int i = 0; i < Gridview1.Rows.Count; i++) { //extract the TextBox values TextBox box2 = (TextBox)Gridview1.Rows[i].Cells[1].FindControl("TextBox2"); TextBox txtremarks = (TextBox)Gridview1.Rows[i].Cells[2].FindControl("txtremarks"); DropDownList drp = (DropDownList)Gridview1.Rows[i].Cells[3].FindControl("DropDownList1"); TextBox box3 = (TextBox)Gridview1.Rows[i].Cells[4].FindControl("TextBox3"); TextBox box4 = (TextBox)Gridview1.Rows[i].Cells[5].FindControl("TextBox4"); TextBox lblamount = (TextBox)Gridview1.Rows[i].Cells[6].FindControl("TextBox7"); //get the values from the TextBoxes //then add it to the collections with a comma "," as the delimited values sc.Add(box2.Text + "," + txtremarks.Text + "," + drp.SelectedItem.Text + "," + box3.Text + "," + box4.Text + "," + lblamount.Text + "," + Code); } if (lblnet.Text == "") { lblnet.Text = lbltot.Text; } //Call the method for executing inserts InsertRecords(sc); Button1.Visible = false; Button2.Visible = true; btngetnettotal.Visible = false; btntotalamount.Visible = false; Label1.Visible = true; Button2.Attributes.Add("onclick", "javascript:OpenfSecondOrd('" + Code + "')"); } } } //A method that returns a string which calls the connection string from the web.config private string GetConnectionString() { return System.Configuration.ConfigurationManager.ConnectionStrings["Invoice"].ConnectionString; } //A method that Inserts the records to the database private void InsertRecords(StringCollection sc) { Con.Open(); StringBuilder sb = new StringBuilder(string.Empty); string[] splitItems = null; foreach (string item in sc) { const string sqlStatement = "INSERT INTO Quotation (Description,Remarks,Unit,Quantity,RatePer,Amount,ID) VALUES"; if (item.Contains(",")) { splitItems = item.Split(",".ToCharArray()); sb.AppendFormat("{0}('{1}','{2}','{3}','{4}','{5}','{6}','{7}'); ", sqlStatement, splitItems[0], splitItems[1], splitItems[2], splitItems[3], splitItems[4], splitItems[5], Code); } } try { string str1 = txtDate.Text; string[] dtSplit = str1.Split('/'); string storedate = dtSplit[1] + "/" + dtSplit[0] + "/" + dtSplit[2]; SqlCommand cmd = new SqlCommand(sb.ToString(), Con); cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); string ClientName; if (trClientDP.Visible == true) { ClientName = ddlClient.SelectedItem.Text; } else { ClientName = txtClient.Text; } string StrIn1 = "insert into MstQuotation (QOID,ClientName,Address,Total,CSTcalc,CST,NetTotal,Rsinword,PaymentTerms,DeliveryMode,Date) values ('" + Code + "','" + ClientName + "','" + txtaddress.Text + "' ,'" + lbltot.Text + "','" + lblcstcals.Text + "','" + txtvat.Text + "','" + lblnet.Text + "','" + txtrsword.Text + "','" + txtPayment.Text + "','" + rdoDeliveryMode.SelectedItem.Text + "','" + storedate + "')"; SqlCommand cmdmstso = new SqlCommand(StrIn1, Con); cmdmstso.ExecuteNonQuery(); } catch (System.Data.SqlClient.SqlException ex) { string msg = "Insert Error:"; msg += ex.Message; Label15.Visible = true; Label15.Text = msg; // throw new Exception(msg); } finally { Con.Close(); } } // Hide the Remove Button at the last row of the GridView protected void Gridview1_RowCreated(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { DataTable dt = (DataTable)ViewState["CurrentTable"]; ImageButton lb = (ImageButton)e.Row.FindControl("ImageButton1"); if (lb != null) { if (dt.Rows.Count > 1) { if (e.Row.RowIndex == dt.Rows.Count - 1) { lb.Visible = true; } } else { lb.Visible = true; } } } } // CODE FOR REMOVE// protected void ImageButton1_Click(object sender, EventArgs e) { if (Gridview1.Rows.Count > 1) { DataSet ds1 = new DataSet(); DataTable dt1 = new DataTable(); DataTable dtCurrentTable = (DataTable)ViewState["CurrentTable"]; int count = 0; count = Gridview1.Rows.Count - 1; //extract the TextBox values TextBox box2 = (TextBox)Gridview1.Rows[count].Cells[1].FindControl("TextBox2"); TextBox txtremarks = (TextBox)Gridview1.Rows[count].Cells[2].FindControl("txtremarks"); DropDownList drp = (DropDownList)Gridview1.Rows[count].Cells[3].FindControl("DropDownList1"); TextBox box3 = (TextBox)Gridview1.Rows[count].Cells[4].FindControl("TextBox3"); TextBox box4 = (TextBox)Gridview1.Rows[count].Cells[5].FindControl("TextBox4"); TextBox lblamount = (TextBox)Gridview1.Rows[count].Cells[6].FindControl("TextBox7"); if ((dtCurrentTable.Rows[dtCurrentTable.Rows.Count - 1].ItemArray[2].ToString() != box2.Text) && (dtCurrentTable.Rows[dtCurrentTable.Rows.Count - 1].ItemArray[3].ToString() != txtremarks.Text) && (dtCurrentTable.Rows[dtCurrentTable.Rows.Count - 1].ItemArray[4].ToString() != box3.Text)) { DataRow drCurrentRow = dtCurrentTable.NewRow(); drCurrentRow["RowNumber"] = ""; drCurrentRow["Column1"] = box2.Text; drCurrentRow["Column2"] = txtremarks.Text; drCurrentRow["Column3"] = drp.Text; drCurrentRow["Column4"] = box3.Text; drCurrentRow["Column5"] = box4.Text; drCurrentRow["Column6"] = lblamount.Text; dtCurrentTable.Rows.Add(drCurrentRow); ViewState["CurrentTable"] = dtCurrentTable; } ImageButton lb = (ImageButton)sender; GridViewRow gvRow = (GridViewRow)lb.NamingContainer; int rowID = gvRow.RowIndex + 1; if (ViewState["CurrentTable"] != null) { DataTable dt = (DataTable)ViewState["CurrentTable"]; if ((dt.Rows.Count > 1) && (lbltot.Text != "0.00")) { if (gvRow.RowIndex < dt.Rows.Count - 1) { if (dt.Rows[rowID].ItemArray[6].ToString() != "") { Double reamount = Convert.ToDouble(dt.Rows[rowID].ItemArray[6].ToString()); Double delamount = double.Parse(lbltot.Text) - reamount; lbltot.Text = delamount.ToString(); if (!lbltot.Text.Contains(".")) { lbltot.Text = lbltot.Text + ".00"; } //Remove the Selected Row data dt.Rows.Remove(dt.Rows[rowID]); dt1 = null; dt1 = dt.Copy(); dt1.Rows.Remove(dt1.Rows[0]); Gridview1.DataSource = dt1; Gridview1.DataBind(); } else { dt.Rows.Remove(dt.Rows[rowID]); dt1 = null; dt1 = dt.Copy(); dt1.Rows.Remove(dt1.Rows[0]); if (dt1.Rows[dt1.Rows.Count - 1].ItemArray[1].ToString() == "") { dt1.Rows.Remove(dt1.Rows[dt1.Rows.Count - 1]); } Gridview1.DataSource = dt1; Gridview1.DataBind(); } } } else if (lbltot.Text == "0.00") { dt.Rows.Remove(dt.Rows[rowID]); dt1 = null; dt1 = dt.Copy(); dt1.Rows.Remove(dt1.Rows[0]); } //Store the current data in ViewState for future reference ViewState["CurrentTable1"] = dt1; //Re bind the GridView for the updated data Gridview1.DataSource = dt1; Gridview1.DataBind(); } SetPreviousData1(); } else { Label15.Visible = true; Label15.Text = "Can not Remove"; } } //FOR NET-TOTAL CALCULATION// protected void btngetnettotal_Click(object sender, EventArgs e) { Button1.Visible = true; Double price = Convert.ToDouble(lbltot.Text); Double vat = Convert.ToDouble(txtvat.Text); Double nettotal = 0; if (vat == 0) { nettotal = price; cstcal = price * (vat / 100); lblcstcals.Text = cstcal.ToString(); } else { nettotal = price + ((price * (vat / 100))); cstcal = price * (vat / 100); lblcstcals.Text = cstcal.ToString(); } double ash = Math.Round(nettotal, 2); int test = Convert.ToInt32(ash); string b = ash.ToString("F2"); if (!b.Contains(".")) { lblnet.Text = b + ".00"; } else { lblnet.Text = ash.ToString("F2"); } string NumCalc = lblnet.Text; string[] dtSplitCalc = NumCalc.Split('.'); string NumCalc1 = dtSplitCalc[0]; string NumCalc2 = dtSplitCalc[1]; if (Convert.ToInt32(NumCalc2) == 00) { txtrsword.Text = ConvertNumberToWord(Convert.ToInt32(NumCalc1)) + " Rupees Only "; } else { txtrsword.Text = ConvertNumberToWord(Convert.ToInt32(NumCalc1)) + " Rupees " + ConvertNumberToWord(Convert.ToInt32(NumCalc2)) + " Paise" + " Only "; } } private string ConvertNumberToWord(int nNumber) { int CurrentNumber = nNumber; string sReturn = ""; if (CurrentNumber >= 10000000) { sReturn = sReturn + " " + GetWord(CurrentNumber / 10000000, "Crores"); CurrentNumber = CurrentNumber % 10000000; } if (CurrentNumber >= 100000) { sReturn = sReturn + " " + GetWord(CurrentNumber / 100000, "Lakhs"); CurrentNumber = CurrentNumber % 100000; } if (CurrentNumber >= 1000) { sReturn = sReturn + " " + GetWord(CurrentNumber / 1000, "Thousand"); CurrentNumber = CurrentNumber % 1000; } if (CurrentNumber >= 100) { sReturn = sReturn + " " + GetWord(CurrentNumber / 100, "Hundred"); CurrentNumber = CurrentNumber % 100; } if (CurrentNumber >= 20) { sReturn = sReturn + " " + GetWord(CurrentNumber, ""); CurrentNumber = CurrentNumber % 10; } else if (CurrentNumber > 0) { sReturn = sReturn + " " + GetWord(CurrentNumber, ""); CurrentNumber = 0; } return sReturn.Replace(" ", " ").Trim(); } private string GetWord(int nNumber, string sPrefix) { int nCurrentNumber = nNumber; string sReturn = ""; while (nCurrentNumber > 0) { if (nCurrentNumber > 100) { sReturn = sReturn + " " + GetWord(nCurrentNumber / 100, "Hundred"); nCurrentNumber = nCurrentNumber % 100; } else if (nCurrentNumber >= 20) { sReturn = sReturn + " " + GetTwentyWord(nCurrentNumber / 10); nCurrentNumber = nCurrentNumber % 10; } else { sReturn = sReturn + " " + GetLessThanTwentyWord(nCurrentNumber); nCurrentNumber = 0; } } sReturn = sReturn + " " + sPrefix; return sReturn; } private string GetTwentyWord(int nNumber) { string sReturn = ""; switch (nNumber) { case 2: sReturn = "Twenty"; break; case 3: sReturn = "Thirty"; break; case 4: sReturn = "Forty"; break; case 5: sReturn = "Fifty"; break; case 6: sReturn = "Sixty"; break; case 7: sReturn = "Seventy"; break; case 8: sReturn = "Eighty"; break; case 9: sReturn = "Ninety"; break; } return sReturn; } private string GetLessThanTwentyWord(int nNumber) { string sReturn = ""; switch (nNumber) { case 1: sReturn = "One"; break; case 2: sReturn = "Two"; break; case 3: sReturn = "Three"; break; case 4: sReturn = "Four"; break; case 5: sReturn = "Five"; break; case 6: sReturn = "Six"; break; case 7: sReturn = "Seven"; break; case 8: sReturn = "Eight"; break; case 9: sReturn = "Nine"; break; case 10: sReturn = "Ten"; break; case 11: sReturn = "Eleven"; break; case 12: sReturn = "Twelve"; break; case 13: sReturn = "Thirteen"; break; case 14: sReturn = "Forteen"; break; case 15: sReturn = "Fifteen"; break; case 16: sReturn = "Sixteen"; break; case 17: sReturn = "Seventeen"; break; case 18: sReturn = "Eighteen"; break; case 19: sReturn = "Nineteen"; break; } return sReturn; } protected void btntotalamount_Click(object sender, EventArgs e) { btngetnettotal.Visible = true; double amttot = 0; for (int i = 0; i < Gridview1.Rows.Count; i++) { TextBox lblamount = (TextBox)Gridview1.Rows[i].Cells[6].FindControl("TextBox7"); amttot = amttot + Convert.ToDouble(lblamount.Text); } double tot5 = Math.Round(amttot, 2); lbltot.Text = tot5.ToString(); string at = Convert.ToString(amttot); if (!at.Contains(".")) { lbltot.Text = at + ".00"; } } protected void Binddrop() { for (int i = 0; i < Gridview1.Rows.Count; i++) { Con.Open(); string product1 = "select Unit from tbl_UnitMst"; SqlDataAdapter DataAdpt = new SqlDataAdapter(product1, Con); DataAdpt.SelectCommand.CommandType = CommandType.Text; DataSet ds1 = new DataSet(); DataAdpt.Fill(ds1, "drop"); if (ds1.Tables[0].Rows.Count > 0) { DropDownList ddl = (DropDownList)Gridview1.Rows[i].Controls[0].FindControl("DropDownList1"); ddl.DataSource = ds1.Tables[0]; ddl.DataTextField = "Unit"; ddl.DataValueField = "Unit"; ddl.DataBind(); ddl.Items.Insert(0, "Select"); } else { Label15.Visible = true; Label15.Text = "Records/Products Not Found"; } Con.Close(); } } protected void lnkNew_Click(object sender, EventArgs e) { txtaddress.ReadOnly=false; trClientDP.Visible = false; trClient.Visible = true; } }