protected void upd_btn_Click(object sender, EventArgs e)
{
con.Open();
//SqlCommand cmd = new SqlCommand("suplier_proc", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@action", "update");
//cmd.Parameters.AddWithValue("@pk_id", Label_id.Text);
//cmd.Parameters.AddWithValue("@name", Text_vendor_name.Text);
//cmd.Parameters.AddWithValue("@contact_person", Text_cperson.Text);
//cmd.Parameters.AddWithValue("@mobile", Text_Mobile.Text);
//cmd.Parameters.AddWithValue("@email", Text_email.Text);
//cmd.Parameters.AddWithValue("@tin_no", Text_tinno.Text);
//cmd.Parameters.AddWithValue("@adress", Text_address.Text);
//cmd.Parameters.AddWithValue("@description", Text_description.Text);
//cmd.ExecuteNonQuery();
inventry.inventserv obj = new inventry.inventserv();
int a = obj.addsupplierupdate(Convert.ToInt32(Label_id.Text), Text_vendor_name.Text, Text_cperson.Text, Text_Mobile.Text, Text_email.Text, Text_tinno.Text, Text_address.Text, Text_description.Text);
if (a > 0)
{
gridshow();
blank();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Data Updated!!!!');", true);
submit_btn.Visible = true;
upd_btn.Visible = false;
con.Close();
}
}
protected void submit_btn_Click(object sender, EventArgs e)
{
con.Open();
//SqlCommand cmd = new SqlCommand("insert into issue_items values('"+batch_ddl.SelectedItem.ToString()+"','"+class_ddl.SelectedItem.ToString()+"','"+section_dll.SelectedItem.ToString()+"','"+stream_ddl.SelectedItem.ToString()+"','"+roll_txt.Text+"','"+sname_txt.Text+"','"+code_txt.Text+"','"+itmname_txt.Text+"','"+worth_txt.Text+"')", con);
//cmd.ExecuteNonQuery();
inventry.inventserv obj = new inventry.inventserv();
int a = obj.issueiteminsert(batch_ddl.SelectedItem.ToString(), class_ddl.SelectedItem.ToString(), section_dll.SelectedItem.ToString(), stream_ddl.SelectedItem.ToString(), roll_txt.Text, sname_txt.Text, code_txt.Text, itmname_txt.Text, worth_txt.Text);
if (a > 0)
{
SqlCommand cmd1 = new SqlCommand("select * from add_item where item_code='" + code_txt.Text + "' and item_name='" + itmname_txt.Text + "'", con);
SqlDataReader dr = cmd1.ExecuteReader();
if (dr.Read())
{
lbl_stock.Text = dr["stock"].ToString();
}
dr.Close();
}
lbl_stock.Text = (Convert.ToInt32(lbl_stock.Text) - 1).ToString();
SqlCommand cmd2 = new SqlCommand("update add_item set stock='" + lbl_stock.Text + "' where item_code='" + code_txt.Text + "' and item_name='" + itmname_txt.Text + "'", con);
cmd2.ExecuteNonQuery();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Item Issued To Student Successfully!!!!');", true);
con.Close();
blank();
}
protected void submit_btn_Click(object sender, EventArgs e)
{
con.Open();
//SqlCommand cmd = new SqlCommand("add_item_proc", con);
// cmd.CommandType = CommandType.StoredProcedure;
// cmd.Parameters.AddWithValue("@action", "insert");
// cmd.Parameters.AddWithValue("@pk_id", "");
// cmd.Parameters.AddWithValue("@item_code", Text_itemcode.Text);
// cmd.Parameters.AddWithValue("@item_name", ddl_item.SelectedItem.ToString());
// cmd.Parameters.AddWithValue("@item_location", item_location_text.Text);
// cmd.Parameters.AddWithValue("@rate", rate_text.Text);
// cmd.Parameters.AddWithValue("@quantity", quantity_text.Text);
// cmd.Parameters.AddWithValue("@stock", stock_text.Text);
// cmd.Parameters.AddWithValue("@description", text_desc.Text);
// cmd.ExecuteNonQuery();
inventry.inventserv obj = new inventry.inventserv();
int a = obj.iteminsert(Text_itemcode.Text, ddl_item.SelectedItem.ToString(), item_location_text.Text, rate_text.Text, quantity_text.Text, stock_text.Text, text_desc.Text);
if (a > 0)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Data Submitted!!!!');", true);
gridshow();
blank();
}
con.Close();
}
public void gridshow()
{
//SqlDataAdapter da = new SqlDataAdapter("add_category_dlt_proc", con);
//da.SelectCommand.CommandType = CommandType.StoredProcedure;
//da.SelectCommand.Parameters.AddWithValue("@action", "show");
//da.SelectCommand.Parameters.AddWithValue("@pk_id", "");
//DataTable dt = new DataTable();
//da.Fill(dt);
inventry.inventserv obj = new inventry.inventserv();
GridView1.DataSource = obj.show();
GridView1.DataBind();
}
protected void submit_btn_Click(object sender, EventArgs e)
{
con.Open();
//SqlCommand com = new SqlCommand("select * from suplier_tbl where name='" + Text_vendor_name.Text + "' and email='" + Text_email.Text + "'", con);
SqlCommand com = new SqlCommand("suplier_proc", con);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@action", "supplrexist");
com.Parameters.AddWithValue("@pk_id", "");
com.Parameters.AddWithValue("@name", Text_vendor_name.Text);
com.Parameters.AddWithValue("@contact_person", "");
com.Parameters.AddWithValue("@mobile", "");
com.Parameters.AddWithValue("@email", Text_email.Text);
com.Parameters.AddWithValue("@tin_no", "");
com.Parameters.AddWithValue("@adress", "");
com.Parameters.AddWithValue("@description", "");
SqlDataReader dr = com.ExecuteReader();
if (dr.Read())
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Record Exist Already!!!!');", true);
}
else
{
dr.Close();
//SqlCommand cmd = new SqlCommand("suplier_proc", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@action", "insert");
//cmd.Parameters.AddWithValue("@pk_id", "");
//cmd.Parameters.AddWithValue("@name", Text_vendor_name.Text);
//cmd.Parameters.AddWithValue("@contact_person", Text_cperson.Text);
//cmd.Parameters.AddWithValue("@mobile", Text_Mobile.Text);
//cmd.Parameters.AddWithValue("@email", Text_email.Text);
//cmd.Parameters.AddWithValue("@tin_no", Text_tinno.Text);
//cmd.Parameters.AddWithValue("@adress", Text_address.Text);
//cmd.Parameters.AddWithValue("@description", Text_description.Text);
//cmd.ExecuteNonQuery();
inventry.inventserv obj = new inventry.inventserv();
int a = obj.addsupplierinsert(Text_vendor_name.Text, Text_cperson.Text, Text_Mobile.Text, Text_email.Text, Text_tinno.Text, Text_address.Text, Text_description.Text);
if (a > 0)
{
gridshow();
blank();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Thanks for Registration!!!!');", true);
}
con.Close();
}
}
protected void submit_btn_Click(object sender, EventArgs e)
{
con.Open();
//SqlCommand com = new SqlCommand("select * from add_category where category_name='" + Catname_txt.Text + "'and Description='"+Text_desc.Text+"'", con);
SqlCommand cmd1 = new SqlCommand("add_category_proc", con);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@action", "category");
cmd1.Parameters.AddWithValue("@pk_id", "");
cmd1.Parameters.AddWithValue("@category_name", Catname_txt.Text);
cmd1.Parameters.AddWithValue("@Description", Text_desc.Text);
SqlDataReader dr = cmd1.ExecuteReader();
if (dr.Read())
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Record Exist Already!!!!');", true);
blank();
dr.Close();
}
else
{
dr.Close();
//SqlCommand cmd = new SqlCommand("add_category_proc", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@action", "insert");
//cmd.Parameters.AddWithValue("@pk_id", "");
//cmd.Parameters.AddWithValue("@category_name", Catname_txt.Text);
//cmd.Parameters.AddWithValue("@Description", Text_desc.Text);
//cmd.ExecuteNonQuery();
inventry.inventserv obj = new inventry.inventserv();
int a = obj.insert(Catname_txt.Text, Text_desc.Text);
if (a > 0)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Data Submitted!!!!');", true);
gridshow();
blank();
}
}
con.Close();
}
protected void btn_delete_Click(object sender, EventArgs e)
{
con.Open();
LinkButton lnk = (LinkButton)sender;
GridViewRow row = (GridViewRow)lnk.NamingContainer;
Label l1 = (Label)row.FindControl("Lbl_id");
//SqlCommand cmd = new SqlCommand("add_category_dlt_proc", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@action", "delete");
//cmd.Parameters.AddWithValue("@pk_id", l1.Text);
//cmd.ExecuteNonQuery();
inventry.inventserv obj = new inventry.inventserv();
int a = obj.delete(Convert.ToInt32(l1.Text));
if (a > 0)
{
gridshow();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Data Deleted!!!!');", true);
}
con.Close();
}
protected void upd_btn_Click(object sender, EventArgs e)
{
con.Open();
//SqlCommand cmd = new SqlCommand("add_category_proc", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@action", "update");
//cmd.Parameters.AddWithValue("@pk_id", Label_id.Text);
//cmd.Parameters.AddWithValue("@category_name", Catname_txt.Text);
//cmd.Parameters.AddWithValue("@Description", Text_desc.Text);
//cmd.ExecuteNonQuery();
inventry.inventserv obj = new inventry.inventserv();
int a = obj.update(Convert.ToInt32(Label_id.Text), Catname_txt.Text, Text_desc.Text);
if (a > 0)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Data Updated!!!!');", true);
gridshow();
blank();
con.Close();
upd_btn.Visible = false;
submit_btn.Visible = true;
}
}
public void gridshow()
{
inventry.inventserv obj = new inventry.inventserv();
GridView1.DataSource = obj.addsuppliershow();
GridView1.DataBind();
}
