public string activatePartner(Partner partner)
{
sqlConn.ConnectionString = conn;
string inactive = "ACTIVE";
SqlCommand cmd = new SqlCommand(string.Format(
@"UPDATE PARTNER SET STATUS=@STATUS WHERE ID_PARTNER=@ID_PARTNER"), sqlConn);
cmd.Parameters.AddWithValue("@ID_PARTNER", partner.id);
cmd.Parameters.AddWithValue("@STATUS", inactive);
try
{
sqlConn.Open();
cmd.ExecuteNonQuery();
return "The Partner has been added sucessfully to the list of Active members.";
}
catch (Exception e)
{
return e.Message.ToString();
}
finally
{
sqlConn.Close();
}
}
protected void activatePartner(object sender, EventArgs e)
{
Partner partner = new Partner();
partner.id = this.ID_PARTNER.Text;
PartnerDAO partnerDAO = new PartnerDAO();
this.activatePartnerForm.Visible = false;
this.responseForm.Visible = true;
this.responseText.Text = partnerDAO.activatePartner(partner);
}
//Creates a partner object, using a SELECT. The argument received is a member ID..
public Partner getPartnerData(string idPartner)
{
Partner partner = new Partner();
sqlConn.ConnectionString = conn;
DataTable dt = new DataTable();
dt.Clear();
//SELECT SQL, using the ID passed as an argument
SqlCommand cmd = new SqlCommand(string.Format(@"SELECT * FROM PARTNER WHERE ID_PARTNER=@ID_PARTNER"), sqlConn);
cmd.Parameters.AddWithValue("@ID_PARTNER", idPartner);
try
{
sqlConn.Open();
SqlDataReader reader = cmd.ExecuteReader();
reader.Read();
//Sets the partner's parameters using the reader..
partner.id = reader.GetValue(0).ToString();
partner.name = reader.GetValue(1).ToString();
partner.address = reader.GetValue(2).ToString();
partner.city = reader.GetValue(3).ToString();
partner.dateJoined = reader.GetValue(4).ToString();
partner.province = reader.GetValue(5).ToString();
partner.postalCode = reader.GetValue(6).ToString();
partner.website = reader.GetValue(7).ToString();
partner.emailAddress = reader.GetValue(8).ToString();
partner.phoneNumber = reader.GetValue(9).ToString();
partner.faxNumber = reader.GetValue(10).ToString();
partner.contactPerson = reader.GetValue(11).ToString();
partner.status = reader.GetValue(12).ToString();
reader.Close();
}
catch (Exception)
{
//MessageBox.Show("Some error has occured. Sorry =(");
}
finally
{
sqlConn.Close();
}
return partner;
}
protected void insertNewPartner(object sender, EventArgs e)
{
Partner partner = new Partner();
partner.name = this.partnerName.Text.Trim();
partner.dateJoined = this.datepicker.Text;
partner.address = this.address.Text.Trim();
partner.city = this.city.Text.Trim();
partner.postalCode = this.postalCode.Text.ToUpper();
partner.website = this.website.Text.Trim();
partner.emailAddress = this.emailAddress.Text.Trim();
partner.phoneNumber = this.phoneNumber.Text;
partner.faxNumber = this.faxNumber.Text;
partner.contactPerson = this.contactPerson.Text.Trim();
PartnerDAO partnerDAO = new PartnerDAO();
this.response.InnerText = partnerDAO.insertNewPartner(partner);
this.insertNewPartnerForm.Visible = false;
this.response.Visible = true;
}
protected void updatePartner(object sender, EventArgs e)
{
Partner partner = new Partner();
string databaseResponse = "";
if (partnerName.Text.ToString() == "" || address.Text.ToString() == "" ||
city.Text.ToString() == "" || postalCode.Text.ToString() == "")
{
this.editPartnerForm.Visible = false;
this.response.Visible = true;
}
else
{ //Loads the form content into the partner object
partner.id = this.searchPartners.SelectedRow.Cells[4].Text;
partner.dateJoined = this.searchPartners.SelectedRow.Cells[5].Text;
partner.status = this.searchPartners.SelectedRow.Cells[6].Text;
partner.name = partnerName.Text.ToString().Trim();
partner.address = address.Text.ToString().Trim();
partner.city = city.Text.ToString().Trim();
partner.postalCode = postalCode.Text.ToString();
partner.website = website.Text.ToString().Trim();
partner.emailAddress = emailAddress.Text.ToString().Trim();
partner.phoneNumber = phoneNumber.Text.ToString();
partner.faxNumber = faxNumber.Text.ToString();
partner.contactPerson = contactPerson.Text.ToString().Trim();
this.clearAllFields();
PartnerDAO partnerDAO = new PartnerDAO();
databaseResponse = partnerDAO.updatePartner(partner);
this.response.InnerText = databaseResponse;
this.editPartnerForm.Visible = false;
this.response.Visible = true;
}
}
public string updatePartner(Partner partner)
{
sqlConn.ConnectionString = conn;
DataTable dt = new DataTable();
dt.Clear();
SqlCommand cmd = new SqlCommand(string.Format(@"UPDATE PARTNER
SET NAME=@NAME, ADDRESS=@ADDRESS, CITY=@CITY, POSTAL_CODE=@POSTAL_CODE, WEBSITE=@WEBSITE, EMAIL_ADDRESS=@EMAIL_ADDRESS,
PHONE_NUMBER=@PHONE_NUMBER, FAX=@FAX, CONTACT_PERSON=@CONTACT_PERSON
WHERE ID_PARTNER=@ID_PARTNER"), sqlConn);
cmd.Parameters.AddWithValue("@ID_PARTNER", partner.id);
cmd.Parameters.AddWithValue("@NAME", partner.name);
cmd.Parameters.AddWithValue("@ADDRESS", partner.address); cmd.Parameters.AddWithValue("@CITY", partner.city);
cmd.Parameters.AddWithValue("@POSTAL_CODE", partner.postalCode); cmd.Parameters.AddWithValue("@WEBSITE", partner.website);
cmd.Parameters.AddWithValue("@EMAIL_ADDRESS", partner.emailAddress); cmd.Parameters.AddWithValue("@PHONE_NUMBER", partner.phoneNumber);
cmd.Parameters.AddWithValue("@FAX", partner.faxNumber); cmd.Parameters.AddWithValue("@CONTACT_PERSON", partner.contactPerson);
try
{
sqlConn.Open();
cmd.ExecuteNonQuery();
return "The Partner has been updated sucessfully.";
}
catch (Exception e)
{
return e.Message.ToString();
}
finally
{
sqlConn.Close();
}
}
public string insertNewPartner(Partner partner)
{
sqlConn.ConnectionString = conn;
DataTable dt = new DataTable();
dt.Clear();
SqlCommand cmd = new SqlCommand(string.Format(@"INSERT INTO PARTNER
(NAME, ADDRESS, CITY, PARTNER_SINCE, POSTAL_CODE, WEBSITE, EMAIL_ADDRESS, PHONE_NUMBER, FAX, CONTACT_PERSON, STATUS)
VALUES (@NAME, @ADDRESS, @CITY, @PARTNER_SINCE, @POSTAL_CODE, @WEBSITE, @EMAIL_ADDRESS, @PHONE_NUMBER, @FAX, @CONTACT_PERSON, @STATUS)"), sqlConn);
cmd.Parameters.AddWithValue("@NAME", partner.name);
cmd.Parameters.AddWithValue("@ADDRESS", partner.address);
cmd.Parameters.AddWithValue("@CITY", partner.city);
cmd.Parameters.AddWithValue("@PARTNER_SINCE", partner.dateJoined);
cmd.Parameters.AddWithValue("@POSTAL_CODE", partner.postalCode);
cmd.Parameters.AddWithValue("@WEBSITE", partner.website);
cmd.Parameters.AddWithValue("@EMAIL_ADDRESS", partner.emailAddress);
cmd.Parameters.AddWithValue("@PHONE_NUMBER", partner.phoneNumber);
cmd.Parameters.AddWithValue("@FAX", partner.faxNumber);
cmd.Parameters.AddWithValue("@CONTACT_PERSON", partner.contactPerson);
cmd.Parameters.AddWithValue("@STATUS", "ACTIVE");
try
{
sqlConn.Open();
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
return "An error has occured when we tried to access the database. " + e.Message;
}
finally
{
sqlConn.Close();
}
return "The Partner has been added to the Database sucessfully.";
}
