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