public void update_book(DBcontainer db) { SqlConnection con = dbcon.GetConnection(); con.Open(); SqlCommand cmd = dbcon.GetProcedure(con, "update_book"); cmd.Parameters.AddWithValue("@Book_ID", db.Book_id); cmd.Parameters.AddWithValue("@Book_Name", db.Book_name); cmd.Parameters.AddWithValue("@Page", db.Page_no); cmd.Parameters.AddWithValue("@Price", db.Price); cmd.Parameters.AddWithValue("@Edition", db.Edition); cmd.Parameters.AddWithValue("@Quantity", db.Quantity); cmd.Parameters.AddWithValue("@Avl_qty", db.Available_qt); cmd.Parameters.AddWithValue("@Entry_Date", db.Entry_date); cmd.Parameters.AddWithValue("@status", db.Book_status); cmd.Parameters.AddWithValue("@image_url", db.Citizenship); cmd.Parameters.AddWithValue("@category", db.Category); cmd.Parameters.AddWithValue("@Subject_ID", db.Subject_id); cmd.Parameters.AddWithValue("@Author_ID", db.Author_id); cmd.Parameters.AddWithValue("@Publication_ID", db.Publication_id); cmd.Parameters.AddWithValue("@bar_code", db.Barcode); cmd.Parameters.AddWithValue("@SM_ID", db.SM_ID1); cmd.ExecuteNonQuery(); }
public void delete_user(DBcontainer db) { SqlConnection con = dbcon.GetConnection(); con.Open(); SqlCommand cmd = dbcon.GetProcedure(con, "delete_user"); cmd.Parameters.AddWithValue("@user_id", db.User_id); cmd.ExecuteNonQuery(); }
public void save_department(DBcontainer db) { SqlConnection con = dbcon.GetConnection(); con.Open(); SqlCommand cmd = dbcon.GetProcedure(con, "save_department"); cmd.Parameters.AddWithValue("@Department_Name", db.Department_name); cmd.ExecuteNonQuery(); }
public void save_publication(DBcontainer db) { SqlConnection con = dbcon.GetConnection(); con.Open(); SqlCommand cmd = dbcon.GetProcedure(con, "save_publication"); cmd.Parameters.AddWithValue("@Publication_Name", db.Publication_name); cmd.ExecuteNonQuery(); }
public void delete_teacher(DBcontainer db) { DataTable dt = new DataTable(); SqlConnection con = dbcon.GetConnection(); con.Open(); SqlCommand cmd = dbcon.GetProcedure(con, "delete_teacher"); cmd.Parameters.AddWithValue("@Teacher_ID", db.Teacher_id); cmd.ExecuteNonQuery(); }
public void update_author(DBcontainer db) { SqlConnection con = dbcon.GetConnection(); con.Open(); SqlCommand cmd = dbcon.GetProcedure(con, "update_author"); cmd.Parameters.AddWithValue("@Author_ID", db.Author_id); cmd.Parameters.AddWithValue("@Author_Name", db.Author_name); cmd.ExecuteNonQuery(); }
public void update_subject(DBcontainer db) { SqlConnection con = dbcon.GetConnection(); con.Open(); SqlCommand cmd = dbcon.GetProcedure(con, "update_subject"); cmd.Parameters.AddWithValue("@Subject_ID", db.Subject_id); cmd.Parameters.AddWithValue("@Subject_Name", db.Subject_name); cmd.ExecuteNonQuery(); }
public void delete_issuedetail_byid_teacher(DBcontainer db) { SqlConnection con = dbcon.GetConnection(); con.Open(); SqlCommand cmd = dbcon.GetProcedure(con, "delete_issuedetail_byid_teacher"); cmd.Parameters.AddWithValue("@IDT_ID", db.Idt_id); //cmd.Parameters.AddWithValue("@IMT_ID", db.Imt_id); cmd.ExecuteNonQuery(); }
public void save_issuemaster_teacher(DBcontainer db) { SqlConnection con = dbcon.GetConnection(); con.Open(); SqlCommand cmd = dbcon.GetProcedure(con, "save_issuemaster_teacher"); cmd.Parameters.AddWithValue("@User_ID", db.User_id); cmd.Parameters.AddWithValue("@Teacher_ID", db.Teacher_id); cmd.ExecuteNonQuery(); }
public void save_returnmaster(DBcontainer db) { SqlConnection con = dbcon.GetConnection(); con.Open(); SqlCommand cmd = dbcon.GetProcedure(con, "save_returnmaster"); cmd.Parameters.AddWithValue("@_User_ID", db.User_id); cmd.Parameters.AddWithValue("@Student_ID", db.Student_id); cmd.ExecuteNonQuery(); }
public void save_subject_url(DBcontainer db) { SqlConnection con = dbcon.GetConnection(); con.Open(); SqlCommand cmd = dbcon.GetProcedure(con, "save_file_url"); cmd.Parameters.AddWithValue("@Subject_id", db.Subject_id); cmd.Parameters.AddWithValue("@Image_URL", db.Book_image_url); cmd.ExecuteNonQuery(); }
public void update_userpassword(DBcontainer db) { SqlConnection con = dbcon.GetConnection(); con.Open(); SqlCommand cmd = dbcon.GetProcedure(con, "update_userpassword"); cmd.Parameters.AddWithValue("@User_ID", db.User_id); cmd.Parameters.AddWithValue("@Password", db.Password); cmd.ExecuteNonQuery(); }
public void update_userverified(DBcontainer db) { DataTable dt = new DataTable(); SqlConnection con = dbcon.GetConnection(); con.Open(); SqlCommand cmd = dbcon.GetProcedure(con, "update_userverified"); cmd.Parameters.AddWithValue("@UV_ID", db.Verification_id); cmd.Parameters.AddWithValue("@verified", db.Authority); cmd.ExecuteNonQuery(); }
public void save_userverified(DBcontainer db) { SqlConnection con = dbcon.GetConnection(); con.Open(); SqlCommand cmd = dbcon.GetProcedure(con, "save_userverified"); cmd.Parameters.AddWithValue("@User_ID", db.User_id); cmd.Parameters.AddWithValue("@Code", db.Verification_code); cmd.Parameters.AddWithValue("@Verified", db.Authority); cmd.ExecuteNonQuery(); }
public DataTable edit_user(DBcontainer db) { DataTable dt = new DataTable(); SqlConnection con = dbcon.GetConnection(); con.Open(); SqlCommand cmd = dbcon.GetProcedure(con, "edit_user"); cmd.Parameters.AddWithValue("@_User_ID", db.User_id); dt = dbcon.GetDataTable(cmd); return(dt); }
public void update_session_Sbook(DBcontainer db) { DataTable dt = new DataTable(); SqlConnection con = dbcon.GetConnection(); con.Open(); SqlCommand cmd = dbcon.GetProcedure(con, "update_session_Sbook"); cmd.Parameters.AddWithValue("@Semester_ID", db.Semester_id); cmd.Parameters.AddWithValue("@book_student", db.Book_student); cmd.ExecuteNonQuery(); }
public DataTable bindissuedetails(DBcontainer db) { DataTable dt = new DataTable(); SqlConnection con = dbcon.GetConnection(); con.Open(); SqlCommand cmd = dbcon.GetProcedure(con, "get_issuemasterdetails"); cmd.ExecuteNonQuery(); dt = dbcon.GetDataTable(cmd); return(dt); }
public void update_bookstatus(DBcontainer db) { DataTable dt = new DataTable(); SqlConnection con = dbcon.GetConnection(); con.Open(); SqlCommand cmd = dbcon.GetProcedure(con, "update_bookstatus"); cmd.Parameters.AddWithValue("@Book_ID", db.Book_id); cmd.Parameters.AddWithValue("@status", db.Book_status); cmd.ExecuteNonQuery(); }
public void save_issuemasterhistory(DBcontainer db) { SqlConnection con = dbcon.GetConnection(); con.Open(); SqlCommand cmd = dbcon.GetProcedure(con, "save_issuemasterhistory"); cmd.Parameters.AddWithValue("@IM_ID", db.Im_ID); cmd.Parameters.AddWithValue("@User_ID", db.User_id); cmd.Parameters.AddWithValue("@Student_ID", db.Student_id); cmd.ExecuteNonQuery(); }
public DataTable bind_Avlbook(DBcontainer db) { DataTable dt = new DataTable(); SqlConnection con = dbcon.GetConnection(); con.Open(); SqlCommand cmd = dbcon.GetProcedure(con, "get_Avlbook"); cmd.ExecuteNonQuery(); dt = dbcon.GetDataTable(cmd); return(dt); }
public void pwchange_request(DBcontainer db) { SqlConnection con = dbcon.GetConnection(); con.Open(); SqlCommand cmd = dbcon.GetProcedure(con, "save_pw_reset"); cmd.Parameters.AddWithValue("@User_ID", db.User_id); cmd.Parameters.AddWithValue("@Code", db.Verification_code); cmd.Parameters.AddWithValue("@Verified", false); cmd.ExecuteNonQuery(); }
public void update_session_returndate(DBcontainer db) { DataTable dt = new DataTable(); SqlConnection con = dbcon.GetConnection(); con.Open(); SqlCommand cmd = dbcon.GetProcedure(con, "update_session_returndate"); cmd.Parameters.AddWithValue("@Semester_ID", db.Semester_id); cmd.Parameters.AddWithValue("@date_to", db.Date_to); cmd.ExecuteNonQuery(); }
public DataTable get_latestteacher(DBcontainer db) { DataTable dt = new DataTable(); SqlConnection con = dbcon.GetConnection(); con.Open(); SqlCommand cmd = dbcon.GetProcedure(con, "get_latestteacher"); cmd.ExecuteNonQuery(); dt = dbcon.GetDataTable(cmd); return(dt); }
public DataTable binddepartment(DBcontainer db) { DataTable dt = new DataTable(); SqlConnection con = dbcon.GetConnection(); con.Open(); SqlCommand cmd = dbcon.GetProcedure(con, "show_department"); cmd.ExecuteNonQuery(); dt = dbcon.GetDataTable(cmd); return(dt); }
public DataTable get_issuedetail_byimid_teacher(DBcontainer db) { DataTable dt = new DataTable(); SqlConnection con = dbcon.GetConnection(); con.Open(); SqlCommand cmd = dbcon.GetProcedure(con, "get_issuedetails_byimid_teacher"); cmd.Parameters.AddWithValue("@IMT_ID", db.Imt_id); cmd.ExecuteNonQuery(); dt = dbcon.GetDataTable(cmd); return(dt); }
public DataTable edit_student(DBcontainer db) { DataTable dt = new DataTable(); SqlConnection con = dbcon.GetConnection(); con.Open(); SqlCommand cmd = dbcon.GetProcedure(con, "get_studentid"); cmd.Parameters.AddWithValue("@Student_ID", db.Student_id); cmd.ExecuteNonQuery(); dt = dbcon.GetDataTable(cmd); return(dt); }
public DataTable get_studentdetails_bybarcode(DBcontainer db) { DataTable dt = new DataTable(); SqlConnection con = dbcon.GetConnection(); con.Open(); SqlCommand cmd = dbcon.GetProcedure(con, "get_studentdetails_bybarcode"); cmd.Parameters.AddWithValue("@bar_code", db.Sbarcode); cmd.ExecuteNonQuery(); dt = dbcon.GetDataTable(cmd); return(dt); }
public DataTable spSuggestBid(DBcontainer db) { DataTable dt = new DataTable(); SqlConnection con = dbcon.GetConnection(); con.Open(); SqlCommand cmd = dbcon.GetProcedure(con, "spSuggestBid"); cmd.Parameters.AddWithValue("@sub", db.Subject_id); cmd.ExecuteNonQuery(); dt = dbcon.GetDataTable(cmd); return(dt); }
public void save_book_booked(DBcontainer db) { DataTable dt = new DataTable(); SqlConnection con = dbcon.GetConnection(); con.Open(); SqlCommand cmd = dbcon.GetProcedure(con, "save_book_booked"); cmd.Parameters.AddWithValue("@Book_ID", db.Book_id); cmd.Parameters.AddWithValue("@Student_ID", db.Student_id); cmd.Parameters.AddWithValue("@booked", true); cmd.ExecuteNonQuery(); }
public DataTable get_book_by_publication(DBcontainer db) { DataTable dt = new DataTable(); SqlConnection con = dbcon.GetConnection(); con.Open(); SqlCommand cmd = dbcon.GetProcedure(con, "get_book_by_publication"); cmd.Parameters.AddWithValue("@Publication_ID", db.Publication_id); cmd.ExecuteNonQuery(); dt = dbcon.GetDataTable(cmd); return(dt); }