private void ButtonCostumerAdd_Click(object sender, EventArgs e)
        {
            try
            {
                if (TextBoxCompanyName.Text != "")
                {
                    CostumerBO objCostumerBO = new CostumerBO();
                    objCostumerBO.CostumerName    = TextBoxCompanyName.Text;
                    objCostumerBO.CostumerAddress = TextBoxAddress.Text;
                    objCostumerBO.CostumerPhone   = TextBoxTelephone.Text;

                    CostumerBL objCostumerBL = new CostumerBL();
                    objCostumerBL.AddCostumerBL(objCostumerBO);

                    MessageBox.Show("Müşteri başarı ile eklenmiştir");
                }
                else
                {
                    MessageBox.Show("Lütfen müşteri adı giriniz");
                }

                TextBoxCompanyName.Clear();
                TextBoxAddress.Clear();
                TextBoxTelephone.Clear();
                PopulateGridViewCostumers();
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        protected void PopulateComboBoxCostumerSell()
        {
            try
            {
                CostumerBL objCostumerBL = new CostumerBL();
                DataSet    ds            = objCostumerBL.PopulateComboBoxCostumerSellBL();

                DataView dvTypes = new DataView(ds.Tables[0]);
                dvTypes.Sort = "CostumerName";

                ComboBoxCompanyNameSell.DataSource    = dvTypes;
                ComboBoxCompanyNameSell.DisplayMember = "CostumerName";
                ComboBoxCompanyNameSell.ValueMember   = "CostumerID";
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        public void PopulateGridViewCostumers()
        {
            try
            {
                CostumerBL objCostumerBL = new CostumerBL();
                DataSet    ds            = objCostumerBL.PopulateGridViewCostumerBL();

                ds.Tables[0].Columns[0].ColumnName = "Firma Adı";
                ds.Tables[0].Columns[1].ColumnName = "Adres";
                ds.Tables[0].Columns[2].ColumnName = "Telefon";

                GridViewCostumers.DataSource = ds;
                GridViewCostumers.DataMember = ds.Tables[0].ToString();
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        private void ButtonUpdateCustomer_Click(object sender, EventArgs e)
        {
            try
            {
                objCostumerBO.CostumerName    = TextBoxCompanyNameUpdateCustomer.Text;
                objCostumerBO.CostumerAddress = TextBoxAddressUpdateCustomer.Text;
                objCostumerBO.CostumerPhone   = TextBoxTelephoneUpdateCustomer.Text;

                CostumerBL objCostumerBL = new CostumerBL();
                objCostumerBL.UpdateCustomer(objCostumerBO);

                MessageBox.Show("Müşteri başarı ile güncellenmiştir");
                this.Close();
                form1.PopulateGridViewCostumers();
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        private void UpdateCustomer_Load(object sender, System.EventArgs e)
        {
            try
            {
                TextBoxCompanyNameUpdateCustomer.Text = Constants.CompanyNameUpdateCustomer;
                TextBoxAddressUpdateCustomer.Text     = Constants.AddressUpdateCustomer;
                TextBoxTelephoneUpdateCustomer.Text   = Constants.TelephoneUpdateCustomer;

                objCostumerBO.CostumerName    = TextBoxCompanyNameUpdateCustomer.Text;
                objCostumerBO.CostumerAddress = TextBoxAddressUpdateCustomer.Text;
                objCostumerBO.CostumerPhone   = TextBoxTelephoneUpdateCustomer.Text;

                CostumerBL objCostumerBL = new CostumerBL();

                objCostumerBO.CostumerID = objCostumerBL.GetCostumerID(objCostumerBO);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        private void ButtonDeleteCustomer_Click(object sender, EventArgs e)
        {
            try
            {
                if (GridViewCostumers.SelectedRows.Count == 1)
                {
                    DataGridViewRow dr            = GridViewCostumers.SelectedRows[0];
                    CostumerBL      objCostumerBL = new CostumerBL();
                    objCostumerBL.DeleteCostumerBL(dr.Cells[0].Value.ToString());

                    PopulateGridViewCostumers();
                }
                else
                {
                    MessageBox.Show("Lütfen silmek istediğiniz müşterinin satırını seçin");
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }