public bool editThuongHieu(DTO_ThuongHieu dtoThuongHieu) { String SQLUpdate = "UPDATE THUONGHIEU " + "SET TENTHUONGHIEU = @TENTHUONGHIEU, MOTA = @MOTA, HINHANH = @HINHANH " + "WHERE MATHUONGHIEU = @MATHUONGHIEU"; try { conn = new DBConnection().getConnection(); conn.Open(); SqlCommand sqlCommand = new SqlCommand(SQLUpdate, conn); sqlCommand.Parameters.AddWithValue("TENTHUONGHIEU", dtoThuongHieu.tenThuongHieu); sqlCommand.Parameters.AddWithValue("MOTA", dtoThuongHieu.moTa); sqlCommand.Parameters.AddWithValue("HINHANH", dtoThuongHieu.hinhAnh); sqlCommand.Parameters.AddWithValue("MATHUONGHIEU", dtoThuongHieu.maThuongHieu); sqlCommand.ExecuteNonQuery(); conn.Close(); return(true); } catch (Exception e) { e.ToString(); return(false); } }
private void btnSua_Click(object sender, EventArgs e) { if (lvwGiay.SelectedItems.Count > 0) { ListViewItem item = lvwGiay.SelectedItems[0]; DTO_Giay dtoGiay = new DTO_Giay(); dtoGiay.maGiay = item.SubItems[2].Text; dtoGiay.TenGiay = item.SubItems[3].Text; dtoGiay.moTa = item.SubItems[6].Text; dtoGiay.soLuong = int.Parse(item.SubItems[8].Text); dtoGiay.gia = float.Parse(item.SubItems[9].Text); DTO_GioiTinh dtoGioiTinh = new DTO_GioiTinh(); DTO_ThuongHieu dtoThuongHieu = new DTO_ThuongHieu(); DTO_KhuyenMai dtoKhuyenMai = new DTO_KhuyenMai(); dtoGioiTinh.tenGioiTinh = item.SubItems[4].Text; dtoThuongHieu.tenThuongHieu = item.SubItems[5].Text; dtoKhuyenMai.phanTramGiamGia = float.Parse(item.SubItems[7].Text); Tool_SuaGiay toolSuaGiayy = new Tool_SuaGiay(dtoGiay, dtoGioiTinh, dtoThuongHieu, dtoKhuyenMai); toolSuaGiayy.ShowDialog(); if (toolSuaGiayy.isClickSua) { loadDataGiay(); } } }
public Tool_SuaGiay(DTO_Giay dtoGiay, DTO_GioiTinh dtoGioiTinh, DTO_ThuongHieu dtoThuongHieu, DTO_KhuyenMai dtoKhuyenMai) { InitializeComponent(); this.dtoGiay = dtoGiay; this.dtoGioiTinh = dtoGioiTinh; this.dtoThuongHieu = dtoThuongHieu; this.dtoKhuyenMai = dtoKhuyenMai; isClickSua = false; }
private void btnLuu_Click(object sender, EventArgs e) { try { DTO_ThuongHieu th = new DTO_ThuongHieu(txtTenth.Text); bUS_ThuongHieu.InsertThuongHieu(th); MessageBox.Show("Thêm thành công"); LoadData(); } catch (Exception) { MessageBox.Show("Thêm thất bại"); } }
private void btnSua_Click(object sender, EventArgs e) { try { DTO_ThuongHieu th = new DTO_ThuongHieu(int.Parse(txtMath.Text), txtTenth.Text); bUS_ThuongHieu.UpdateThuongHieu(th); MessageBox.Show("Sửa thành công"); LoadData(); } catch (Exception) { MessageBox.Show("sửa thất bại"); } }
public bool UpdateThuongHieu(DTO_ThuongHieu a) { try { ThuongHieu update = db.ThuongHieus.Where(p => p.MaThuongHieu.ToString().Equals(a.MaThuongHieu)).SingleOrDefault(); update.TenTH = a.TenTH; db.SubmitChanges(); return(true); } catch { return(false); } }
public void loadThuongHieu() { List <DTO_ThuongHieu> thuongHieus = new List <DTO_ThuongHieu>(); foreach (DataRow row in busThuongHieu.getAllThuongHieu().Rows) { DTO_ThuongHieu th = new DTO_ThuongHieu(); th.maThuongHieu = row["MATHUONGHIEU"].ToString(); th.tenThuongHieu = row["TENTHUONGHIEU"].ToString(); thuongHieus.Add(th); } cbbThuongHieu.DataSource = thuongHieus; cbbThuongHieu.DisplayMember = "tenThuongHieu"; }
public bool DeleteThuongHieu(DTO_ThuongHieu a) { try { ThuongHieu delete = db.ThuongHieus.Where(p => p.MaThuongHieu.ToString().Equals(a.MaThuongHieu)).SingleOrDefault(); db.ThuongHieus.DeleteOnSubmit(delete); db.SubmitChanges(); return(true); } catch { return(false); } }
public bool InsertNThuongHieu(DTO_ThuongHieu a) { try { ThuongHieu insert = new ThuongHieu(); insert.TenTH = a.TenTH; db.ThuongHieus.InsertOnSubmit(insert); db.SubmitChanges(); return(true); } catch { return(false); } }
private void btnSua_Click(object sender, EventArgs e) { if (lvwThuongHieu.SelectedItems.Count > 0) { ListViewItem item = lvwThuongHieu.SelectedItems[0]; DTO_ThuongHieu dtoThuongHieu = new DTO_ThuongHieu(); dtoThuongHieu.maThuongHieu = item.SubItems[2].Text; dtoThuongHieu.tenThuongHieu = item.SubItems[3].Text; dtoThuongHieu.moTa = item.SubItems[4].Text; Tool_SuaThuongHieu toolSuaThuongHieu = new Tool_SuaThuongHieu(dtoThuongHieu); toolSuaThuongHieu.ShowDialog(); if (toolSuaThuongHieu.isClickSua) { loadDatathuongHieu(); } } }
private void btnXoa_Click(object sender, EventArgs e) { try { DialogResult r = MessageBox.Show("Bạn có muốn xóa?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (r == DialogResult.Yes) { DTO_ThuongHieu th = new DTO_ThuongHieu(int.Parse(txtMath.Text)); bUS_ThuongHieu.DeleteThuongHieu(th); MessageBox.Show("Xóa thành công."); LoadData(); } } catch (Exception) { MessageBox.Show("Xóa thất bại"); } }
public bool addThuongHieu(DTO_ThuongHieu dtoThuongHieu) { String SQLInsert = "INSERT INTO THUONGHIEU (MATHUONGHIEU, TENTHUONGHIEU, MOTA, HINHANH) " + "VALUES(@MATHUONGHIEU, @TENTHUONGHIEU, @MOTA, @HINHANH)"; try { conn = new DBConnection().getConnection(); conn.Open(); SqlCommand sqlCommand = new SqlCommand(SQLInsert, conn); sqlCommand.Parameters.AddWithValue("MATHUONGHIEU", dtoThuongHieu.maThuongHieu); sqlCommand.Parameters.AddWithValue("TENTHUONGHIEU", dtoThuongHieu.tenThuongHieu); sqlCommand.Parameters.AddWithValue("MOTA", dtoThuongHieu.moTa); sqlCommand.Parameters.AddWithValue("HINHANH", dtoThuongHieu.hinhAnh); sqlCommand.ExecuteNonQuery(); conn.Close(); return(true); } catch (Exception e) { e.ToString(); return(false); } }
public bool addThuongHieu(DTO_ThuongHieu dtoThuongHieu) { return(dalThuongHieu.addThuongHieu(dtoThuongHieu)); }
public bool DeleteThuongHieu(DTO_ThuongHieu a) { return(dAL_ThuongHieu.DeleteThuongHieu(a)); }
public bool UpdateThuongHieu(DTO_ThuongHieu a) { return(dAL_ThuongHieu.UpdateThuongHieu(a)); }
public bool InsertThuongHieu(DTO_ThuongHieu a) { return(dAL_ThuongHieu.InsertNThuongHieu(a)); }
public bool editThuongHieu(DTO_ThuongHieu dtoThuongHieu) { return(dalThuongHieu.editThuongHieu(dtoThuongHieu)); }
public Tool_SuaThuongHieu(DTO_ThuongHieu dtoThuongHieu) { InitializeComponent(); this.dtoThuongHieu = dtoThuongHieu; this.isClickSua = false; }