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