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