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