// delete data from db
#region data delete
public bool Delete(contactProp p, int contact_id = 0)
{
bool isSuccess = false;
SqlConnection conn = new SqlConnection(dataconnstrng);
try
{
if (contact_id == 0)
{
isSuccess = false; return(false);
}
string sql = "DELETE FROM vcontact_data_all WHERE contact_id = @contact_id";
SqlCommand cmd = new SqlCommand(sql, conn);
// where param
cmd.Parameters.AddWithValue("@contact_id", p.ContactId);
conn.Open(); // open db connection
int rows = cmd.ExecuteNonQuery();
isSuccess = (rows > 0) ? true : false; // similar logic to @@ROWCOUNT in sql
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
finally { conn.Close(); } // close db connection
return(isSuccess);
}
// update data in db
#region data update
public bool Update(contactProp p, int contact_id = 0)
{
bool isSuccess = false;
SqlConnection conn = new SqlConnection(dataconnstrng);
try
{
if (contact_id == 0)
{
isSuccess = false; return(false);
}
string sql = "UPDATE vcontact_data_all "
+ "SET first_name = @first_name, last_name = @last_name, address = @address, city = @city, "
+ "state = @state, zip = @zip, email_personal = @email_personal, email_work = @email_work, "
+ "phone_home = @phone_home, phone_cell = @phone_cell, phone_work = @phone_work, website = @website, github = @github "
+ "WHERE contact_id = @contact_id";
SqlCommand cmd = new SqlCommand(sql, conn);
// add data values from screen to UPDATE
cmd.Parameters.AddWithValue("@first_name", p.FirstName);
cmd.Parameters.AddWithValue("@last_name", p.LastName);
cmd.Parameters.AddWithValue("@address", p.Address);
cmd.Parameters.AddWithValue("@city", p.City);
cmd.Parameters.AddWithValue("@state", p.State);
cmd.Parameters.AddWithValue("@zip", p.Zip);
cmd.Parameters.AddWithValue("@email_personal", p.EmailPersonal);
cmd.Parameters.AddWithValue("@email_work", p.EmailWork);
cmd.Parameters.AddWithValue("@phone_home", p.PhoneHome);
cmd.Parameters.AddWithValue("@phone_cell", p.PhoneCell);
cmd.Parameters.AddWithValue("@phone_work", p.PhoneWork);
cmd.Parameters.AddWithValue("@website", p.Website);
cmd.Parameters.AddWithValue("@github", p.Github);
// where param
cmd.Parameters.AddWithValue("@contact_id", p.ContactId);
conn.Open(); // open db connection
int rows = cmd.ExecuteNonQuery();
isSuccess = (rows > 0) ? true : false; // similar logic to @@ROWCOUNT in sql
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
finally { conn.Close(); } // close db connection
return(isSuccess);
}
// insert data into db
#region data insert
public bool Insert(contactProp p)
{
bool isSuccess = false; // default to fail
SqlConnection conn = new SqlConnection(dataconnstrng);
try
{
string sql = "INSERT INTO vcontact_data_all (contact_id, first_name, last_name, address, city, state, zip, "
+ "email_personal, email_work, phone_home, phone_cell, phone_work, website, github) "
+ "VALUES (@contact_id, @first_name, @last_name, @address, @city, @state, @zip, "
+ "@email_personal, @email_work, @phone_home, @phone_cell, @phone_work, @website, @github)";
SqlCommand cmd = new SqlCommand(sql, conn); // build insert
// add data values from screen to INSERT
cmd.Parameters.AddWithValue("@contact_id", p.ContactId);
cmd.Parameters.AddWithValue("@first_name", p.FirstName);
cmd.Parameters.AddWithValue("@last_name", p.LastName);
cmd.Parameters.AddWithValue("@address", p.Address);
cmd.Parameters.AddWithValue("@city", p.City);
cmd.Parameters.AddWithValue("@state", p.State);
cmd.Parameters.AddWithValue("@zip", p.Zip);
cmd.Parameters.AddWithValue("@email_personal", p.EmailPersonal);
cmd.Parameters.AddWithValue("@email_work", p.EmailWork);
cmd.Parameters.AddWithValue("@phone_home", p.PhoneHome);
cmd.Parameters.AddWithValue("@phone_cell", p.PhoneCell);
cmd.Parameters.AddWithValue("@phone_work", p.PhoneWork);
cmd.Parameters.AddWithValue("@website", p.Website);
cmd.Parameters.AddWithValue("@github", p.Github);
conn.Open(); // open db connection
int rows = cmd.ExecuteNonQuery();
isSuccess = (rows > 0) ? true : false; // similar logic to @@ROWCOUNT in sql
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
finally { conn.Close(); } // close db connection
return(isSuccess); // return status
}
// INSTANTIATE CLASS(ES)
public void InstantiateObjects()
{
data = new contactData(); // data class
ext = new contactExt(); // method class
prop = new contactProp(); // properties class
}
