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