public int AddHoaDon(vo_HoaDon hoaDon)
{
try
{
dao_HoaDon dao = new dao_HoaDon();
hoaDon.ThoiGian = Utilities.StandardTime(DateTime.Now.ToString());
int id = dao.InsertHoaDon(hoaDon);
if (id > 0)
{
int row = dao.InsertChiTietHoaDon(hoaDon);
return(row);
}
return(0);
}
catch (Exception ex)
{
throw ex;
}
}
public ObservableCollection <vo_HoaDon> getListHoaDon()
{
try
{
dao_HoaDon dao = new dao_HoaDon();
DataTable dtHoaDon = dao.getAllHoaDon();
ObservableCollection <vo_HoaDon> dsHoaDon = new ObservableCollection <vo_HoaDon>();
foreach (DataRow row in dtHoaDon.Rows)
{
vo_HoaDon hoadon = new vo_HoaDon(row["MAHOADONBANHANG"].ToString(), row["MAKHACHHANG"].ToString(), row["TENKHACHHANG"].ToString(), row["THOIGIAN"].ToString(), int.Parse(row["CANTHANHTOAN"].ToString()), int.Parse(row["TONGGIAM"].ToString()), int.Parse(row["DATRA"].ToString()));
dsHoaDon.Add(hoadon);
}
;
return(dsHoaDon);
}
catch (Exception ex)
{
return(null);
throw ex;
}
}
//tra về số chi tiết hàng hóa hóa đơn đã thêm thành công
public int InsertChiTietHoaDon(params object[] oParams)
{
try
{
if (oParams != null)
{
vo_HoaDon vo_HD = (vo_HoaDon)oParams[0];
ObservableCollection <vo_HangHoaHoaDon> dsHangHoa = vo_HD.DsHangHoaHoaDon;
ConnectionString cnn = new ConnectionString();
int soHangHoa = 0;
foreach (vo_HangHoaHoaDon vo in dsHangHoa)
{
string query = "INSERT INTO CHITIETHOADON(MAHANGHOA, MAHOADONBANHANG, SOLUONG, DONGIA, GIAGIAM) OUTPUT 1" +
"VALUES(@maHH, @maHD, @soLuong, @donGia, @giaGiam)";
string[] arrParam = new string[] { "@maHH", "@maHD", "@soLuong", "@donGia", "@giaGiam" };
SqlDbType[] arrType = new SqlDbType[] { SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.Int, SqlDbType.Int, SqlDbType.Int };
object[] arrvalues = new object[] { vo.MaHangHoa, vo_HD.MaHoaDon, vo.SoLuong, vo.DonGia, vo.GiaGiam };
cnn.conn.ExecuteQueryReturnID(query, arrParam, arrvalues, arrType);
string _query = "UPDATE HANGHOA SET TONKHO=@tonkho OUTPUT INSERTED.ID WHERE MAHANGHOA=@mahh";
ConnectionString _cnn = new ConnectionString();
string[] _arrParam = new string[] { "@tonkho", "@mahh" };
SqlDbType[] _arrType = new SqlDbType[] { SqlDbType.Int, SqlDbType.NVarChar };
object[] _arrvalues = new object[] { vo.TonKho, vo.MaHangHoa };
int id = cnn.conn.ExecuteQueryReturnID(_query, _arrParam, _arrvalues, _arrType);
soHangHoa++;
}
return(soHangHoa);
}
return(0);
}
catch (Exception ex)
{
throw ex;
}
}
private void loadPage()
{
try
{
hoaDon = new vo_HoaDon();
//load danh sach hang hoa
dsHangHoa = bus_hangHoa.GetAllHangHoa();
lvHangHoa.ItemsSource = dsHangHoa;
//danh sach chi tiet hoa don
dsHangHoaHoaDon = new ObservableCollection <vo_HangHoaHoaDon>();
gvHoaDon.ItemsSource = dsHangHoaHoaDon;
//danh sach khach hang
this.hoaDon.TenNhanVien = CurrentUser.User.HoTen;
this.hoaDon.MaNhanVien = CurrentUser.User.MaNhanVien;
hoaDon.MaHoaDon = bus_hoaDon.GenerateMaHoaDon();
this.hoaDon.ThoiGian = Utilities.DotNetToVietNam(DateTime.Now.ToString());
this.DataContext = hoaDon;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Loi!", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
public int InsertHoaDon(params object[] oParams)
{
try
{
if (oParams != null)
{
vo_HoaDon vo = (vo_HoaDon)oParams[0];
ConnectionString cnn = new ConnectionString();
string query = "INSERT INTO HOADONBANHANG(MAHOADONBANHANG,MANHANVIEN,CANTHANHTOAN,DATRA,THOIGIAN,GHICHU,TONGGIAM,MAKHACHHANG) output INSERTED.ID " +
"VALUES (@mahoadon, @manhanvien, @canthanhtoan, @datra, @thoigian, @ghichu, @tonggiam,@makhachhang)";
string[] arrParam = new string[] { "@mahoadon", "@manhanvien", "@canthanhtoan", "@datra", "@thoigian", "@ghichu", "@tonggiam", "@makhachhang" };
SqlDbType[] arrType = new SqlDbType[] { SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.Int, SqlDbType.Int, SqlDbType.NVarChar, SqlDbType.NVarChar,
SqlDbType.Int, SqlDbType.NVarChar };
object[] arrvalues = new object[] { vo.MaHoaDon, vo.MaNhanVien, vo.CanThanhToan, vo.DaTra, vo.ThoiGian, vo.GhiChu, vo.TongGiam, vo.MaKhachHang };
return(cnn.conn.ExecuteQueryReturnID(query, arrParam, arrvalues, arrType));
}
return(0);
}
catch (Exception ex)
{
throw ex;
}
}
