//Inserting Data into Database
public bool Insert(SystemClass2 c)
{
//Creatinga default return type and setting its value to false
bool isSuccess = false;
MySqlConnection conn = new MySqlConnection(myconnString);
try
{
//Create a SQL Query to insert Data
string sql = "INSERT INTO enforcer(FirstName, LastName, Address, Gender, BirthDate, ContactNo,Code) VALUES (@FirstName, @LastName, @Address, @Gender, @BirthDate, @ContactNo,@Code)";
MySqlCommand cmd = new MySqlCommand(sql, conn);
//Create Parameters to add data
cmd.Parameters.AddWithValue("@FirstName", c.FirstName);
cmd.Parameters.AddWithValue("@LastName", c.LastName);
cmd.Parameters.AddWithValue("@Address", c.Address);
cmd.Parameters.AddWithValue("@Gender", c.Gender);
cmd.Parameters.AddWithValue("@BirthDate", c.BirthDate);
cmd.Parameters.AddWithValue("@ContactNo", c.ContactNo);
cmd.Parameters.AddWithValue("@Code", c.Code);
//Connection Open
conn.Open();
int rows = cmd.ExecuteNonQuery();
//if the query runs succesfully thn the value of the rows will greater than zero else its value will be Zero
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
}
finally
{
conn.Close();
}
return(isSuccess);
}
public bool Delete(SystemClass2 c)
{
//Create a default return value and set it's value to false
bool isSuccess = false;
//Sql connection
MySqlConnection conn = new MySqlConnection(myconnString);
try
{
//Sql to Delete Command
string sql = "DELETE FROM enforcer WHERE Id=@Id";
//Sql Command
MySqlCommand cmd = new MySqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@Id", c.Id);
//Open Connection
int rows = cmd.ExecuteNonQuery();
//if the query run sucessfully then the value of rows is greater than 0 else its value is 0
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception ex)
{
}
finally
{
conn.Close();
}
return(isSuccess);
}