public bool Create(Renter renter)
{
string query = "";
int result = 0;
Renters.connection.Open();
try
{
query = String.Format("INSERT INTO renter VALUES ('{0}','{1}','{2}', '{3}')", renter.Name, renter.Email, renter.Phone, renter.Password);
SqlCommand cmd = new SqlCommand(query, Renters.connection);
result = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
Renters.connection.Close();
// Displays the MessageBox.
MessageBox.Show(
"Renter Added Unsuccessfull!\n\n" + ex,
"ERROR | Renter not added",
MessageBoxButtons.OK,
MessageBoxIcon.Information
);
}
Renters.connection.Close();
if (result > 0)
{
return(true);
}
return(false);
}
public bool UpdateUser(Renter renter, string oldEmail)
{
string query = "";
int r = 0;
Renters.connection.Open();
try
{
query = String.Format("UPDATE renter SET name='{1}', email='{2}', phone='{3}' WHERE email='{0}'", oldEmail, renter.Name, renter.Email, renter.Phone);
SqlCommand cmd = new SqlCommand(query, Renters.connection);
r = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
Renters.connection.Close();
// Displays the MessageBox.
MessageBox.Show(
"Renter Edit Unsuccessfull!\n\n" + ex,
"ERROR | Renter not Edited",
MessageBoxButtons.OK,
MessageBoxIcon.Information
);
}
Renters.connection.Close();
if (r > 0)
{
return(true);
}
return(false);
}
public Renter GetUser(string email)
{
string query = "";
Renter renter = null;
Renters.connection.Open();
try
{
query = String.Format("SELECT * FROM renter WHERE email='{0}'", email);
SqlCommand cmd = new SqlCommand(query, Renters.connection);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
renter = new Renter();
renter.Id = reader.GetInt32(reader.GetOrdinal("r_id"));
renter.Name = reader.GetString(reader.GetOrdinal("name"));
renter.Email = reader.GetString(reader.GetOrdinal("email"));
renter.Phone = reader.GetString(reader.GetOrdinal("phone"));
renter.Password = reader.GetString(reader.GetOrdinal("password"));
}
}
catch (Exception ex)
{
Renters.connection.Close();
// Displays the MessageBox.
MessageBox.Show(
"Getting Renter Unsuccessfull!\n\n" + ex,
"ERROR | Renter not Getting",
MessageBoxButtons.OK,
MessageBoxIcon.Information
);
}
Renters.connection.Close();
return(renter);
}