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