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