//Thêm hóa đơn.
public static HOADON_DTO ThemHoaDon(BANG_HOADON hd)
{
QuanLyShop = new QUANLYCUAHANGEntities();
hd = QuanLyShop.BANG_HOADON.Add(hd);
QuanLyShop.SaveChanges();
HOADON_DTO hdDTO = ConvertDTO(hd);
return(hdDTO);
}
/// <summary>
/// Selects all records from the HOA_DON table.
/// </summary>
public List <HOADON_DTO> SelectAll()
{
using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(m_ConnectionString, CommandType.StoredProcedure, "PROC_HoaDon_SelectAll"))
{
List <HOADON_DTO> HoaDonList = new List <HOADON_DTO>();
while (dataReader.Read())
{
HOADON_DTO HoaDon = MakeHOADON_DTO(dataReader);
HoaDonList.Add(HoaDon);
}
return(HoaDonList);
}
}
public static HOADON_DTO ConvertDTO(BANG_HOADON hd)
{
HOADON_DTO hdDTO = new HOADON_DTO();
hdDTO.idhoadon = hd.idhoadon;
hdDTO.idnhanvien = hd.idnhanvien;
hdDTO.idkhachhang = hd.idkhachhang;
hdDTO.tongtien = hd.tongtien;
hdDTO.ngayban = hd.ngayban;
hdDTO.tongtiencuoi = hd.tongtiencuoi;
hdDTO.soluong = hd.soluong;
return(hdDTO);
}
/// <summary>
/// Creates a new instance of the HOA_DON class and populates it with data from the specified SqlDataReader.
/// </summary>
private HOADON_DTO MakeHOADON_DTO(SqlDataReader dataReader)
{
HOADON_DTO HoaDon = new HOADON_DTO();
HoaDon.Ma = SqlClientUtility.GetInt32(dataReader, "MA", 0);
HoaDon.MaKhachHang = SqlClientUtility.GetInt32(dataReader, "MA_KHACH_HANG", 0);
HoaDon.MaNhanVien = SqlClientUtility.GetInt32(dataReader, "MA_NHAN_VIEN", 0);
HoaDon.NgayLap = SqlClientUtility.GetDateTime(dataReader, "NGAY_LAP", DateTime.Now);
HoaDon.KieuThanhToan = SqlClientUtility.GetBoolean(dataReader, "KIEU_THANH_TOAN", false);
HoaDon.TongTien = SqlClientUtility.GetDecimal(dataReader, "TONG_TIEN", Decimal.Zero);
HoaDon.TienTraMoiDot = SqlClientUtility.GetDecimal(dataReader, "TIEN_TRA_MOI_DOT", Decimal.Zero);
HoaDon.SoLanTra = SqlClientUtility.GetInt32(dataReader, "SO_LAN_TRA", 0);
return(HoaDon);
}
/// <summary>
/// Saves a record to the HOA_DON table.
/// </summary>
public void Insert(HOADON_DTO HoaDon)
{
ValidationUtility.ValidateArgument("HoaDon", HoaDon);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@MA_KHACH_HANG", HoaDon.MaKhachHang),
new SqlParameter("@MA_NHAN_VIEN", HoaDon.MaNhanVien),
new SqlParameter("@NGAY_LAP", HoaDon.NgayLap),
new SqlParameter("@KIEU_THANH_TOAN", HoaDon.KieuThanhToan),
new SqlParameter("@TONG_TIEN", HoaDon.TongTien),
new SqlParameter("@TIEN_TRA_MOI_DOT", HoaDon.TienTraMoiDot),
new SqlParameter("@SO_LAN_TRA", HoaDon.SoLanTra)
};
HoaDon.Ma = (int)SqlClientUtility.ExecuteScalar(m_ConnectionString, CommandType.StoredProcedure, "PROC_HoaDon_Insert", parameters);
}
private void ThemHoaDon()
{
if (grid_DanhSachXeMua.Rows.Count == 0)
{
MessageBox.Show("Chua có thông tin Xe mu?n mua", "Thi?u Thông Tin", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
HOADON_DTO HoaDon = new HOADON_DTO();
HoaDon.MaKhachHang = KhachHang.Ma;
HoaDon.MaNhanVien = int.Parse(txt_ro_MaNhanVien.Text);
HoaDon.NgayLap = DateTime.Today;
if (combo_HinhThucThanToan.Text == "Thanh Toán 1 L?n")
{
HoaDon.SoLanTra = 0;
HoaDon.KieuThanhToan = false;
HoaDon.TienTraMoiDot = Decimal.Parse(txt_ro_TongTien.Text);
}
else
{
HoaDon.KieuThanhToan = true;
HoaDon.SoLanTra = (int)updown_SoLanThanhToan.SelectedItem;
HoaDon.TienTraMoiDot = Decimal.Parse(txt_ro_TongTien.Text) / Decimal.Parse(updown_SoLanThanhToan.Text);
}
HoaDon.TongTien = Decimal.Parse(txt_ro_TongTien.Text);
new HOADON_BUS().Insert(HoaDon);
CHITIETHOADON_BUS BUS_ChiTietHoaDon = new CHITIETHOADON_BUS();
foreach (DataGridViewRow Row in grid_DanhSachXeMua.Rows)
{
CHITIETHOADON_DTO ChiTietHoaDon = new CHITIETHOADON_DTO();
ChiTietHoaDon.MaMau = Row.Cells["MaMau"].Value.ToString();
ChiTietHoaDon.MaHoaDon = HoaDon.Ma;
ChiTietHoaDon.MaXe = (int)Row.Cells["MaXe"].Value;
ChiTietHoaDon.SoLuong = (int)Row.Cells["SoLuong"].Value;
ChiTietHoaDon.ThanhTien = (Decimal)Row.Cells["ThanhTien"].Value;
BUS_ChiTietHoaDon.Insert(ChiTietHoaDon);
}
MessageBox.Show("Ðã thêm Hoá Ðon", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
grid_DanhSachXeMua.Rows.Clear();
txt_ro_TongTienTruocThue.Text = "0";
txt_ro_TongTien.Text = "0";
txt_ro_Thue.Text = "0";
txt_ro_TienTraMoiDot.Text = "0";
}
/// <summary>
/// Selects all records from the HOA_DON table by a foreign key.
/// </summary>
public List <HOADON_DTO> SelectAllByMaNhanVien(int MaNhanVien)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@MA_NHAN_VIEN", MaNhanVien)
};
using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(m_ConnectionString, CommandType.StoredProcedure, "PROC_HoaDonSelectAllByMaNhanVien", parameters))
{
List <HOADON_DTO> HoaDonList = new List <HOADON_DTO>();
while (dataReader.Read())
{
HOADON_DTO HoaDon = MakeHOADON_DTO(dataReader);
HoaDonList.Add(HoaDon);
}
return(HoaDonList);
}
}
//Sửa thông tin hóa đơn
public static HOADON_DTO SuaHoaDon(BANG_HOADON hd)
{
BANG_HOADON hdUpdate = QuanLyShop.BANG_HOADON.SingleOrDefault(h => h.idhoadon == hd.idhoadon);
if (hdUpdate != null)
{
hdUpdate.idhoadon = hd.idhoadon;
hdUpdate.idnhanvien = hd.idnhanvien;
hdUpdate.idkhachhang = hd.idkhachhang;
hdUpdate.tongtien = hd.tongtien;
hdUpdate.ngayban = hd.ngayban;
hdUpdate.tongtiencuoi = hd.tongtiencuoi;
hdUpdate.soluong = hd.soluong;
QuanLyShop.SaveChanges();
HOADON_DTO hdDTO = ConvertDTO(hdUpdate);
return(hdDTO);
}
return(null);
}
/// <summary>
/// Updates a record in the HOA_DON table.
/// </summary>
public void Update(HOADON_DTO HoaDon)
{
ValidationUtility.ValidateArgument("HoaDon", HoaDon);
new HOADON_DAO().Update(HoaDon);
}
