//To delete records of Database
public bool Delete(ContactKeeper c)
{
//Declaring default boolean variable and initializing it false
bool isSucess = false;
//MySQL Connection
MySqlConnection conn = new MySqlConnection(connectionString);
try
{
//SQL Query
string SQLQuery = "DELETE FROM Users WHERE Contact_ID=@Contact_ID";
//MySQL Command
MySqlCommand cmd = new MySqlCommand(SQLQuery, conn);
//Creating parameters to add data
cmd.Parameters.AddWithValue("@Contact_ID", c.ContactID);
//Open Connection
conn.Open();
//Execute Query
//and ExecuteNonQuery() returns the number of rows affected
int row = cmd.ExecuteNonQuery();
isSucess = row > 0 ? true : false;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Exception", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
//Close Connection
conn.Close();
}
return(isSucess);
}
//To insert records in Database
public bool Insert(ContactKeeper c)
{
//declaring a default bool variable and initializing false
bool isSucess = false;
//MySQL Connection
MySqlConnection conn = new MySqlConnection(connectionString);
try
{
//SQL Query
string SQLQuery = "INSERT INTO Users(First_Name,Last_Name,Contact_Number,Address,Gender) VALUES(@First_Name,@Last_Name,@Contact_Number,@Address,@Gender)";
//MYSQL Command
MySqlCommand cmd = new MySqlCommand(SQLQuery, conn);
//Creating parameters to add data
cmd.Parameters.AddWithValue("@First_Name", c.FirstName);
cmd.Parameters.AddWithValue("@Last_Name", c.LastName);
cmd.Parameters.AddWithValue("@Contact_Number", c.ContactNumber);
cmd.Parameters.AddWithValue("@Address", c.Address);
cmd.Parameters.AddWithValue("@Gender", c.Gender);
//Connection Open
conn.Open();
//Execute Query
//Here ExecuteNonQuery() returns the number of rows affected
int row = cmd.ExecuteNonQuery();
isSucess = row > 0 ? true : false;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Exception", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
//Close connection
conn.Close();
}
return(isSucess);
}
//To update records of Database
public bool Update(ContactKeeper c)
{
//Declaring default boolean variable and initializing false
bool isSucess = false;
//MySQL Connection
MySqlConnection conn = new MySqlConnection(connectionString);
try
{
//SQLQuery
string SQLQuery = "UPDATE Users SET First_Name=@First_Name,Last_Name=@Last_Name,Contact_Number=@Contact_Number,Address=@Address,Gender=@Gender WHERE Contact_ID=@Contact_ID";
//SQL Command
MySqlCommand cmd = new MySqlCommand(SQLQuery, conn);
//Creating parameters to add Data
cmd.Parameters.AddWithValue("@First_Name", c.FirstName);
cmd.Parameters.AddWithValue("@Last_Name", c.LastName);
cmd.Parameters.AddWithValue("@Contact_Number", c.ContactNumber);
cmd.Parameters.AddWithValue("@Address", c.Address);
cmd.Parameters.AddWithValue("@Gender", c.Gender);
cmd.Parameters.AddWithValue("@Contact_ID", c.ContactID);
//Connection Open
conn.Open();
//Execute Query
//and ExecuteNonQuery() returns the number of rows affected
int row = cmd.ExecuteNonQuery();
isSucess = row > 0 ? true : false;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Exception", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
//Close connection
conn.Close();
}
return(isSucess);
}
