public bool UpdateAdminBook() { bool result; int rowsAffected = 0; SqlConnection connectObj = new SqlConnection(); connectObj = WebDbConnection.GetSqlConnection(); connectObj.Open(); string updateQuery = "update wms_books SET boo_title=@Title,boo_price=@Price,boo_Special=@Special where boo_id=@Id"; SqlCommand cmdUpdate = new SqlCommand(updateQuery, connectObj); cmdUpdate.Parameters.AddWithValue("@Title", Title); cmdUpdate.Parameters.AddWithValue("@Price", Price); cmdUpdate.Parameters.AddWithValue("@Special", Special); cmdUpdate.Parameters.AddWithValue("Id", Id); rowsAffected = cmdUpdate.ExecuteNonQuery(); if (rowsAffected > 0) { result = true; } else { result = false; } return(result); }
public DataTable DisplayCartBooks() { string selectQuery = "select * from wms_cart"; SqlConnection connectObj = new SqlConnection(); connectObj = WebDbConnection.GetSqlConnection(); connectObj.Open(); SqlCommand cmd = new SqlCommand(selectQuery, connectObj); SqlDataAdapter data = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); data.Fill(dt); return(dt); }
public DataTable DeleteBook() { SqlConnection connectObj = new SqlConnection(); connectObj = WebDbConnection.GetSqlConnection(); connectObj.Open(); string deleteQuery = "delete from wms_cart where car_id=@Id"; SqlCommand cmdDelete = new SqlCommand(deleteQuery, connectObj); cmdDelete.Parameters.AddWithValue("@Id", Id); SqlDataAdapter adapt = new SqlDataAdapter(cmdDelete); DataTable dt = new DataTable(); adapt.Fill(dt); return(dt); }
public DataTable AddBookAdmin() { SqlConnection connectObj = new SqlConnection(); connectObj = WebDbConnection.GetSqlConnection(); connectObj.Open(); string insertQuery = "insert into wms_books(boo_title,boo_price,boo_special) values(@Title,@Price,@Special)"; SqlCommand cmdInsert = new SqlCommand(insertQuery, connectObj); cmdInsert.Parameters.AddWithValue("@Title", Title); cmdInsert.Parameters.AddWithValue("@Price", Price); cmdInsert.Parameters.AddWithValue("@Special", Special); SqlDataAdapter adapt = new SqlDataAdapter(cmdInsert); DataTable dt = new DataTable(); adapt.Fill(dt); return(dt); }
public DataTable SearchBook() { string selectQuery = "select * from wms_books where boo_title=@Title"; SqlConnection connectObj = new SqlConnection(); connectObj = WebDbConnection.GetSqlConnection(); connectObj.Open(); SqlCommand cmd = new SqlCommand(selectQuery, connectObj); cmd.Parameters.AddWithValue("@Title", Title); SqlDataAdapter adapt = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); adapt.Fill(dt); connectObj.Close(); return(dt); }
public DataTable BindDetailsView() { string selectQuery = "select boo_id AS Id,boo_title AS Title,boo_price AS Price,boo_special AS Special from wms_books where boo_id=@Id"; SqlConnection connectObj = new SqlConnection(); connectObj = WebDbConnection.GetSqlConnection(); connectObj.Open(); SqlCommand cmd = new SqlCommand(selectQuery, connectObj); cmd.Parameters.AddWithValue("@Id", Id); SqlDataAdapter adapt = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); adapt.Fill(dt); connectObj.Close(); return(dt); }
public bool InsertBook() { bool result; int rowsAffected = 0; SqlConnection connectObj = new SqlConnection(); connectObj = WebDbConnection.GetSqlConnection(); connectObj.Open(); string insertQuery = "insert into wms_cart(car_title,car_price,car_special) select boo_title,boo_price,boo_special from wms_books where boo_id=@Id"; SqlCommand cmdInsert = new SqlCommand(insertQuery, connectObj); cmdInsert.Parameters.AddWithValue("@Id", Id); SqlDataAdapter adapt = new SqlDataAdapter(cmdInsert); DataTable dt = new DataTable(); adapt.Fill(dt); rowsAffected = cmdInsert.ExecuteNonQuery(); connectObj.Close(); if (rowsAffected == 1) { result = true; } else { result = false; } return(result); }
public bool GetAccessibilityAdmin() { bool result; int rowsAffected = 0; SqlConnection connectObj = new SqlConnection(); connectObj = WebDbConnection.GetSqlConnection(); connectObj.Open(); string selectQuery = "select * from wms_adminlogin where adm_name=@username AND adm_password=@password"; SqlCommand cmd = new SqlCommand(selectQuery, connectObj); cmd.Parameters.AddWithValue("@username", Username); cmd.Parameters.AddWithValue("@password", Password); SqlDataAdapter adapt = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); adapt.Fill(dt); rowsAffected = cmd.ExecuteNonQuery(); if (dt.Rows.Count > 0) { result = true; } else { result = false; } return(result); }