private void btnDelete_Click(object sender, EventArgs e) { try { Departmans departmans = new Departmans(); DataGridViewRow selected = dgvDepartman.SelectedRows[0]; if (string.IsNullOrWhiteSpace(txtAciklama.Text) && string.IsNullOrWhiteSpace(txtDepartman.Text)) { MessageBox.Show("Lütfen Departman seçiniz"); } else { departmans.DepartmanID = (int)selected.Cells["DepartmanID"].Value; DialogResult result = MessageBox.Show("Departmanı Silmek İstediğinize Emin Misiniz!!!", "Çıkış Onay", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { departmanBLL.Delete(departmans); ListDepartman(); ClearBox(); } else { this.Show(); ClearBox(); } } } catch (Exception ex) { MessageBox.Show(ex.Message); ClearBox(); } }
public int Delete(Departmans departmans) { helper.CommandText = "Delete From Departman Where DepartmanID=@departmanID"; helper.Parameters.Clear(); helper.Parameters.Add("@departmanID", departmans.DepartmanID); return(helper.ExecuteQuery()); }
//Departman EKLEME private void btnAdd_Click(object sender, EventArgs e) { Departmans departmans = new Departmans(); try { string departmanName = txtDepartman.Text.ToUpper(); departmans.Departman = departmanName; departmans.Aciklama = txtAciklama.Text; foreach (var item in departmanBLL.GetDepartmans()) { if (item.Departman == departmanName) { MessageBox.Show("Departman İsmi Zaten Var"); ClearBox(); return; } } departmanBLL.AddDepartman(departmans); MessageBox.Show("Departman Başarıyla Eklenmiştir"); ClearBox(); ListDepartman(); } catch (Exception ex) { MessageBox.Show(ex.Message); ClearBox(); } }
public int Insert(Departmans departmans) { helper.CommandText = "Insert Into Departman (Departman,Aciklama) Values (@departman,@aciklama)"; helper.Parameters.Clear(); helper.Parameters.Add("@departman", departmans.Departman); helper.Parameters.Add("@aciklama", departmans.Aciklama); return(helper.ExecuteQuery()); }
private Departmans MapDepartmanName(SqlDataReader reader) { Departmans departman = new Departmans(); //departman.DepartmanID = (int)reader["DepartmanID"]; //departman.Aciklama = reader["Aciklama"].ToString(); departman.Departman = reader["Departman"].ToString(); return(departman); }
public int Update(Departmans departmans) { helper.CommandText = "Update Departman Set Departman=@departman,Aciklama=@aciklama where DepartmanID=@departmanID"; helper.Parameters.Clear(); helper.Parameters.Add("@departmanID", departmans.DepartmanID); helper.Parameters.Add("@departman", departmans.Departman); helper.Parameters.Add("@aciklama", departmans.Aciklama); return(helper.ExecuteQuery()); }
public bool Update(Departmans departmans) { try { CheckRequiredFields(departmans.Departman, departmans.Aciklama); CheckLength(departmans.Departman, departmans.Aciklama); } catch (Exception ex) { throw ex; } return(departmanDAL.Update(departmans) > 0); }
// Departman İsimlerini Getirir public List <Departmans> GetDepartmansName() { helper.CommandText = "Select Departman From Departman"; helper.Parameters.Clear(); List <Departmans> departmans = new List <Departmans>(); Departmans departman = null; SqlDataReader reader = helper.SqlDataReader(); while (reader.Read()) { departman = MapDepartmanName(reader); departmans.Add(departman); } reader.Close(); return(departmans); }
private void btnUpdate_Click(object sender, EventArgs e)//Merte Sor Seçili iken başka cell seçiliyken hata veriyor { try { if (string.IsNullOrWhiteSpace(txtAciklama.Text) && string.IsNullOrWhiteSpace(txtDepartman.Text)) { MessageBox.Show("Lütfen Departman seçiniz"); } else { Departmans departmans = new Departmans(); departmanBLL.CheckBox(txtDepartman.Text, txtAciklama.Text); DataGridViewRow selected = dgvDepartman.SelectedRows[0]; departmans.Departman = txtDepartman.Text; departmans.Aciklama = txtAciklama.Text; //foreach (var item in departmanBLL.GetDepartmans()) //{ // if (item.Departman == txtDepartman.Text) // { // MessageBox.Show("Departman İsmi Zaten Var"); // ClearBox(); // return; // } //} departmans.DepartmanID = (int)selected.Cells["DepartmanID"].Value; departmanBLL.Update(departmans); MessageBox.Show("Güncelleme başarılı"); ClearBox(); ListDepartman(); } } catch (Exception ex) { MessageBox.Show(ex.Message); ClearBox(); } }
public bool Delete(Departmans departmans) { return(departmanDAL.Delete(departmans) > 0); }