public bool Insert(donorBLL d) { //create a boolean variable and set its default value to false bool isSuccess = false; //create SQL connection to connect db SqlConnection conn = new SqlConnection(myconnstrng); try { //write the query to insert data into db string sql = "INSERT INTO table_donors (first_name, last_name, email, contact, gender, address, blood_group, added_date, image_name, added_by) VALUES (@first_name, @last_name, @email, @contact, @gender, @address, @blood_group, @added_date, @image_name, @added_by)"; //create sql command to execute the query SqlCommand cmd = new SqlCommand(sql, conn); //pass the values to sql query cmd.Parameters.AddWithValue("@first_name", d.first_name); cmd.Parameters.AddWithValue("@last_name", d.last_name); cmd.Parameters.AddWithValue("@email", d.email); cmd.Parameters.AddWithValue("@contact", d.contact); cmd.Parameters.AddWithValue("@gender", d.gender); cmd.Parameters.AddWithValue("@address", d.address); cmd.Parameters.AddWithValue("@blood_group", d.blood_group); cmd.Parameters.AddWithValue("@added_date", d.added_date); cmd.Parameters.AddWithValue("@image_name", d.image_name); cmd.Parameters.AddWithValue("@added_by", d.added_by); //open db connection conn.Open(); //create an integer variable to check whether the query was executed successfully or not int rows = cmd.ExecuteNonQuery(); //if the query is executed successfully the value of rows will be greater than zero if (rows > 0) { //query executed successfully isSuccess = true; } else { //query failed to execute isSuccess = false; } } catch (Exception e) { //display error message if there are any errors MessageBox.Show(e.Message); } finally { //close the db connection conn.Close(); } return(isSuccess); }
public bool Insert(donorBLL d) { //Create a Boolean Variable and SEt its default value to false bool isSuccess = false; //Create SqlConnection to Connect Database SqlConnection conn = new SqlConnection(myconnstrng); try { //Write the Query to INSERT data into database string sql = "INSERT INTO tbl_donors (first_name, last_name, email, contact, gender, address, blood_group, added_date, image_name, added_by) VALUES (@first_name, @last_name, @email, @contact, @gender, @address, @blood_group, @added_date, @image_name, @added_by)"; //Create SQL Command to Execute the Query SqlCommand cmd = new SqlCommand(sql, conn); //Pass the value to SQL Query cmd.Parameters.AddWithValue("@first_name", d.first_name); cmd.Parameters.AddWithValue("@last_name", d.last_name); cmd.Parameters.AddWithValue("@email", d.email); cmd.Parameters.AddWithValue("@contact", d.contact); cmd.Parameters.AddWithValue("@gender", d.gender); cmd.Parameters.AddWithValue("@address", d.address); cmd.Parameters.AddWithValue("@blood_group", d.blood_group); cmd.Parameters.AddWithValue("@added_date", d.added_date); cmd.Parameters.AddWithValue("@image_name", d.image_name); cmd.Parameters.AddWithValue("@added_by", d.added_by); //Open DAtabase Connection conn.Open(); //Create an Integer Variable to Check whether the query was executed Successfully or Not int rows = cmd.ExecuteNonQuery(); //If the Query is Executed Successfully the value of rows willb e greater than Zero else it will be Zero if (rows > 0) { //Query Executed Successfully isSuccess = true; } else { //Failed to Execute Query isSuccess = false; } } catch (Exception ex) { //Display Error Message if there's any Exceptional Errors MessageBox.Show(ex.Message); } finally { //CLose Database Connection conn.Close(); } return(isSuccess); }
public bool Update(donorBLL d) { //Create a Boolean Variable and SEt its Default Value to FAlse bool isSuccess = false; //Create SQLConnection to Connect DAtabase SqlConnection conn = new SqlConnection(myconnstrng); try { //Create a SQL Query to Update Donors string sql = "UPDATE tbl_donors SET first_name=@first_name, last_name=@last_name, email=@email, contact=@contact, gender=@gender, address=@address, blood_group=@blood_group, image_name=@image_name, added_by=@added_by WHERE donor_id=@donor_id"; //Create SQL Command Here SqlCommand cmd = new SqlCommand(sql, conn); //Pass the Value to SQL Query cmd.Parameters.AddWithValue("@first_name", d.first_name); cmd.Parameters.AddWithValue("@last_name", d.last_name); cmd.Parameters.AddWithValue("@email", d.email); cmd.Parameters.AddWithValue("@contact", d.contact); cmd.Parameters.AddWithValue("@gender", d.gender); cmd.Parameters.AddWithValue("@address", d.address); cmd.Parameters.AddWithValue("@blood_group", d.blood_group); cmd.Parameters.AddWithValue("@image_name", d.image_name); cmd.Parameters.AddWithValue("@added_by", d.added_by); cmd.Parameters.AddWithValue("@donor_id", d.donor_id); //Open Database Connection conn.Open(); //Create an Integer Variable to check whether the query executed Successfully or not int rows = cmd.ExecuteNonQuery(); //If the Query is Executed Successfully then its value will be greater than 0 else it will be 0 if (rows > 0) { //Query Executed Successfully isSuccess = true; } else { //Failed to Execute Query isSuccess = false; } } catch (Exception ex) { //Display Error Message if there's any exceptional errors MessageBox.Show(ex.Message); } finally { //CLose Database Connection conn.Close(); } return(isSuccess); }
public bool Update(donorBLL d) { //create a boolean value and set its default value to false bool isSuccess = false; //create sql connection to connect database SqlConnection conn = new SqlConnection(myconnstrng); try { //create an sql query to update donors string sql = "UPDATE table_donors SET first_name = @first_name, last_name = @last_name, email = @email, contact = @contact, gender = @gender, address = @address, blood_group = @blood_group, image_name = @image_name, added_by = @added_by WHERE donor_id = @donor_id"; //create sql command here SqlCommand cmd = new SqlCommand(sql, conn); //pass the value to sql query cmd.Parameters.AddWithValue("@first_name", d.first_name); cmd.Parameters.AddWithValue("@last_name", d.last_name); cmd.Parameters.AddWithValue("@email", d.email); cmd.Parameters.AddWithValue("@contact", d.contact); cmd.Parameters.AddWithValue("@gender", d.gender); cmd.Parameters.AddWithValue("@address", d.address); cmd.Parameters.AddWithValue("@blood_group", d.blood_group); cmd.Parameters.AddWithValue("@image_name", d.image_name); cmd.Parameters.AddWithValue("@added_by", d.added_by); cmd.Parameters.AddWithValue("@donor_id", d.donor_id); //open db connection conn.Open(); //create an integer variable to check if the query was executed successfully int rows = cmd.ExecuteNonQuery(); //if the query is executed successfully its value will be greater than zero if (rows > 0) { //query executed successfully isSuccess = true; } else { //failed to execute the query isSuccess = false; } } catch (Exception e) { } finally { } return(isSuccess); }
public bool Delete(donorBLL d) { //Create a Boolean variable and set its default value to false bool isSuccess = false; //Create SqlConnection To Connect DAtabase SqlConnection conn = new SqlConnection(myconnstrng); try { //Write the Query to Delete Donors from Database string sql = "DELETE FROM tbl_donors WHERE donor_id=@donor_id"; //Create SQL Command SqlCommand cmd = new SqlCommand(sql, conn); //Pass the Value to Sql Query using Parameters cmd.Parameters.AddWithValue("@donor_id", d.donor_id); //Open Database Connection conn.Open(); //Create an Integer VAriable to Check whether the query executed Successfully or Not int rows = cmd.ExecuteNonQuery(); //If the Query executed succesfully then the value of rows will be greater than 0 else it will be 0 if (rows > 0) { //Query Executed Successfully isSuccess = true; } else { //FAiled to Exeute Query isSuccess = false; } } catch (Exception ex) { //Display Error Message if there's any Exceptional Errors MessageBox.Show(ex.Message); } finally { //CLose Database Connection conn.Close(); } return(isSuccess); }
public bool Delete(donorBLL d) { //create a boolean value and set its value to false bool isSuccess = false; //create an sql connection to connect to db SqlConnection conn = new SqlConnection(myconnstrng); try { //write sql query to delete donors from the db string sql = "DELETE FROM table_donors WHERE donor_id = @donor_id"; //create sql command SqlCommand cmd = new SqlCommand(sql, conn); //pass the value to sql query using parameters cmd.Parameters.AddWithValue("@donor_id", d.donor_id); //open db connection conn.Open(); //create an integer variable to check whether the query executed successfully int rows = cmd.ExecuteNonQuery(); //if the query is executed successfully the number of rows will be greater than zero if (rows > 0) { //query executed successfully isSuccess = true; } else { //query failed to execute isSuccess = false; } } catch (Exception e) { MessageBox.Show(e.Message); } finally { } return(isSuccess); }
public bool Insert(donorBLL d) { bool isSuccess = false; SqlConnection conn = new SqlConnection(myconnstrng); try { string sql = "INSERT INTO tbl_darivaoci (ime_darivaoca, prezime_darivaoca, email, kontakt, spol, adresa, krvna_grupa, dodan_datuma, naziv_fotografije, zaprimaoc) VALUES (@ime_darivaoca, @prezime_darivaoca, @email, @kontakt, @spol, @adresa, @krvna_grupa, @dodan_datuma, @naziv_fotografije, @zaprimaoc)"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@ime_darivaoca", d.ime_darivaoca); cmd.Parameters.AddWithValue("@prezime_darivaoca", d.prezime_darivaoca); cmd.Parameters.AddWithValue("@email", d.email); cmd.Parameters.AddWithValue("@kontakt", d.kontakt); cmd.Parameters.AddWithValue("@spol", d.spol); cmd.Parameters.AddWithValue("@adresa", d.adresa); cmd.Parameters.AddWithValue("@krvna_grupa", d.krvna_grupa); cmd.Parameters.AddWithValue("@dodan_datuma", d.dodan_datuma); cmd.Parameters.AddWithValue("@naziv_fotografije", d.naziv_fotografije); cmd.Parameters.AddWithValue("@zaprimaoc", d.zaprimaoc); conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { conn.Close(); } return(isSuccess); }
public bool Update(donorBLL d) { bool isSuccess = false; SqlConnection conn = new SqlConnection(myconnstrng); try { string sql = "UPDATE tbl_darivaoci SET ime_darivaoca=@ime_darivaoca, prezime_darivaoca=@prezime_darivaoca, email=@email, kontakt=@kontakt, spol=@spol, adresa=@adresa, krvna_grupa=@krvna_grupa, naziv_fotografije=@naziv_fotografije, zaprimaoc=@zaprimaoc WHERE darivaoc_id=@darivaoc_id"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@ime_darivaoca", d.ime_darivaoca); cmd.Parameters.AddWithValue("@prezime_darivaoca", d.prezime_darivaoca); cmd.Parameters.AddWithValue("@email", d.email); cmd.Parameters.AddWithValue("@kontakt", d.kontakt); cmd.Parameters.AddWithValue("@spol", d.spol); cmd.Parameters.AddWithValue("@adresa", d.adresa); cmd.Parameters.AddWithValue("@krvna_grupa", d.krvna_grupa); cmd.Parameters.AddWithValue("@naziv_fotografije", d.naziv_fotografije); cmd.Parameters.AddWithValue("@zaprimaoc", d.zaprimaoc); cmd.Parameters.AddWithValue("@darivaoc_id", d.darivaoc_id); conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { conn.Close(); } return(isSuccess); }
public bool Delete(donorBLL d) { bool isSuccess = false; SqlConnection conn = new SqlConnection(myconnstrng); try { string sql = "DELETE FROM tbl_darivaoci WHERE darivaoc_id=@darivaoc_id"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@darivaoc_id", d.darivaoc_id); conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { conn.Close(); } return(isSuccess); }