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); }