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