protected void upd_btn_Click(object sender, EventArgs e) { con.Open(); //SqlCommand cmd = new SqlCommand("vendor_proc", con); //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@action", "update"); //cmd.Parameters.AddWithValue("@pk_id", Label_id.Text); //cmd.Parameters.AddWithValue("@name", Text_name.Text); //cmd.Parameters.AddWithValue("@contact_no", Text_contact.Text); //cmd.Parameters.AddWithValue("@email", Text_email.Text); //cmd.Parameters.AddWithValue("@address", Text_address.Text); //cmd.ExecuteNonQuery(); library.libservice obj = new library.libservice(); int a = obj.vendorupdate(Convert.ToInt32(Label_id.Text), Text_name.Text, Text_contact.Text, Text_email.Text, Text_address.Text); if (a > 0) { gridshow(); blank(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Data Updated!!!!');", true); submit_btn.Visible = true; upd_btn.Visible = false; clear_btn.Visible = false; } con.Close(); }
protected void upd_btn_Click(object sender, EventArgs e) { con.Open(); //SqlCommand cmd = new SqlCommand("add_book_proc", con); //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@action", "update"); //cmd.Parameters.AddWithValue("@book_id", Label_id.Text); //cmd.Parameters.AddWithValue("@book_name", Text_bname.Text); //cmd.Parameters.AddWithValue("@book_category", Bookcategory_ddl.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@subtitle", Text_subtitle.Text); //cmd.Parameters.AddWithValue("@isbn_no", Lbl_isbn.Text); //cmd.Parameters.AddWithValue("@author", Text_author.Text); //cmd.Parameters.AddWithValue("@cupboard", Cupboard_ddl.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@cupboard_self", Cupboard_self.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@edition", Text_edition.Text); //cmd.Parameters.AddWithValue("@publisher", Text_publisher.Text); //cmd.Parameters.AddWithValue("@book_cost", Text_bookcost.Text); //cmd.Parameters.AddWithValue("@book_vendor", Bookvendor_ddl.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@copy", Text_copy.Text); //cmd.Parameters.AddWithValue("@Remarks", Text_remarks.Text); //cmd.Parameters.AddWithValue("@ASN_no", Text_asnno.Text); //cmd.ExecuteNonQuery(); library.libservice obj = new library.libservice(); int a = obj.addbookupdate(Convert.ToInt32(Label_id.Text), Text_bname.Text, Bookcategory_ddl.SelectedItem.ToString(), Text_subtitle.Text, Lbl_isbn.Text, Text_author.Text, Cupboard_ddl.SelectedItem.ToString(), Cupboard_self.SelectedItem.ToString(), Text_edition.Text, Text_publisher.Text, Text_bookcost.Text, Bookvendor_ddl.SelectedItem.ToString(), Text_copy.Text, Text_remarks.Text, Text_asnno.Text); if (a > 0) { gridshow(); blank(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Data Updated!!!!');", true); string barCode = Text_asnno.Text; System.Web.UI.WebControls.Image imgBarCode = new System.Web.UI.WebControls.Image(); using (Bitmap bitMap = new Bitmap(barCode.Length * 40, 80)) { using (Graphics graphics = Graphics.FromImage(bitMap)) { Font oFont = new Font("IDAutomationHC39M", 16); PointF point = new PointF(2f, 2f); SolidBrush blackBrush = new SolidBrush(Color.Black); SolidBrush whiteBrush = new SolidBrush(Color.White); graphics.FillRectangle(whiteBrush, 0, 0, bitMap.Width, bitMap.Height); graphics.DrawString("*" + barCode + "*", oFont, blackBrush, point); } using (MemoryStream ms = new MemoryStream()) { bitMap.Save(ms, System.Drawing.Imaging.ImageFormat.Png); byte[] byteImage = ms.ToArray(); Convert.ToBase64String(byteImage); imgBarCode.ImageUrl = "data:image/png;base64," + Convert.ToBase64String(byteImage); } plBarCode.Controls.Add(imgBarCode); } clear_btn.Visible = false; submit_btn.Visible = true; upd_btn.Visible = false; } con.Close(); }
protected void upd_btn_Click(object sender, EventArgs e) { con.Open(); //SqlCommand cmd = new SqlCommand("librarycard_generate_proc", con); //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@action", "update"); //cmd.Parameters.AddWithValue("@pk_id", Label_id.Text); //cmd.Parameters.AddWithValue("@card_no", Text_cardno.Text); //cmd.Parameters.AddWithValue("@type", DropDown_holder.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@id", Text_id.Text); //cmd.Parameters.AddWithValue("@name", Text_name.Text); //cmd.Parameters.AddWithValue("@batch", Text_batch.Text); //cmd.Parameters.AddWithValue("@class", Text_class.Text); //cmd.Parameters.AddWithValue("@section", Text_section.Text); //cmd.Parameters.AddWithValue("@stream", Text_stream.Text); //cmd.Parameters.AddWithValue("@roll", Text_roll.Text); //cmd.Parameters.AddWithValue("@father_name", Text_father.Text); //cmd.Parameters.AddWithValue("@mobile", Text_mobile.Text); //cmd.Parameters.AddWithValue("@address1", Text_address.Text); //cmd.ExecuteNonQuery(); library.libservice obj = new library.libservice(); int a = obj.update(Convert.ToInt32(Label_id.Text), Text_cardno.Text, DropDown_holder.SelectedItem.ToString(), Text_id.Text, Text_name.Text, Text_batch.Text, Text_class.Text, Text_section.Text, Text_stream.Text, Text_roll.Text, Text_father.Text, Text_mobile.Text, Text_address.Text); if (a > 0) { gridshow(); blank(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Data Updated!!!!');", true); } submit_btn.Visible = true; upd_btn.Visible = false; Export_excel.Visible = false; con.Close(); }
protected void bookissue_click(object sender, EventArgs e) { con.Open(); if (holder_ddl.SelectedItem.ToString() == "Student") { //SqlCommand cmd = new SqlCommand("insert into issue_book values('" + Text_isbn.Text + "','" + Text_bname.Text + "','" + Text_bookcategory.Text + "','" + Text_subtitle.Text + "','" + Text_author.Text + "','" + Text_cupboard.Text + "','" + Text_cupboard_self.Text + "','" + Text_edition.Text + "','" + Text_publisher.Text + "','" + //Text_bookcost.Text + "','" + Text_vendor.Text + "','" + Text_copy.Text + "','" + holder_ddl.SelectedItem.ToString() + "','" + Text_cardno.Text + "' //,'" + Text_batch.Text + "','" + Text_class.Text + "','" + Text_section.Text + "','" + Text_stream.Text + "','" + Text_roll.Text+ "','" + Text_holdername.Text + "','" + Text_hname.Text + "','" + Text_issuedate.Text + "')", con); //cmd.ExecuteNonQuery(); library.libservice obj = new library.libservice(); int a = obj.issuebookinsert(Text_isbn.Text, Text_bname.Text, Text_bookcategory.Text, Text_subtitle.Text, Text_author.Text, Text_cupboard.Text, Text_cupboard_self.Text, Text_edition.Text, Text_publisher.Text, Text_bookcost.Text, Text_vendor.Text, Text_copy.Text, holder_ddl.SelectedItem.ToString(), Text_cardno.Text, Text_batch.Text, Text_class.Text, Text_section.Text, Text_stream.Text, Text_roll.Text, Text_holdername.Text, Text_hname.Text, Text_issuedate.Text); if (a > 0) { SqlDataAdapter da = new SqlDataAdapter("select * from add_books where isbn_no='" + Text_isbn.Text + "'", con); DataTable dt = new DataTable(); da.Fill(dt); double current_qty = double.Parse(dt.Rows[0]["copy"].ToString()); double qty = double.Parse(Text_copy.Text); double now_qty = (current_qty - qty); SqlCommand cmd1 = new SqlCommand("update add_books set copy='" + now_qty + "' where author='" + Text_author.Text + "' and book_name='" + Text_bname.Text + "'", con); cmd1.ExecuteNonQuery(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Book Issue Successfully!!!!');", true); shows(); blank(); } } else if (holder_ddl.SelectedItem.ToString() == "Employee") { //SqlCommand cmd = new SqlCommand("insert into issue_book values('" + Text_isbn.Text + "','" + Text_bname.Text + "','" + Text_bookcategory.Text + "' //,'" + Text_subtitle.Text + "','" + Text_author.Text + "','" + Text_cupboard.Text + "','" + Text_cupboard_self.Text + "','" + Text_edition.Text + "', //'" + Text_publisher.Text + "','" + Text_bookcost.Text + "','" + Text_vendor.Text + "','" + Text_copy.Text + "','" + holder_ddl.SelectedItem.ToString() + "', //'" + Text_cardno.Text + "','','','','','','','" + Text_hname.Text + "','" + Text_issuedate.Text + "')", con); //cmd.ExecuteNonQuery(); library.libservice obj = new library.libservice(); int a = obj.issuebookinserts(Text_isbn.Text, Text_bname.Text, Text_bookcategory.Text, Text_subtitle.Text, Text_author.Text, Text_cupboard.Text, Text_cupboard_self.Text, Text_edition.Text, Text_publisher.Text, Text_bookcost.Text, Text_vendor.Text, Text_copy.Text, holder_ddl.SelectedItem.ToString(), Text_cardno.Text, "", "", "", "", "", "", Text_hname.Text, Text_issuedate.Text); SqlDataAdapter da = new SqlDataAdapter("select * from add_books where isbn_no='" + Text_isbn.Text + "'", con); DataTable dt = new DataTable(); da.Fill(dt); double current_qty = double.Parse(dt.Rows[0]["copy"].ToString()); double qty = double.Parse(Text_copy.Text); double now_qty = (current_qty - qty); SqlCommand cmd1 = new SqlCommand("update add_books set copy='" + now_qty + "' where author='" + Text_author.Text + "' and book_name='" + Text_bname.Text + "'", con); cmd1.ExecuteNonQuery(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Book Issue Successfully!!!!');", true); shows(); blank(); } con.Close(); }
public void gridshow() { //SqlDataAdapter da = new SqlDataAdapter("librarycard_generate_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); library.libservice obj = new library.libservice(); GridView1.DataSource = obj.show(); GridView1.DataBind(); }
protected void return_btn_Click(object sender, EventArgs e) { con.Open(); if (DropDownList1.SelectedItem.ToString() == "Student") { ////SqlCommand cmd = new SqlCommand("insert into return_book_data values( //'" + Text_isbn.Text + "','" + Text_bname.Text + "','" + Text_bookcategory.Text + "','" + Text_author.Text + "','" + Text_edition.Text + "','" + Text_vendor.Text + "','" + DropDownList1.SelectedItem.ToString() + "','" + Text_cardno.Text + "','" + Text_hname.Text + "','','" + Text_batch.Text + "','" + Text_class.Text + "','" + Text_section.Text + "','" + Text_roll.Text + "','" + Text_stream.Text + "','" + Text_copy.Text + "','" + Text_issuedate.Text + "','" + Text_return.Text + "','" + noofday_txt.Text + "','" + fine_txt.Text + "')", con); ////cmd.ExecuteNonQuery(); library.libservice obj = new library.libservice(); int a = obj.returnbookinsert(Text_isbn.Text, Text_bname.Text, Text_bookcategory.Text, Text_author.Text, Text_edition.Text, Text_vendor.Text, DropDownList1.SelectedItem.ToString(), Text_cardno.Text, Text_hname.Text, Text_batch.Text, Text_class.Text, Text_section.Text, Text_roll.Text, Text_stream.Text, Text_copy.Text, Text_issuedate.Text, Text_return.Text, noofday_txt.Text, fine_txt.Text); if (a > 0) { SqlDataAdapter da = new SqlDataAdapter("select * from add_books where isbn_no='" + Text_isbn.Text + "'", con); DataTable dt = new DataTable(); da.Fill(dt); double current_qty = double.Parse(dt.Rows[0]["copy"].ToString()); double qty = double.Parse(Text_copy.Text); double now_qty = (current_qty + qty); SqlCommand cmd1 = new SqlCommand("update add_books set copy='" + now_qty + "' where author='" + Text_author.Text + "' and book_name='" + Text_bname.Text + "'", con); cmd1.ExecuteNonQuery(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Book Returned Successfully!!!!');", true); blank(); } } else if (DropDownList1.SelectedItem.ToString() == "Employee") { //SqlCommand cmd = new SqlCommand("insert into return_book_data values('" + Text_isbn.Text + "','" + Text_bname.Text + "','" + Text_bookcategory.Text + "','" + Text_author.Text + "','" + Text_edition.Text + "','" + Text_vendor.Text + "','" + DropDownList1.SelectedItem.ToString() + "','"+Text_cardno.Text+"','" + Text_holdername.Text + "',',',',',',',',',',',',','"+Text_copy.Text+"','"+Text_issuedate.Text+"','" + Text_return.Text + "','" + noofday_txt.Text + "','" + fine_txt.Text + "')", con); //d.ExecuteNonQuery(); library.libservice obj = new library.libservice(); int a = obj.returnbookinsert(Text_isbn.Text, Text_bname.Text, Text_bookcategory.Text, Text_author.Text, Text_edition.Text, Text_vendor.Text, DropDownList1.SelectedItem.ToString(), Text_cardno.Text, Text_holdername.Text, "", "", "", "", "", Text_copy.Text, Text_issuedate.Text, Text_return.Text, noofday_txt.Text, fine_txt.Text); if (a > 0) { SqlDataAdapter da = new SqlDataAdapter("select * from add_books where isbn_no='" + Text_isbn.Text + "'", con); DataTable dt = new DataTable(); da.Fill(dt); double current_qty = double.Parse(dt.Rows[0]["copy"].ToString()); double qty = double.Parse(Text_copy.Text); double now_qty = (current_qty + qty); SqlCommand cmd1 = new SqlCommand("update add_books set copy='" + now_qty + "' where author='" + Text_author.Text + "' and book_name='" + Text_bname.Text + "'", con); cmd1.ExecuteNonQuery(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Book Returned Successfully!!!!');", true); blank(); } } con.Close(); }
protected void submit_btn_Click(object sender, EventArgs e) { con.Open(); //SqlCommand cmd1 = new SqlCommand("select * from vendor where name='" + Text_name.Text + "'and email='" + Text_email.Text + "' ", con); SqlCommand cmd1 = new SqlCommand("vendor_proc", con); cmd1.CommandType = CommandType.StoredProcedure; cmd1.Parameters.AddWithValue("@action", "exist"); cmd1.Parameters.AddWithValue("@pk_id", ""); cmd1.Parameters.AddWithValue("@name", Text_name.Text); cmd1.Parameters.AddWithValue("@contact_no", ""); cmd1.Parameters.AddWithValue("@email", Text_email.Text); cmd1.Parameters.AddWithValue("@address", ""); cmd1.ExecuteNonQuery(); SqlDataReader dr = cmd1.ExecuteReader(); if (dr.Read()) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Record Already Exist!!!!');", true); dr.Close(); } else { dr.Close(); //SqlCommand cmd = new SqlCommand("vendor_proc", con); //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@action", "insert"); //cmd.Parameters.AddWithValue("@pk_id", ""); //cmd.Parameters.AddWithValue("@name", Text_name.Text); //cmd.Parameters.AddWithValue("@contact_no", Text_contact.Text); //cmd.Parameters.AddWithValue("@email", Text_email.Text); //cmd.Parameters.AddWithValue("@address", Text_address.Text); //cmd.ExecuteNonQuery(); library.libservice obj = new library.libservice(); int a = obj.vendorinsert(Text_name.Text, Text_contact.Text, Text_email.Text, Text_address.Text); if (a > 0) { gridshow(); blank(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Data Submit!!!!');", true); } } 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_books_proc", con); //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@action", "delete"); //cmd.Parameters.AddWithValue("@book_id", l1.Text); //cmd.ExecuteNonQuery(); library.libservice obj = new library.libservice(); int a = obj.addbookdelete(Convert.ToInt32(l1.Text)); if (a > 0) { gridshow(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Data Deleted!!!!');", true); } }
protected void submit_btn_Click(object sender, EventArgs e) { con.Open(); //SqlCommand cmd = new SqlCommand("librarycard_generate_proc", con); //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@action", "insert"); //cmd.Parameters.AddWithValue("@pk_id", ""); Random ran = new Random(); int i = ran.Next(1, 9); int j = i * 45678; string Card = "14" + j; //cmd.Parameters.AddWithValue("@card_no", Card); //cmd.Parameters.AddWithValue("@type", DropDown_holder.SelectedItem.ToString()); //cmd.Parameters.AddWithValue("@id", Text_id.Text); //cmd.Parameters.AddWithValue("@name", Text_name.Text); //cmd.Parameters.AddWithValue("@batch", Text_batch.Text); //cmd.Parameters.AddWithValue("@class", Text_class.Text); //cmd.Parameters.AddWithValue("@section", Text_section.Text); //cmd.Parameters.AddWithValue("@stream", Text_stream.Text); //cmd.Parameters.AddWithValue("@roll", Text_roll.Text); //cmd.Parameters.AddWithValue("@father_name", Text_father.Text); //cmd.Parameters.AddWithValue("@mobile", Text_mobile.Text); //cmd.Parameters.AddWithValue("@address1", Text_address.Text); library.libservice obj = new library.libservice(); int a = obj.insert(Card, DropDown_holder.SelectedItem.ToString(), Text_id.Text, Text_name.Text, Text_batch.Text, Text_class.Text, Text_section.Text, Text_stream.Text, Text_roll.Text, Text_father.Text, Text_mobile.Text, Text_address.Text); if (a > 0) { //cmd.ExecuteNonQuery(); gridshow(); blank(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "test", "alert('Data Submit!!!!');", true); } }
public void gridshow() { library.libservice obj = new library.libservice(); GridView1.DataSource = obj.addbookshow(); GridView1.DataBind(); }