//updating data public bool Update(contactClass c) { bool isSuccess = false; SqlConnection conn = new SqlConnection(dbstrng); // MySqlConnection conn2 = new MySqlConnection(dbstrng); //need to connect to MySQL try { string sql = "UPDATE people SET FirstName=FirstName@, LastName=@LastName, ContactNo=@ContactNo, Address=@Address, Gender=@Gender WHERE ContactID=@ContactID"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@FirstName", c.FirstName); cmd.Parameters.AddWithValue("@LastName", c.LastName); cmd.Parameters.AddWithValue("@ContactNo", c.ContactNum); cmd.Parameters.AddWithValue("@Address", c.Address); cmd.Parameters.AddWithValue("@Gender", c.Gender); cmd.Parameters.AddWithValue("@ContactID", c.ContactID); conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception ex) { throw; } finally { conn.Close(); } return(isSuccess); }
//inserting data public bool Insert(contactClass c) { bool isSuccess = false; SqlConnection conn = new SqlConnection(dbstrng); try { string sql = "INSERT INTO people (FirstName, LastName, ContactNo, Address, Gender) VALUES (@FirstName, @LastName, @ContactNo, @Address, @Gender)"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@FirstName", c.FirstName); cmd.Parameters.AddWithValue("@LastName", c.LastName); cmd.Parameters.AddWithValue("@ContactNo", c.ContactNum); cmd.Parameters.AddWithValue("@Address", c.Address); cmd.Parameters.AddWithValue("@Gender", c.Gender); conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception ex) { throw; } finally { conn.Close(); } return(isSuccess); }
//delete data public bool Delete(contactClass c) { bool isSuccess = false; SqlConnection conn = new SqlConnection(dbstrng); try { string sql = "DELETE FROM people WHERE ContactID=@ContactID"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@ContactID", c.ContactID); conn.Open(); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception) { throw; } finally { conn.Close(); } return(isSuccess); }