예제 #1
0
        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);
        }
예제 #3
0
        //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;
        }
예제 #4
0
        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;
        }
예제 #5
0
        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;
            }
        }
예제 #6
0
        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();
            }
        }
예제 #7
0
        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.";
        }