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;
}
}
public void AddCostumerDA(CostumerBO objCostumerBO)
{
DbConnection objDbConnection = DbConnection.GetInstance();
SqlConnection con = objDbConnection.GetConnection();
con.Open();
SqlCommand cmd = new SqlCommand("Insert Into dbo.Costumer (CostumerName,CostumerAddress,CostumerPhone) Values (@CostumerName,@CostumerAddress,@CostumerPhone)", con);
cmd.Parameters.Add(new SqlParameter("@CostumerName", objCostumerBO.CostumerName));
cmd.Parameters.Add(new SqlParameter("@CostumerAddress", objCostumerBO.CostumerAddress));
cmd.Parameters.Add(new SqlParameter("@CostumerPhone", objCostumerBO.CostumerPhone));
cmd.ExecuteNonQuery();
}
public void UpdateCostumer(CostumerBO objCostumerBO)
{
DbConnection objDbConnection = DbConnection.GetInstance();
SqlConnection con = objDbConnection.GetConnection();
con.Open();
SqlCommand cmd = new SqlCommand("Update dbo.Costumer Set CostumerName=@CostumerName,CostumerAddress=@CostumerAddress,CostumerPhone=@CostumerPhone Where CostumerID=@CostumerID", con);
cmd.Parameters.Add(new SqlParameter("@CostumerID", objCostumerBO.CostumerID));
cmd.Parameters.Add(new SqlParameter("@CostumerName", objCostumerBO.CostumerName));
cmd.Parameters.Add(new SqlParameter("@CostumerAddress", objCostumerBO.CostumerAddress));
cmd.Parameters.Add(new SqlParameter("@CostumerPhone", objCostumerBO.CostumerPhone));
cmd.ExecuteNonQuery();
}
public int GetCostumerID(CostumerBO objCostumerBO)
{
DbConnection objDbConnection = DbConnection.GetInstance();
SqlConnection con = objDbConnection.GetConnection();
con.Open();
SqlCommand cmd = new SqlCommand("Select CostumerID From dbo.Costumer Where CostumerName=@CostumerName", con);
cmd.Parameters.Add(new SqlParameter("@CostumerName", objCostumerBO.CostumerName));
SqlDataReader dr = cmd.ExecuteReader();
int CostumerID = 0;
if (dr.Read())
{
CostumerID = dr.GetInt32(0);
}
return(CostumerID);
}
public int GetCostumerID(CostumerBO objCostumerBO)
{
CostumerDA objCostumerDA = new CostumerDA();
return(objCostumerDA.GetCostumerID(objCostumerBO));
}
public void UpdateCustomer(CostumerBO objCostumerBO)
{
CostumerDA objCostumerDA = new CostumerDA();
objCostumerDA.UpdateCostumer(objCostumerBO);
}
public void AddCostumerBL(CostumerBO objCostumerBO)
{
CostumerDA objCostumerDA = new CostumerDA();
objCostumerDA.AddCostumerDA(objCostumerBO);
}
