//method to delete from db
public bool Delete(formClass c)
{
//default return value
bool isSuccessful = false;
SqlConnection conn = new SqlConnection(myconnstring);
try
{
//sql to delete data
string sql = "DELETE FROM Residents WHERE ResidentID = @ResidentID";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@ResidentID", c.ResidentID);
conn.Open();
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
isSuccessful = true;
}
else
{
isSuccessful = false;
}
}catch (Exception e)
{
} finally
{
conn.Close();
}
return(isSuccessful);
}
//inserting data into databse
public bool Insert(formClass c)
{
//default return type
bool isSuccessful = false;
//connect db
SqlConnection conn = new SqlConnection(myconnstring);
try
{
//create sql query to insert data
string sql = "INSERT INTO Residents (EmailAddress, FirstName, LastName, AptNumber) VALUES (@EmailAddress, @FirstName, @LastName, @AptNumber)";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@EmailAddress", c.EmailAddress);
cmd.Parameters.AddWithValue("@FirstName", c.FirstName);
cmd.Parameters.AddWithValue("@LastName", c.LastName);
cmd.Parameters.AddWithValue("@AptNumber", c.AptNumber);
//open connection
conn.Open();
int rows = cmd.ExecuteNonQuery();
//if query is succesfful rows will be greater than 0
if (rows > 0)
{
isSuccessful = true;
}
else
{
isSuccessful = false;
}
}
catch (Exception e)
{
}
finally
{
conn.Close();
}
return(isSuccessful);
}
//update data in table from application
public bool Update(formClass c)
{
//create default bool return value
bool isSuccesful = false;
SqlConnection conn = new SqlConnection(myconnstring);
try
{
//sql to update data in database
string sql = "UPDATE Residents SET EmailAddress = @EmailAddress, FirstName = @FirstName, LastName = @LastName, AptNumber = @AptNumber WHERE ResidentID = @ResidentID";
SqlCommand cmd = new SqlCommand(sql, conn);
//create parameters to add
cmd.Parameters.AddWithValue("@EmailAddress", c.EmailAddress);
cmd.Parameters.AddWithValue("@FirstName", c.FirstName);
cmd.Parameters.AddWithValue("@LastName", c.LastName);
cmd.Parameters.AddWithValue("@AptNumber", c.AptNumber);
cmd.Parameters.AddWithValue("ResidentID", c.ResidentID);
conn.Open();
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
isSuccesful = true;
}
else
{
isSuccesful = false;
}
}
catch (Exception e)
{
}
finally
{
conn.Close();
}
return(isSuccesful);
}