private void BindCategories() { DailyConsumption daily = new DailyConsumption(); DataTable dt = new DataTable(); dt = daily.GetCategories(); ddlcategory.DataSource = dt; ddlcategory.DataTextField = "categoryname"; ddlcategory.DataValueField = "categoryid"; ddlcategory.DataBind(); ddlcategory.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--Select--", "-1")); ddlmaterialcode.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--select--", "-1")); }
protected void ddlcategory_SelectedIndexChanged(object sender, EventArgs e) { string categoryname = ddlcategory.SelectedItem.ToString(); DailyConsumption dc = new DailyConsumption(); DataTable dt = new DataTable(); dt = dc.Getmaterialcode(categoryname); ddlmaterialcode.DataSource = dt; ddlmaterialcode.DataTextField = "Code"; ddlmaterialcode.DataValueField = "ID"; ddlmaterialcode.DataBind(); ddlmaterialcode.Items.Insert(0, new System.Web.UI.WebControls.ListItem("--select--", "-1")); }
protected void btn_Click(object sender, EventArgs e) { Class1 dailycon = new Class1(); if (dailycustomername.Text != "" && dailyrequiredquantity.Text != "") { DailyConsumption dc = new DailyConsumption(); DataTable dt = new DataTable(); string value = (Convert.ToDecimal(dailyavailablestock.Text) - Convert.ToDecimal(dailyrequiredquantity.Text)).ToString(); dailycon.dailyInsertdata(ddlmaterial.SelectedItem.ToString(), ddlcategory.SelectedItem.ToString(), dailymaterial.Text, dailysize.Text, dailysubcategory.Text, value, dailyminimumquantity.Text, dailydate.Text, dailycustomername.Text, dailyrequiredquantity.Text, dailypurpose.Text, dailyolddate.Text, dailyworkorder.Text, dailyusageid.Text); string choice = ddlcategory.SelectedItem.ToString(); switch (choice) { case "Hardware": string constr = ConfigurationManager.ConnectionStrings["starlinepackersConnectionString"].ConnectionString; using (SqlConnection con = new SqlConnection(constr)) { decimal data = decimal.Parse(value); using (SqlCommand cmd = new SqlCommand("update mhardware set htotalqty='" + data + "' where hmaterial='" + dailymaterial.Text + "'", con)) { cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); con.Close(); } } break; case "wood": string constr1 = ConfigurationManager.ConnectionStrings["starlinepackersConnectionString"].ConnectionString; using (SqlConnection con = new SqlConnection(constr1)) { decimal data = decimal.Parse(value); using (SqlCommand cmd = new SqlCommand("update mwood set mtotalqty ='" + data + "' where mmaterial='" + dailymaterial.Text + "'", con)) { cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); Gridview1.DataBind(); con.Close(); } } break; case "plywood": string constr2 = ConfigurationManager.ConnectionStrings["starlinepackersConnectionString"].ConnectionString; using (SqlConnection con = new SqlConnection(constr2)) { decimal data = decimal.Parse(value); using (SqlCommand cmd = new SqlCommand("update mplywood set ptotalqty ='" + data + "' where pmaterial='" + dailymaterial.Text + "'", con)) { cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); Gridview1.DataBind(); con.Close(); } } break; case "polythene": string constr3 = ConfigurationManager.ConnectionStrings["starlinepackersConnectionString"].ConnectionString; using (SqlConnection con = new SqlConnection(constr3)) { decimal data = decimal.Parse(value); using (SqlCommand cmd = new SqlCommand("update mpolythene set pototalqty ='" + data + "' where pomaterial='" + dailymaterial.Text + "'", con)) { cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); Gridview1.DataBind(); con.Close(); } } break; case "Paper Packing": string constr4 = ConfigurationManager.ConnectionStrings["starlinepackersConnectionString"].ConnectionString; using (SqlConnection con = new SqlConnection(constr4)) { decimal data = decimal.Parse(value); using (SqlCommand cmd = new SqlCommand("update mpaperpacking set patotalqty ='" + data + "' where pamaterial='" + dailymaterial.Text + "'", con)) { cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); Gridview1.DataBind(); con.Close(); } } break; case "Packaging material": string constr5 = ConfigurationManager.ConnectionStrings["starlinepackersConnectionString"].ConnectionString; using (SqlConnection con = new SqlConnection(constr5)) { decimal data = decimal.Parse(value); using (SqlCommand cmd = new SqlCommand("update mpackingmaterial set pactotalqty ='" + data + "' where pacmaterial='" + dailymaterial.Text + "'", con)) { cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); Gridview1.DataBind(); con.Close(); } } break; case "Steel": string constr6 = ConfigurationManager.ConnectionStrings["starlinepackersConnectionString"].ConnectionString; using (SqlConnection con = new SqlConnection(constr6)) { decimal data = decimal.Parse(value); using (SqlCommand cmd = new SqlCommand("update msteel set sttotalqty ='" + data + "' where stmaterial='" + dailymaterial.Text + "'", con)) { cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); Gridview1.DataBind(); con.Close(); } } break; case "Tools": string constr7 = ConfigurationManager.ConnectionStrings["starlinepackersConnectionString"].ConnectionString; using (SqlConnection con = new SqlConnection(constr7)) { decimal data = decimal.Parse(value); using (SqlCommand cmd = new SqlCommand("update mtools set ttotalqty ='" + data + "' where tmaterial='" + dailymaterial.Text + "'", con)) { cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); Gridview1.DataBind(); con.Close(); } } break; case "Miscellaneous": string constr8 = ConfigurationManager.ConnectionStrings["starlinepackersConnectionString"].ConnectionString; using (SqlConnection con = new SqlConnection(constr8)) { decimal data = decimal.Parse(value); using (SqlCommand cmd = new SqlCommand("update mmiscellaneous set mistotalqty ='" + data + "' where mismaterial='" + dailymaterial.Text + "'", con)) { cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); Gridview1.DataBind(); con.Close(); } } break; default: break; } Reset(); } else { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert(' Please Enter The Required Fields')", true); } CustomerentryAutoGenerateCode(); }
protected void ddlmaterial_SelectedIndexChanged(object sender, EventArgs e) { Class1 dailycon = new Class1(); DailyConsumption dc = new DailyConsumption(); DataTable dt = new DataTable(); dt = dc.Getmaterialdetails(ddlmaterial.SelectedItem.ToString().Split('(')[0].Trim(), ddlcategory.SelectedItem.ToString()); string value = ddlcategory.SelectedItem.ToString(); if (dt.Rows.Count > 0) { switch (value) { case "Hardware": ddailycategory.Text = dt.Rows[0]["hcategory"].ToString(); dailyavailablestock.Text = dt.Rows[0]["htotalqty"].ToString(); dailysubcategory.Text = dt.Rows[0]["hsubcategory"].ToString(); dailysize.Text = dt.Rows[0]["hsize"].ToString(); dailyminimumquantity.Text = dt.Rows[0]["hminimum"].ToString(); dailymaterial.Text = dt.Rows[0]["hmaterial"].ToString(); break; case "wood": ddailycategory.Text = dt.Rows[0]["mcategory"].ToString(); dailyavailablestock.Text = dt.Rows[0]["mtotalqty"].ToString(); dailysubcategory.Text = dt.Rows[0]["msubcategory"].ToString(); dailysize.Text = dt.Rows[0]["msize"].ToString(); dailyminimumquantity.Text = dt.Rows[0]["mminimum"].ToString(); dailymaterial.Text = dt.Rows[0]["mmaterial"].ToString(); break; case "plywood": ddailycategory.Text = dt.Rows[0]["pcategory"].ToString(); dailyavailablestock.Text = dt.Rows[0]["ptotalqty"].ToString(); dailysubcategory.Text = dt.Rows[0]["psubcategory"].ToString(); dailysize.Text = dt.Rows[0]["psize"].ToString(); dailyminimumquantity.Text = dt.Rows[0]["pminimum"].ToString(); dailymaterial.Text = dt.Rows[0]["pmaterial"].ToString(); break; case "polythene": ddailycategory.Text = dt.Rows[0]["pocategory"].ToString(); dailyavailablestock.Text = dt.Rows[0]["pototalqty"].ToString(); dailysubcategory.Text = dt.Rows[0]["posubcategory"].ToString(); dailysize.Text = dt.Rows[0]["posize"].ToString(); dailyminimumquantity.Text = dt.Rows[0]["pominimum"].ToString(); dailymaterial.Text = dt.Rows[0]["pomaterial"].ToString(); break; case "Paper Packing": ddailycategory.Text = dt.Rows[0]["pacategory"].ToString(); dailyavailablestock.Text = dt.Rows[0]["patotalqty"].ToString(); dailysubcategory.Text = dt.Rows[0]["pasubcategory"].ToString(); dailysize.Text = dt.Rows[0]["pasize"].ToString(); dailyminimumquantity.Text = dt.Rows[0]["paminimum"].ToString(); dailymaterial.Text = dt.Rows[0]["pamaterial"].ToString(); break; case "Packaging material": ddailycategory.Text = dt.Rows[0]["paccategory"].ToString(); dailyavailablestock.Text = dt.Rows[0]["pactotalqty"].ToString(); dailysubcategory.Text = dt.Rows[0]["pacsubcategory"].ToString(); dailysize.Text = dt.Rows[0]["pacsize"].ToString(); dailyminimumquantity.Text = dt.Rows[0]["pacminimum"].ToString(); dailymaterial.Text = dt.Rows[0]["pacmaterial"].ToString(); break; case "Steel": ddailycategory.Text = dt.Rows[0]["stcategory"].ToString(); dailyavailablestock.Text = dt.Rows[0]["sttotalqty"].ToString(); dailysubcategory.Text = dt.Rows[0]["stsubcategory"].ToString(); dailysize.Text = dt.Rows[0]["stsize"].ToString(); dailyminimumquantity.Text = dt.Rows[0]["stminimum"].ToString(); dailymaterial.Text = dt.Rows[0]["stmaterial"].ToString(); break; case "Tools": ddailycategory.Text = dt.Rows[0]["tcategory"].ToString(); dailyavailablestock.Text = dt.Rows[0]["ttotalqty"].ToString(); dailysubcategory.Text = dt.Rows[0]["tsubcategory"].ToString(); dailysize.Text = dt.Rows[0]["tsize"].ToString(); dailyminimumquantity.Text = dt.Rows[0]["tminimum"].ToString(); dailymaterial.Text = dt.Rows[0]["tmaterial"].ToString(); break; case "Miscellaneous": ddailycategory.Text = dt.Rows[0]["miscategory"].ToString(); dailyavailablestock.Text = dt.Rows[0]["mistotalqty"].ToString(); dailysubcategory.Text = dt.Rows[0]["missubcategory"].ToString(); dailysize.Text = dt.Rows[0]["missize"].ToString(); dailyminimumquantity.Text = dt.Rows[0]["misminimum"].ToString(); dailymaterial.Text = dt.Rows[0]["mismaterial"].ToString(); break; default: ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert(' Material code not exists')", true); break; } } }
protected void btn_Click(object sender, EventArgs e) { Class1 dailycon = new Class1(); if (txtmaterialname.Text != "" && txtaccept.Text != "") { DailyConsumption dc = new DailyConsumption(); DataTable dt = new DataTable(); string value = (Convert.ToDecimal(txtavailablestock.Text) + Convert.ToDecimal(txtaccept.Text)).ToString(); string choice = ddlcategory.SelectedItem.ToString(); switch (choice) { case "Hardware": string constr = ConfigurationManager.ConnectionStrings["starlinepackersConnectionString"].ConnectionString; using (SqlConnection con = new SqlConnection(constr)) { decimal data = decimal.Parse(value); using (SqlCommand cmd = new SqlCommand("update mhardware set htotalqty='" + data + "' where hmaterial='" + txtmaterialname.Text + "'", con)) { cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); con.Close(); } } break; case "wood": string constr1 = ConfigurationManager.ConnectionStrings["starlinepackersConnectionString"].ConnectionString; using (SqlConnection con = new SqlConnection(constr1)) { decimal data = decimal.Parse(value); using (SqlCommand cmd = new SqlCommand("update mwood set mtotalqty ='" + data + "' where mmaterial='" + txtmaterialname.Text + "'", con)) { cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); con.Close(); } } break; case "plywood": string constr2 = ConfigurationManager.ConnectionStrings["starlinepackersConnectionString"].ConnectionString; using (SqlConnection con = new SqlConnection(constr2)) { decimal data = decimal.Parse(value); using (SqlCommand cmd = new SqlCommand("update mplywood set ptotalqty ='" + data + "' where pmaterial='" + txtmaterialname.Text + "'", con)) { cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); con.Close(); } } break; case "polythene": string constr3 = ConfigurationManager.ConnectionStrings["starlinepackersConnectionString"].ConnectionString; using (SqlConnection con = new SqlConnection(constr3)) { decimal data = decimal.Parse(value); using (SqlCommand cmd = new SqlCommand("update mpolythene set pototalqty ='" + data + "' where pomaterial='" + txtmaterialname.Text + "'", con)) { cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); con.Close(); } } break; case "Paper Packing": string constr4 = ConfigurationManager.ConnectionStrings["starlinepackersConnectionString"].ConnectionString; using (SqlConnection con = new SqlConnection(constr4)) { decimal data = decimal.Parse(value); using (SqlCommand cmd = new SqlCommand("update mpaperpacking set patotalqty ='" + data + "' where pamaterial='" + txtmaterialname.Text + "'", con)) { cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); con.Close(); } } break; case "Packaging material": string constr5 = ConfigurationManager.ConnectionStrings["starlinepackersConnectionString"].ConnectionString; using (SqlConnection con = new SqlConnection(constr5)) { decimal data = decimal.Parse(value); using (SqlCommand cmd = new SqlCommand("update mpackingmaterial set pactotalqty ='" + data + "' where pacmaterial='" + txtmaterialname.Text + "'", con)) { cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); con.Close(); } } break; case "Steel": string constr6 = ConfigurationManager.ConnectionStrings["starlinepackersConnectionString"].ConnectionString; using (SqlConnection con = new SqlConnection(constr6)) { decimal data = decimal.Parse(value); using (SqlCommand cmd = new SqlCommand("update msteel set sttotalqty ='" + data + "' where stmaterial='" + txtmaterialname.Text + "'", con)) { cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); con.Close(); } } break; case "Tools": string constr7 = ConfigurationManager.ConnectionStrings["starlinepackersConnectionString"].ConnectionString; using (SqlConnection con = new SqlConnection(constr7)) { decimal data = decimal.Parse(value); using (SqlCommand cmd = new SqlCommand("update mtools set ttotalqty ='" + data + "' where tmaterial='" + txtmaterialname.Text + "'", con)) { cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); con.Close(); } } break; case "Miscellaneous": string constr8 = ConfigurationManager.ConnectionStrings["starlinepackersConnectionString"].ConnectionString; using (SqlConnection con = new SqlConnection(constr8)) { decimal data = decimal.Parse(value); using (SqlCommand cmd = new SqlCommand("update mmiscellaneous set mistotalqty ='" + data + "' where mismaterial='" + txtmaterialname.Text + "'", con)) { cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); con.Close(); } } break; default: break; } } else { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert(' Please Enter The Required Fields')", true); } SqlConnection con2 = new SqlConnection(strCon); SqlCommand cmd2 = new SqlCommand("insert into grn (Date,Approved,Reject,Category,PurchaseOrder,MaterialCode,Quantity) values('" + txtdate.Text + "','" + txtaccept.Text + "','" + txtdamaged.Text + "','" + ddlcategory.SelectedItem.ToString() + "','" + ddlpurchaseorderid.SelectedItem.ToString() + "','" + ddlmaterialname.SelectedItem.ToString() + "','" + txtquantity.Text + "')", con2); con2.Open(); cmd2.ExecuteNonQuery(); con2.Close(); SqlConnection con1 = new SqlConnection(strCon); SqlCommand cmd1 = new SqlCommand("insert into Damage values('" + txtgrnid.Text + "','" + txtdate.Text + "','" + ddlpurchaseorderid.SelectedItem.ToString() + "','" + txtsuppliername.Text + "','" + ddlmaterialname.SelectedItem.ToString() + "','" + txtquantity.Text + "','" + txtaccept.Text + "','" + txtdamaged.Text + "')", con1); con1.Open(); cmd1.ExecuteNonQuery(); con1.Close(); int recentEnquiryId = GetRecentEnquiryId(); txtgrnid.Text = Convert.ToString(recentEnquiryId); ddlcategory.SelectedIndex = 0; ddlpurchaseorderid.SelectedIndex = 0; ddlmaterialname.SelectedIndex = 0; txtmaterialname.Text = ""; txtquantity.Text = ""; txtaccept.Text = ""; txtdamaged.Text = ""; gvbind(); }
protected void ddlmaterialname_SelectedIndexChanged(object sender, EventArgs e) { SqlConnection con = new SqlConnection(strCon); SqlCommand cmd = new SqlCommand("select Quantity from purchaseorderfinal where Material_name='" + ddlmaterialname.SelectedItem.ToString() + "' ", con); con.Open(); SqlDataReader myreader = cmd.ExecuteReader(); while (myreader.Read()) { txtquantity.Text = (myreader["Quantity"].ToString()); } con.Close(); Class1 dailycon = new Class1(); DailyConsumption dc = new DailyConsumption(); DataTable dt = new DataTable(); dt = dc.Getmaterialdetails(ddlmaterialname.SelectedItem.ToString().Split('(')[0].Trim(), ddlcategory.SelectedItem.ToString()); string value = ddlcategory.SelectedItem.ToString(); if (dt.Rows.Count > 0) { switch (value) { case "Hardware": txtmaterialname.Text = dt.Rows[0]["hmaterial"].ToString(); txtavailablestock.Text = dt.Rows[0]["htotalqty"].ToString(); break; case "wood": txtmaterialname.Text = dt.Rows[0]["mmaterial"].ToString(); txtavailablestock.Text = dt.Rows[0]["mtotalqty"].ToString(); break; case "plywood": txtmaterialname.Text = dt.Rows[0]["pmaterial"].ToString(); txtavailablestock.Text = dt.Rows[0]["ptotalqty"].ToString(); break; case "polythene": txtmaterialname.Text = dt.Rows[0]["pomaterial"].ToString(); txtavailablestock.Text = dt.Rows[0]["pototalqty"].ToString(); break; case "Paper Packing": txtmaterialname.Text = dt.Rows[0]["pamaterial"].ToString(); txtavailablestock.Text = dt.Rows[0]["patotalqty"].ToString(); break; case "Packaging material": txtmaterialname.Text = dt.Rows[0]["pacmaterial"].ToString(); txtavailablestock.Text = dt.Rows[0]["pactotalqty"].ToString(); break; case "Steel": txtmaterialname.Text = dt.Rows[0]["stmaterial"].ToString(); txtavailablestock.Text = dt.Rows[0]["sttotalqty"].ToString(); break; case "Tools": txtmaterialname.Text = dt.Rows[0]["tmaterial"].ToString(); txtavailablestock.Text = dt.Rows[0]["ttotalqty"].ToString(); break; case "Miscellaneous": txtmaterialname.Text = dt.Rows[0]["mismaterial"].ToString(); txtavailablestock.Text = dt.Rows[0]["mistotalqty"].ToString(); break; default: ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert(' Material code not exists')", true); break; } } }
protected void btn_Click(object sender, EventArgs e) { Class1 dailycon = new Class1(); if (returnmaterial.Text != "" && returnreturn.Text != "") { DailyConsumption dc = new DailyConsumption(); DataTable dt = new DataTable(); string value = (Convert.ToDecimal(returnavailablequantity.Text) + Convert.ToDecimal(returnreturn.Text)).ToString(); string choice = returncategory.Text; switch (choice) { case "Hardware": string constr = ConfigurationManager.ConnectionStrings["starlinepackersConnectionString"].ConnectionString; using (SqlConnection con = new SqlConnection(constr)) { decimal data = decimal.Parse(value); using (SqlCommand cmd = new SqlCommand("update mhardware set htotalqty='" + data + "' where hmaterial='" + returnmaterial.Text + "'", con)) { cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); con.Close(); } } break; case "wood": string constr1 = ConfigurationManager.ConnectionStrings["starlinepackersConnectionString"].ConnectionString; using (SqlConnection con = new SqlConnection(constr1)) { decimal data = decimal.Parse(value); using (SqlCommand cmd = new SqlCommand("update mwood set mtotalqty ='" + data + "' where mmaterial='" + returnmaterial.Text + "'", con)) { cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); Gridview1.DataBind(); con.Close(); } } break; case "plywood": string constr2 = ConfigurationManager.ConnectionStrings["starlinepackersConnectionString"].ConnectionString; using (SqlConnection con = new SqlConnection(constr2)) { decimal data = decimal.Parse(value); using (SqlCommand cmd = new SqlCommand("update mplywood set ptotalqty ='" + data + "' where pmaterial='" + returnmaterial.Text + "'", con)) { cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); Gridview1.DataBind(); con.Close(); } } break; case "polythene": string constr3 = ConfigurationManager.ConnectionStrings["starlinepackersConnectionString"].ConnectionString; using (SqlConnection con = new SqlConnection(constr3)) { decimal data = decimal.Parse(value); using (SqlCommand cmd = new SqlCommand("update mpolythene set pototalqty ='" + data + "' where pomaterial='" + returnmaterial.Text + "'", con)) { cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); Gridview1.DataBind(); con.Close(); } } break; case "Paper Packing": string constr4 = ConfigurationManager.ConnectionStrings["starlinepackersConnectionString"].ConnectionString; using (SqlConnection con = new SqlConnection(constr4)) { decimal data = decimal.Parse(value); using (SqlCommand cmd = new SqlCommand("update mpaperpacking set patotalqty ='" + data + "' where pamaterial='" + returnmaterial.Text + "'", con)) { cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); Gridview1.DataBind(); con.Close(); } } break; case "Packaging material": string constr5 = ConfigurationManager.ConnectionStrings["starlinepackersConnectionString"].ConnectionString; using (SqlConnection con = new SqlConnection(constr5)) { decimal data = decimal.Parse(value); using (SqlCommand cmd = new SqlCommand("update mpackingmaterial set pactotalqty ='" + data + "' where pacmaterial='" + returnmaterial.Text + "'", con)) { cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); Gridview1.DataBind(); con.Close(); } } break; case "Steel": string constr6 = ConfigurationManager.ConnectionStrings["starlinepackersConnectionString"].ConnectionString; using (SqlConnection con = new SqlConnection(constr6)) { decimal data = decimal.Parse(value); using (SqlCommand cmd = new SqlCommand("update msteel set sttotalqty ='" + data + "' where stmaterial='" + returnmaterial.Text + "'", con)) { cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); Gridview1.DataBind(); con.Close(); } } break; case "Tools": string constr7 = ConfigurationManager.ConnectionStrings["starlinepackersConnectionString"].ConnectionString; using (SqlConnection con = new SqlConnection(constr7)) { decimal data = decimal.Parse(value); using (SqlCommand cmd = new SqlCommand("update mtools set ttotalqty ='" + data + "' where tmaterial='" + returnmaterial.Text + "'", con)) { cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); Gridview1.DataBind(); con.Close(); } } break; case "Miscellaneous": string constr8 = ConfigurationManager.ConnectionStrings["starlinepackersConnectionString"].ConnectionString; using (SqlConnection con = new SqlConnection(constr8)) { decimal data = decimal.Parse(value); using (SqlCommand cmd = new SqlCommand("update mmiscellaneous set mistotalqty ='" + data + "' where mismaterial='" + returnmaterial.Text + "'", con)) { cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); Gridview1.DataBind(); con.Close(); } } break; default: break; } } else { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert(' Please Enter The Required Fields')", true); } string strCon = ConfigurationManager.ConnectionStrings["starlinepackersConnectionString"].ToString(); SqlConnection con1 = new SqlConnection(strCon); SqlCommand cmd1 = new SqlCommand("Insert into ReturnStock (DailyUsageId,Date,MaterialCode,Catgery,SubCatgery,Material,AvailbileQuty,Required,WorkOrder,EmployeeName,oldDate,[Return],Ename,Comment) values('" + ddluasgeid.SelectedItem.ToString() + "','" + returndate.Text + "','" + returnmaterialcode.Text + "','" + returncategory.Text + "','" + returnsubcategory.Text + "','" + returnmaterial.Text + "','" + returnavailablequantity.Text + "','" + returnrequired.Text + "','" + returnworkorder.Text + "','" + returnemployeename.Text + "','" + returnolddate.Text + "','" + returnreturn.Text + "','" + returnemployeenamee.Text + "','" + returnComment.Text + "')", con1); con1.Open(); cmd1.ExecuteNonQuery(); con1.Close(); }