private void btnThem_Click(object sender, RoutedEventArgs e)
{
try
{
this.vo_HH.IdLoaiHangHoa = int.Parse(this.cboLoaiHH.SelectedValue.ToString());
if (string.IsNullOrEmpty(this.vo_HH.TenHangHoa))
{
MessageBox.Show("Chưa nhập tên hàng hóa", "Loi!", MessageBoxButton.OK, MessageBoxImage.Warning);
return;
}
if (this.vo_HH.IdLoaiHangHoa == 0)
{
//this.vo_HH.IdLoaiHangHoa = -1;
MessageBox.Show("Chưa chọn loại hàng hóa", "Loi!", MessageBoxButton.OK, MessageBoxImage.Warning);
}
int id = this.bus_HH.AddHangHoa(vo_HH);
if (id > 0)
{
MessageBox.Show("Them hang hoa thanh cong!", "Loi!", MessageBoxButton.OK, MessageBoxImage.Information);
this.vo_HH = new vo_HangHoa();
this.initValue();
}
else
{
MessageBox.Show("Them hang hoa that bai!", "Loi!", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Loi!", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
public int UpdateHangHoa(params object[] oParams)
{
try
{
if (oParams != null)
{
vo_HangHoa vo = (vo_HangHoa)oParams[0];
string query = "UPDATE HANGHOA SET MAHANGHOA=@mahh, TENHANGHOA=@tenhh, GIABAN=@giaban, GIAVON=@giavon, TONKHO=@tonkho" +
", URL_IMAGE=@image, ID_LOAIHANGHOA=@idloaihh, GIAGIAM=@giagiam OUTPUT INSERTED.ID WHERE ID=@id";
ConnectionString cnn = new ConnectionString();
string[] arrParam = new string[] { "@mahh", "@tenhh", "@giaban", "@giavon", "@tonkho", "@image", "@ghichu", "@idloaihh", "@giagiam", "@id" };
SqlDbType[] arrType = new SqlDbType[] { SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.Int, SqlDbType.Int, SqlDbType.Int, SqlDbType.NVarChar,
SqlDbType.NVarChar, SqlDbType.Int, SqlDbType.Int, SqlDbType.Int };
object[] arrvalues = new object[] { vo.MaHangHoa, vo.TenHangHoa, vo.GiaBan, vo.GiaVon, vo.TonKho,
vo.UrlImage, vo.GhiChu, vo.IdLoaiHangHoa, vo.GiaGiam, vo.Id };
int id = cnn.conn.ExecuteQueryReturnID(query, arrParam, arrvalues, arrType);
return(id);
}
return(0);
}
catch (Exception ex)
{
throw ex;
}
}
public pl_windowThemHangHoa(vo_HangHoa _voHH)
{
try
{
bus_HH = new bus_HangHoa();
this.vo_HH = _voHH;
bus_LoaiHH = new bus_LoaiHangHoa();
this.cancelFlag = 1;
InitializeComponent();
this.tenHH.IsEnabled = false;
this.giaBan.IsEnabled = false;
this.giaGiam.IsEnabled = false;
this.giaVon.IsEnabled = false;
this.ghiChu.IsEnabled = false;
this.cboLoaiHH.IsEnabled = false;
this.tonKho.IsEnabled = false;
this.btnDoiAnh.IsEnabled = false;
this.btnThem.Visibility = Visibility.Hidden;
this.cboLoaiHH.ItemsSource = this.bus_LoaiHH.getAllLoaiHangHoa();
this.cboLoaiHH.SelectedValue = vo_HH.IdLoaiHangHoa;
this.DataContext = this.vo_HH;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Loi!", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
public ObservableCollection <vo_HangHoa> GetAllHangHoa()
{
try
{
dao_HangHoa dao = new dao_HangHoa();
DataTable dt = dao.getAllHangHoa();
ObservableCollection <vo_HangHoa> dsHangHoa = new ObservableCollection <vo_HangHoa>();
foreach (DataRow dr in dt.Rows)
{
vo_HangHoa vo = new vo_HangHoa();
vo.Id = int.Parse(dr["ID"].ToString());
vo.IdLoaiHangHoa = int.Parse(dr["ID_LOAIHANGHOA"].ToString());
vo.LoaiHangHoa = dr["LOAIHANGHOA"].ToString();
vo.GiaVon = int.Parse(dr["GIAVON"].ToString());
vo.GiaBan = int.Parse(dr["GIABAN"].ToString());
vo.GiaGiam = int.Parse(dr["GIAGIAM"].ToString());
vo.GhiChu = dr["GHICHU"].ToString();
vo.MaHangHoa = dr["MAHANGHOA"].ToString();
vo.TenHangHoa = dr["TENHANGHOA"].ToString();
vo.UrlImage = dr["URL_IMAGE"].ToString();
vo.TonKho = int.Parse(dr["TONKHO"].ToString());
dsHangHoa.Add(vo);
}
return(dsHangHoa);
}
catch (Exception ex)
{
throw ex;
}
}
public int InsertHangHoa(params object[] oParams)
{
try
{
if (oParams != null)
{
vo_HangHoa vo = (vo_HangHoa)oParams[0];
ConnectionString cnn = new ConnectionString();
string query = "INSERT INTO HANGHOA (MAHANGHOA, TENHANGHOA, GIABAN, GIAVON, TONKHO, URL_IMAGE, GHICHU, ID_LOAIHANGHOA, GIAGIAM) " +
"output INSERTED.ID VALUES(@mahh, @tenhh, @giaban, @giavon, @tonkho, @image, @ghichu, @idloaihh, @giagiam)";
string[] arrParam = new string[] { "@mahh", "@tenhh", "@giaban", "@giavon", "@tonkho", "@image", "@ghichu", "@idloaihh", "@giagiam" };
SqlDbType[] arrType = new SqlDbType[] { SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.Int, SqlDbType.Int, SqlDbType.Int, SqlDbType.NVarChar,
SqlDbType.NVarChar, SqlDbType.Int, SqlDbType.Int };
object[] arrvalues = new object[] { vo.MaHangHoa, vo.TenHangHoa, vo.GiaBan, vo.GiaVon, vo.TonKho,
vo.UrlImage, vo.GhiChu, vo.IdLoaiHangHoa, vo.GiaGiam };
return(cnn.conn.ExecuteQueryReturnID(query, arrParam, arrvalues, arrType));
}
return(0);
}
catch (Exception ex)
{
throw ex;
}
}
public vo_HangHoa getHangHoaById(int _id)
{
try
{
dao_HangHoa dao = new dao_HangHoa();
vo_HangHoa vo = new vo_HangHoa();
DataTable dt = dao.GetHangHoaById(_id);
vo.Id = int.Parse(dt.Rows[0]["ID"].ToString());
vo.IdLoaiHangHoa = int.Parse(dt.Rows[0]["ID_LOAIHANGHOA"].ToString());
vo.LoaiHangHoa = dt.Rows[0]["LOAIHANGHOA"].ToString();
vo.GiaVon = int.Parse(dt.Rows[0]["GIAVON"].ToString());
vo.GiaBan = int.Parse(dt.Rows[0]["GIABAN"].ToString());
vo.GiaGiam = int.Parse(dt.Rows[0]["GIAGIAM"].ToString());
vo.GhiChu = dt.Rows[0]["GHICHU"].ToString();
vo.MaHangHoa = dt.Rows[0]["MAHANGHOA"].ToString();
vo.TenHangHoa = dt.Rows[0]["TENHANGHOA"].ToString();
vo.UrlImage = dt.Rows[0]["URL_IMAGE"].ToString();
vo.TonKho = int.Parse(dt.Rows[0]["TONKHO"].ToString());
return(vo);
}
catch (Exception ex)
{
throw ex;
}
}
protected void handleDownProduct(object sender, MouseButtonEventArgs e)
{
vo_HangHoa track = ((ListViewItem)sender).Content as vo_HangHoa; //Casting back to the binded Track
this.dsHangHoaCuaPhieuNhap.Add(track);
this.TinhToanPhieuNhap();
return;
}
private void TableView_CellValueChanged(object sender, DevExpress.Xpf.Grid.CellValueChangedEventArgs e)
{
try
{
vo_HangHoa row = (vo_HangHoa)this.iGridViewPhieuNhap.SelectedItem;
this.TinhToanPhieuNhap();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Lỗi!", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
private void TableView_RowDoubleClick(object sender, DevExpress.Xpf.Grid.RowDoubleClickEventArgs e)
{
try
{
vo_HangHoa _vo = (vo_HangHoa)this.iGridViewPhieuNhap.SelectedItem;
pl_windowThemHangHoa _plThemHH = new pl_windowThemHangHoa(_vo);
_plThemHH.ShowDialog();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Loi!", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
public int UpdateHangHoa(vo_HangHoa _vo)
{
try
{
dao_HangHoa _dao = new dao_HangHoa();
int id = _dao.UpdateHangHoa(_vo);
return(id);
}
catch (Exception ex)
{
throw ex;
}
}
public int AddHangHoa(vo_HangHoa vo)
{
try
{
dao_HangHoa dao = new dao_HangHoa();
int id = dao.InsertHangHoa(vo);
return(id);
}
catch (Exception ex)
{
throw ex;
}
}
private void btnThoat_Click(object sender, RoutedEventArgs e)
{
try
{
if (this.cancelFlag != 0)
{
this.Close();
return;
}
this.vo_HH = new vo_HangHoa();
this.initValue();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Loi!", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
public pl_windowThemHangHoa()
{
try
{
bus_HH = new bus_HangHoa();
vo_HH = new vo_HangHoa();
bus_LoaiHH = new bus_LoaiHangHoa();
InitializeComponent();
this.lblLuu.Content = " Lưu";
this.btnLuu.Visibility = Visibility.Hidden;
this.initValue();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Loi!", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
protected void handleDownProduct(object sender, MouseButtonEventArgs e)
{
vo_HangHoa hangHoa = ((ListViewItem)sender).Content as vo_HangHoa;
vo_HangHoaHoaDon hangHoaHD = new vo_HangHoaHoaDon(hangHoa.MaHangHoa, hangHoa.TenHangHoa, 1, hangHoa.GiaBan, hangHoa.GiaGiam, hangHoa.TonKho);
dsHangHoaHoaDon.Add(hangHoaHD);
int tongHD = 0;
int tongGiamHD = 0;
foreach (vo_HangHoaHoaDon item in dsHangHoaHoaDon)
{
tongHD += item.ThanhTien;
tongGiamHD += item.TongGiamChiTiet;
}
hoaDon.TongTienHang = tongHD;
hoaDon.TongGiam = tongGiamHD;
return;
}
private void deleteRowItem_ItemClick(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e)
{
try
{
vo_HangHoa _vo = (vo_HangHoa)this.iGridViewPhieuNhap.SelectedItem;
if (MessageBox.Show("Bạn có muốn xóa hàng hóa" + _vo.TenHangHoa + " ra khỏi kho", "Xác nhận", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.No)
{
return;
}
int _id = this.bus_HH.DeleteHangHoa(_vo.Id);
if (_id > 0)
{
this.dsHangHoa = this.bus_HH.GetAllHangHoa();
this.iGridViewPhieuNhap.ItemsSource = this.dsHangHoa;
MessageBox.Show("Đã xpas " + _vo.TenHangHoa + "ra khỏi kho", "Thông báo", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Loi!", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
// lay chi tiet phieu nhap hang
public vo_PhieuNhapHang GetChiTietPhieuNhapHang(string _code)
{
try
{
dao_PhieuNhapHang dao = new dao_PhieuNhapHang();
vo_PhieuNhapHang vo_phieuNhap = new vo_PhieuNhapHang();
//lay thong tin phieu nhap
DataTable dt = dao.GetPhieuNhapById(_code);
if (dt != null && dt.Rows.Count > 0)
{
vo_phieuNhap.DaTra = int.Parse(dt.Rows[0]["DATRA"].ToString());
vo_phieuNhap.GhiChu = dt.Rows[0]["GHICHU"].ToString();
vo_phieuNhap.Id = int.Parse(dt.Rows[0]["ID"].ToString());
vo_phieuNhap.MaNhaCungCap = dt.Rows[0]["MANHACUNGCAP"].ToString();
vo_phieuNhap.NhaCungCap = dt.Rows[0]["TENNHACUNGCAP"].ToString();
vo_phieuNhap.MaNhanVien = dt.Rows[0]["MANHANVIEN"].ToString();
vo_phieuNhap.TenNhanVien = dt.Rows[0]["HOTEN"].ToString();
vo_phieuNhap.MaPhieuNhap = dt.Rows[0]["MAPHIEUNHAP"].ToString();
vo_phieuNhap.ThoiGian = Utilities.DotNetToVietNam(dt.Rows[0]["THOIGIAN"].ToString());
vo_phieuNhap.TongGiam = int.Parse(dt.Rows[0]["TONGGIAM"].ToString());
vo_phieuNhap.TongTien = int.Parse(dt.Rows[0]["TONGTIENCANTRA"].ToString());
vo_phieuNhap.DsHangHoa = new ObservableCollection <vo_HangHoa>();
}
// lay danh sach hang hoa trong phieu nhap
DataTable dtDsHangHoa = dao.GetDanhSachHangHoaByPhieuNhap(_code);
if (dtDsHangHoa != null && dtDsHangHoa.Rows.Count > 0)
{
foreach (DataRow dr in dtDsHangHoa.Rows)
{
vo_HangHoa vo = new vo_HangHoa();
// lay nhung du lieu can thiet
vo.MaHangHoa = dr["MAHANGHOA"].ToString();
vo.TenHangHoa = dr["TENHANGHOA"].ToString();
vo.SoLuong = int.Parse(dr["SOLUONG"].ToString());
//don gia
vo.GiaVon = int.Parse(dr["DONGIA"].ToString());
//gia giam
if (string.IsNullOrEmpty(dr["GIAGIAM"].ToString()))
{
vo.GiaGiam = 0;
}
else
{
vo.GiaGiam = int.Parse(dr["GIAGIAM"].ToString());
}
vo.LoaiHangHoa = dr["LOAIHANGHOA"].ToString();
vo_phieuNhap.DsHangHoa.Add(vo);
}
}
return(vo_phieuNhap);
}
catch (Exception ex)
{
throw ex;
}
}
