public static bool ThemCTHD(ChiTietHoaDonDTO CTHD)
{
try
{
SqlConnection con = DataProvider.Connection();
SqlCommand cmd = new SqlCommand("sp_ThemCTHD", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@sohd", SqlDbType.NChar);
cmd.Parameters.Add("@masach", SqlDbType.NChar);
cmd.Parameters.Add("@soluongban", SqlDbType.Int);
cmd.Parameters.Add("@giaban", SqlDbType.BigInt);
cmd.Parameters.Add("@thanhtien", SqlDbType.BigInt);
cmd.Parameters["@sohd"].Value = CTHD.SoHD;
cmd.Parameters["@masach"].Value = CTHD.MaSach;
cmd.Parameters["@soluongban"].Value = CTHD.SoLuongBan;
cmd.Parameters["@giaban"].Value = CTHD.GiaBan;
cmd.Parameters["@thanhtien"].Value = CTHD.ThanhTien;
cmd.ExecuteNonQuery();
con.Close();
return(true);
}
catch
{
return(false);
}
}
public bool UpdateRow(ChiTietHoaDonDTO obj)
{
try
{
if (_connection.State != ConnectionState.Open)
{
_connection.Open();
}
string sql = "UPDATE [dbo].[ChiTietHoaDon]\n"
+ " SET [MaHoaDon] = @MaHoaDon\n"
+ " ,[MaSach] = @MaSach\n"
+ " ,[SoLuongBan] = @SoLuongBan\n"
+ " ,[DonGiaBan] = @DonGiaBan\n"
+ " WHERE [MaChiTietHoaDon] = @MaChiTietHoaDon";
var cmd = new SqlCommand(sql, _connection);
cmd.Parameters.Add("@MaChiTietHoaDon", SqlDbType.Char).Value = obj.MaChiTietHoaDon;
cmd.Parameters.Add("@MaHoaDon", SqlDbType.Char).Value = obj.MaHoaDon;
cmd.Parameters.Add("@MaSach", SqlDbType.Char).Value = obj.MaSach;
cmd.Parameters.Add("@SoLuongBan", SqlDbType.Int).Value = obj.SoLuongBan;
cmd.Parameters.Add("@DonGiaBan", SqlDbType.Money).Value = obj.DonGiaBan;
cmd.ExecuteNonQuery();
_connection.Close();
return(true);
}
catch (Exception ex)
{
_connection.Close();
Console.WriteLine(ex.Message);
}
return(false);
}
public List <ChiTietHoaDonDTO> loadDataDAO(string maHD)
{
List <ChiTietHoaDonDTO> lsCTHD = new List <ChiTietHoaDonDTO>();
conn.Ketnoi();
//...
string query = "SELECT ct.MaSP, sp.TenSanPham, sp.GiaBan, ct.SoLuongMua, sp.KhuyenMai, ((sp.GiaBan*ct.SoLuongMua)*(100-sp.KhuyenMai)/100) N'Thành tiền', ct.TrangThai FROM HoaDon hd, ChiTietHoaDon ct, SanPham sp WHERE ct.MaHoaDon = '{0}' AND ct.MaSP = sp.MaSanPham";
string sql = string.Format(query, maHD);
SqlDataReader reader = conn.getdata(sql);
while (reader.Read())
{
ChiTietHoaDonDTO ct = new ChiTietHoaDonDTO();
ct.MaHD = maHD;
ct.MaSP = reader.GetString(0);
ct.TenSP = reader.GetString(1);
ct.GiaBan = reader.GetDecimal(2);
ct.SoLuongMua = reader.GetInt32(3);
ct.KhuyenMai = reader.GetInt32(4);
ct.ThanhTien = reader.GetDecimal(5);
ct.TrangThai = reader.GetBoolean(6);
lsCTHD.Add(ct);
}
//...
conn.Ngatketnoi();
return(lsCTHD);
}
public ChiTietHoaDonDTO GetRow(string maCTHoaDon)
{
try
{
var obj = new ChiTietHoaDonDTO();
if (_connection.State != ConnectionState.Open)
{
_connection.Open();
}
SqlCommand command = new SqlCommand("SELECT * FROM ChiTietHoaDon WHERE MaChiTietHoaDon = @machitiethoadon", _connection);
command.Parameters.Add("@machitiethoadon", SqlDbType.Char).Value = maCTHoaDon;
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
obj.MaChiTietHoaDon = reader["MaChiTietHoaDon"].ToString();
obj.MaHoaDon = reader["MaHoaDon"].ToString();
obj.MaSach = reader["MaSach"].ToString();
obj.SoLuongBan = (int)reader["SoLuongBan"];
obj.DonGiaBan = (decimal)reader["DonGiaBan"];
reader.Close();
}
return(obj);
}
catch (Exception ex)
{
_connection.Close();
Console.WriteLine(ex.Message);
}
return(null);
}
public List <ChiTietHoaDonDTO> DanhSachChiTietHD(string MAHD)
{
List <ChiTietHoaDonDTO> ds = new List <ChiTietHoaDonDTO>();
SqlConnection conn = DataProvider.TaoKetNoi();
string sql = "select * from CTHD where MAHD = '" + MAHD.Trim() + "'";
SqlDataReader sdr = DataProvider.TruyVanDuLieu(sql, conn);
ThucDonDAO td = new ThucDonDAO();
while (sdr.Read())
{
ChiTietHoaDonDTO a = new ChiTietHoaDonDTO()
{
MAHD = sdr.GetString(0),
MATD = sdr.GetString(1),
TENTHUCDON = td.dsThucDon().Find(o => o.MATD.Trim() == sdr.GetString(1).Trim()).TENTHUCDON,
SOLUONG = sdr.GetInt32(2),
GIA = sdr.GetDecimal(3).ToString("0,00 VNĐ"),
THANHTIEN = sdr.GetDecimal(4).ToString("0,00 VNĐ")
};
ds.Add(a);
}
sdr.Close();
conn.Close();
return(ds);
}
private void btnLapHoaDon_Click(object sender, EventArgs e)
{
if (dgvDanhSachPhongThanhToan.Rows.Count > 0)
{
HoaDonDTO hd = new HoaDonDTO();
List <ChiTietHoaDonDTO> dscthd = new List <ChiTietHoaDonDTO>();
for (int i = 0; i < dgvDanhSachPhongThanhToan.Rows.Count; i++)
{
ChiTietHoaDonDTO cthd = new ChiTietHoaDonDTO();
cthd.MaPhong = dgvDanhSachPhongThanhToan.Rows[i].Cells[1].Value.ToString();
cthd.SoNgayThue = int.Parse(dgvDanhSachPhongThanhToan.Rows[i].Cells[4].Value.ToString());
cthd.DonGia = double.Parse(dgvDanhSachPhongThanhToan.Rows[i].Cells[5].Value.ToString());
cthd.ThanhTien = double.Parse(dgvDanhSachPhongThanhToan.Rows[i].Cells[6].Value.ToString());
dscthd.Add(cthd);
}
hd.MaKhachHang = cbKhachHang.SelectedValue.ToString();
hd.NgayThanhToan = ngayThanhToan.Value.Date.ToString("yyyy-MM-dd");
hd.TriGia = double.Parse(txtTongGiaTri.Text);
BLL.ThemThanhToan(hd, dscthd);
MessageBox.Show("Thêm thành công");
dgvDanhSachPhongThanhToan.Rows.Clear();
txtTongGiaTri.Text = "0";
index = 0;
}
else
{
MessageBox.Show("Chưa Nhập Phòng Thanh Toán");
}
}
public void PoplistUser(List <CartGioHang> listUser)
{
string maHD, masp, tensp, size, color, soluong, tennv, tenkh;
int gia;
if (tbNV.Text == "" || tbKH.Text == "")
{
MessageBox.Show("Tên nhân viên hoặc tên khách hàng không bỏ trống");
}
else
{
tennv = tbNV.Text;
tenkh = tbKH.Text;
maHD = mahd.ToString();
for (int i = 0; i < listUser.Count; i++)
{
masp = listUser[i].Masp;
tensp = listUser[i].Tensp;
size = listUser[i].Sizee;
color = listUser[i].Color;
soluong = listUser[i].Soluong;
gia = listUser[i].Gia;
ChiTietHoaDonDTO items = new ChiTietHoaDonDTO(maHD, masp, tensp, size, color, soluong, gia, tennv, tenkh);
_HoaDon.Them_ChitietHD(items);
}
}
}
public List <ChiTietHoaDonDTO> LayChiTietHoaDonTheoBan(int tableId)
{
string query = String.Format(
"SELECT [Table].ID, Food.Name, Food.Unit, Food.Price, BillDetails.Quantity, (Food.Price * BillDetails.Quantity) AS Total " +
"FROM[Table] " +
"JOIN Bills ON[Table].ID = Bills.TableID " +
"JOIN BillDetails ON Bills.ID = BillDetails.InvoiceID " +
"JOIN Food ON Food.ID = BillDetails.FoodID " +
"WHERE[Table].ID = {0}", tableId
).ToString();
DataProvider provider = new DataProvider();
DataTable table = provider.ExecuteQuery(query);
List <ChiTietHoaDonDTO> dsChiTietHoaDon = new List <ChiTietHoaDonDTO>();
foreach (DataRow row in table.Rows)
{
int id = Convert.ToInt32(row["ID"]);
string name = row["Name"].ToString();
string unit = row["Unit"].ToString();
decimal price = Convert.ToDecimal(row["Price"]);
int quantity = Convert.ToInt32(row["Quantity"]);
decimal total = Convert.ToDecimal(row["Total"]);
ChiTietHoaDonDTO chiTietHoadon = new ChiTietHoaDonDTO(id, name, unit, price, quantity, total);
dsChiTietHoaDon.Add(chiTietHoadon);
}
return(dsChiTietHoaDon);
}
bool GopBan(string mahd1, string maban1, string mahd2, string maban2)
{
// lấy dánh sách chi tiết hóa đơn của hd1
// thực hiện cập nhật cthd của hd1 sang hd2
// nếu thức uống đã có trong cthd cua hd2 thì update lại sô lượng
// nếu thức uống chưa có thì thêm mới cthd của hd2
try
{
List <ChiTietHoaDonDTO> list = ChiTietHoaDonBUS.CTHD_List(mahd1);
foreach (ChiTietHoaDonDTO item in list)
{
DataTable dt = ChiTietHoaDonBUS.CTHD_KiemTraThucUongCoTrongCTHD(item.Tu_id, mahd2);
if (dt.Rows.Count > 0)
{
ChiTietHoaDonDTO cthd = new ChiTietHoaDonDTO();
cthd.Tu_id = item.Tu_id;
cthd.Hd_ma = mahd2;
cthd.Cthd_soluong = item.Cthd_soluong + int.Parse(dt.Rows[0]["cthd_soluong"].ToString());
ChiTietHoaDonBUS.CTHD_ThemXoaSuaHuyBan(cthd, 2);
}
else
{
ChiTietHoaDonDTO cthd = new ChiTietHoaDonDTO();
cthd.Tu_id = item.Tu_id;
cthd.Hd_ma = mahd2;
cthd.Cthd_soluong = item.Cthd_soluong;
ChiTietHoaDonBUS.CTHD_ThemXoaSuaHuyBan(cthd, 1);
}
}
return(true);
}
catch (Exception) { return(false); }
}
public void GetListChiTietHoaDon()
{
var data = GenerateDataTable <ChiTietHoaDonDTO>(10);
mockIDataProvider.Setup(x => x.ExecuteQuery(It.IsNotNull <string>(), null)).Returns(data);
var expectResult = new List <ChiTietHoaDonDTO>();
foreach (DataRow item in data.Rows)
{
ChiTietHoaDonDTO hang = new ChiTietHoaDonDTO(item);
expectResult.Add(hang);
}
bool acc = false;
var result = quanLyThongTinBUS.GetListChiTietHoaDon();
for (int i = 0; i < result.LongCount(); i++)
{
acc = result[i].FltDonGia.Equals(expectResult[i].FltDonGia) &&
result[i].IntMaHoaDon.Equals(expectResult[i].IntMaHoaDon) &&
result[i].IntSoLuong.Equals(expectResult[i].IntSoLuong) &&
result[i].StrMaHang.Equals(expectResult[i].StrMaHang);
}
//var cc= result.SequenceEqual(expectResult);
//var first = result.Except(expectResult).ToList();
//var second = expectResult.Except(result).ToList();
Assert.IsTrue(acc);
mockIDataProvider.VerifyAll();
}
private void BtnApDung_Click(object sender, EventArgs e)
{
if (tienthoi < 0)
{
MessageBox.Show("Khách chưa thanh toán đủ số tiền!");
}
else
{
HoaDonDTO hd = new HoaDonDTO();
int maHT = HoaDonDAO.Instance.getNewCode();
string phanSau = maHT.ToString();
while (phanSau.Length < 18)
{
phanSau = "0" + phanSau;
}
hd.MaHD = "HD" + phanSau;
hd.TenKH = od.KhachHang.TenKH;
hd.MaKH = od.KhachHang.MaKH;
hd.DiaChi = od.KhachHang.DiaChi;
hd.MaSoThue = od.KhachHang.MaSoThue;
hd.SoDienThoai = od.KhachHang.SoDienThoai;
hd.NgayTao = od.Thoigiantao;
hd.GiamGia = 0;
hd.Thue = 0;
hd.PhuThu = 0;
hd.Tong = tongtien;
hd.NhanVien = od.NhanVien.TenNV;
try
{
if (HoaDonDAO.Instance.Insert(hd))
{
List <ChiTietOrderDTO> list = ChiTietOrderDAO.Instance.GetListTamTinh(od.getID());
foreach (ChiTietOrderDTO ct in list)
{
ChiTietHoaDonDTO cthd = new ChiTietHoaDonDTO();
cthd.MaHD = hd.MaHD;
cthd.SanPham = ct.SanPham.TenSP;
cthd.MaSP = ct.SanPham.MaSP;
cthd.SoLuong = ct.SoLuong;
cthd.DonGia = ct.SanPham.GiaBan;
if (!ChiTietHoaDonDAO.Instance.Insert(cthd))
{
MessageBox.Show("Loi CT hoa DOn");
break;
}
}
}
}
catch
{
MessageBox.Show("Loi them hoa don");
}
BanDAO.Instance.SetTrangThai(3, od.Ban.MaBan);
fmOrder.backToBanHang();
this.Close();
}
}
private void dgv_CTHD_SelectionChanged(object sender, EventArgs e)
{
if (dgv_CTHD.SelectedRows.Count > 0)
{
ctHDHienHanh = null;
ctHDHienHanh = (ChiTietHoaDonDTO)dgv_CTHD.SelectedRows[0].DataBoundItem;
}
}
public bool Them_ChitietHD(ChiTietHoaDonDTO items)
{
if (items.MaHD == "" || items.MaSP == "" || items.TenSP == "" || items.Size == "" || items.Color == "" || items.Soluong == "" || items.Gia == null || items.TenNV == "" || items.TenKH == "")
{
return(false);
}
return(HoaDonDAL.Instance.ThemChiTiet_HD(items));
}
public bool AddCTHD(ChiTietHoaDonDTO ctHoaDon)
{
string sQuery = string.Format("INSERT INTO CTHOADON(MA_HD,MA_SP,SL,DVT,DONGIA,THANHTIEN) VALUES('{0}','{1}',{2},'{3}',{4},'{5}')"
, ctHoaDon.MA_HD, ctHoaDon.MA_SP, ctHoaDon.SL, ctHoaDon.DVT, ctHoaDon.DONGIA, ctHoaDon.SL * ctHoaDon.DONGIA);
SqlParameter[] sqlParameters = new SqlParameter[0];
return(executeInsertQuery(sQuery, sqlParameters));
}
public static ChiTietHoaDon MappingChiTietHoaDon(this ChiTietHoaDonDTO ChiTietHoaDonDTO)
{
return(new ChiTietHoaDon
{
HangHoaId = ChiTietHoaDonDTO.HangHoaId,
HoaDonId = ChiTietHoaDonDTO.HoaDonId,
SoLuong = ChiTietHoaDonDTO.SoLuong,
DonGia = ChiTietHoaDonDTO.DonGia,
});
}
public bool CapNhatSLCTHD(ChiTietHoaDonDTO ctHDHienHanh)
{
SqlConnection con = DataProvider.TaoKetNoi();
string updatehd = "update HOADON set TONGTHANHTOAN = TONGTHANHTOAN + " + ctHDHienHanh.THANHTIEN.Replace("VNĐ", "").Replace(".", "") + " where MAHD = '" + ctHDHienHanh.MAHD + "'";
bool kq = DataProvider.ThucThi(updatehd, con);
string updateCTHD = "update CTHD SET SOLUONG = SOLUONG + " + ctHDHienHanh.SOLUONG + " ,THANHTIEN = THANHTIEN + " + ctHDHienHanh.THANHTIEN.Replace("VNĐ", "").Replace(".", "") + " where MATD = '" + ctHDHienHanh.MATD + "'";
bool thucthi = DataProvider.ThucThi(updateCTHD, con);
return(thucthi);
}
private bool KiemTraTDbiTrung(ChiTietHoaDonDTO ctHDHienHanh)
{
for (int i = 0; i < dgv_CTHD.Rows.Count; i++)
{
if (dgv_CTHD.Rows[i].Cells[1].Value.ToString().Trim() == ctHDHienHanh.MATD.Trim())
{
return(true);
}
}
return(false);
}
public bool UpdateChiTietHD(ChiTietHoaDonDTO cthd)
{
if (objCTHD.IsRowExists(cthd.MaChiTietHoaDon) && objHD.IsRowExists(cthd.MaHoaDon))
{
return(objCTHD.UpdateRow(cthd));
}
else
{
return(false);
}
}
public bool AddChiTietHD(ChiTietHoaDonDTO cthd)
{
if (objHD.IsRowExists(cthd.MaHoaDon) && !objCTHD.IsRowExists(cthd.MaChiTietHoaDon))
{
return(objCTHD.AddRow(cthd));
}
else
{
return(false);
}
}
public void ThemChiTietHoaDon(ChiTietHoaDonDTO CT)
{
string query = "INSERT INTO CHITIETHOADON(MAHOADON, MAHANG, SOLUONG) VALUES (@MaHD, @MaHang, @SoLuong)";
List <SqlParameter> inserted_values = new List <SqlParameter>
{
new SqlParameter("@MaHD", CT.maHoaDon),
new SqlParameter("@MaHang", CT.maHang),
new SqlParameter("@SoLuong", CT.soLuong)
};
db.ExecuteNonQuery(query, inserted_values);
}
private void add()
{
hoaDonDTO = new HoaDonDTO();
chiTietHoaDonDTO = new ChiTietHoaDonDTO();
hoaDonDTO.maHD = drinksBUS.autogenerate_maHOADON();
hoaDonDTO.maKH = 1;
hoaDonDTO.maNhanVien = 2;
hoaDonDTO.ngaytaohoadon = DateTime.Now.Date;
chiTietHoaDonDTO.maHD = hoaDonDTO.maHD;
chiTietHoaDonDTO.maloaiHoaDon = 4;
chiTietHoaDonDTO.trigiaHoaDon = Convert.ToInt32(numericUpDown1.Value) * cleanwaterDTO.DonGiaMua + Convert.ToInt32(numericUpDown2.Value) * reviveDTO.DonGiaMua;
}
/// <summary>
/// Trả về danh sách các dòng trong bảng ChiTietHoaDon
/// </summary>
/// <returns></returns>
public List <ChiTietHoaDonDTO> GetListChiTietHoaDon()
{
List <ChiTietHoaDonDTO> list = new List <ChiTietHoaDonDTO>();
var data = dataProvider.ExecuteQuery("SELECT cthd.* FROM dbo.ChiTietHoaDon cthd");
foreach (DataRow item in data.Rows)
{
ChiTietHoaDonDTO hang = new ChiTietHoaDonDTO(item);
list.Add(hang);
}
return(list);
//throw new NotImplementedException();
}
private void btnban1sangban2_Click(object sender, EventArgs e)
{
string maban1 = cbchonban1.SelectedValue.ToString();
DataTable dt = HoaDonBUS.HoaDon_LayHoaDonTheoMaBan(maban1);
string mahd1 = dt.Rows[0]["hd_id"].ToString();
string maban2 = cbchonban2.SelectedValue.ToString();
DataTable dt2 = HoaDonBUS.HoaDon_LayHoaDonTheoMaBan(maban2);
string mahd2 = dt2.Rows[0]["hd_id"].ToString();
listCTHD1 = ChiTietHoaDonBUS.CTHD_List(mahd1);
listCTHD2 = ChiTietHoaDonBUS.CTHD_List(mahd2);
DialogResult dialogResult = XtraMessageBox.Show("Bạn có chắc chắn muốn GỘP '" + cbchonban1.Text + "'" + " sang " + "'" + cbchonban2.Text + "' ?", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dialogResult == DialogResult.Yes)
{
if (GopBan(mahd1, maban1, mahd2, maban2))
{
ChiTietHoaDonDTO cthd = new ChiTietHoaDonDTO();
cthd.Hd_ma = mahd1;
if (ChiTietHoaDonBUS.CTHD_ThemXoaSuaHuyBan(cthd, 4))
{
HoaDonDTO hd = new HoaDonDTO();
hd.Hd_id = mahd1;
if (HoaDonBUS.HoaDon_ThemXoaSuaHuyBan(hd, 4))
{
if (!BanBUS.Ban_CapNhatTrangThaiBan(maban1, "Trống"))
{
XtraMessageBox.Show("Lỗi không cập nhật được trạng thái Bàn!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
XtraMessageBox.Show("Đã GỘP " + cbchonban1.Text + "sang" + cbchonban2.Text + "!!!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
gridHoaDon1.DataSource = null;
gridHoaDon2.DataSource = Load_HoaDonTheoMaBan(maban2);
}
}
else
{
XtraMessageBox.Show("Lỗi không xóa Hóa Đơn!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
XtraMessageBox.Show("Lỗi không xóa được Chi Tiết Hóa Đơn!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
DialogResult = DialogResult.OK;
}
/// <summary>
/// sữa thông tin chi tiết hóa đơn
/// </summary>
/// <param name="cthd"></param>
public static void Update_CTHD(ChiTietHoaDonDTO cthd)
{
try
{
cnn = DataProvider.ConnectData();
string update = string.Format(" UPDATE chi_tiet_hd SET ma_sp = '{2}', so_luong='{3}' WHERE ma_hd = '{1}' and id = '{0}'; UPDATE chi_tiet_hd SET thanh_tien='{4}' WHERE id = '{0}'; ", cthd.id, cthd.ma_hd, cthd.ma_sp, cthd.soluong, cthd.thanhtien);
DataProvider.Execute(cnn, update);
cnn.Close();
}
catch (Exception ex)
{
throw ex;
}
}
public static List <ChiTietHoaDonDTO> CTHD_List(string mahd)
{
DataTable dt = CTHD_LoadTheoMaHD(mahd);
List <ChiTietHoaDonDTO> list = new List <ChiTietHoaDonDTO>();
for (int i = 0; i < dt.Rows.Count; i++)
{
ChiTietHoaDonDTO cthd = new ChiTietHoaDonDTO();
cthd.Tu_id = int.Parse(dt.Rows[i]["tu_id"].ToString());
cthd.Hd_ma = dt.Rows[i]["hd_id"].ToString();
cthd.Cthd_soluong = int.Parse(dt.Rows[i]["cthd_soluong"].ToString());
list.Add(cthd);
}
return(list);
}
public static void insert_CTHD(ChiTietHoaDonDTO cthd)
{
try
{
cnn = DataProvider.ConnectData();
string insert = string.Format("insert into chi_tiet_hd(ma_hd,ma_sp,so_luong,thanh_tien) values ('{0}','{1}','{2}','{3}');",
cthd.ma_hd, cthd.ma_sp, cthd.soluong, cthd.thanhtien);
DataProvider.Execute(cnn, insert);
cnn.Close();
}
catch (Exception ex)
{
throw ex;
}
}
public IHttpActionResult UpdateCTHD(ChiTietHoaDonDTO chitiethoadonDTO)
{
var chitiet = entities.ChiTietHoaDons.Include("HoaDonXuat")
.Where(s => s.HoaDonXuatID == chitiethoadonDTO.HoaDonXuatID && s.SanPhamID == chitiethoadonDTO.SanPhamID)
.FirstOrDefault();
if (chitiet == null)
{
return(NotFound());
}
chitiet.HoaDonXuatID = chitiethoadonDTO.HoaDonXuatID;
chitiet.SanPhamID = chitiethoadonDTO.SanPhamID;
chitiet.SoLuong = chitiethoadonDTO.SoLuong;
entities.SaveChanges();
return(Ok());
}
private void lv_thucDon_SelectedIndexChanged(object sender, EventArgs e)
{
if (lv_thucDon.SelectedItems.Count > 0)
{
ListViewItem item = lv_thucDon.SelectedItems[0];
ctHDHienHanh = new ChiTietHoaDonDTO()
{
MAHD = FrmQLHoaDon.hdHienHanh.MAHD.Trim(),
MATD = item.SubItems[1].Text,
TENTHUCDON = item.SubItems[0].Text,
SOLUONG = 1,
GIA = item.SubItems[2].Text,
THANHTIEN = (1 * int.Parse(item.SubItems[2].Text)).ToString()
};
}
Bind();
}
public List <ChiTietHoaDonDTO> DocChiTietHoaDon(int MaHD)
{
string query = "SELECT CT.MACHITIETHOADON, CT.MAHANG, TENHANG, CT.SOLUONG, (HG.DONGIA * CT.SOLUONG) AS DONGIA FROM CHITIETHOADON CT INNER JOIN HANG HG ON CT.MAHOADON = @MaHD AND CT.MAHANG = HG.MAHANG";
List <SqlParameter> Find_values = new List <SqlParameter>
{
new SqlParameter("@MaHD", MaHD)
};
DataTable dt = db.ExecuteQuery(query, Find_values);
List <ChiTietHoaDonDTO> ret = new List <ChiTietHoaDonDTO>();
foreach (DataRow dr in dt.Rows)
{
ChiTietHoaDonDTO temp = new ChiTietHoaDonDTO((int)dr["MACHITIETHOADON"], (int)dr["MAHANG"], dr["TENHANG"].ToString(), MaHD, (int)dr["SOLUONG"], Convert.ToSingle(dr["DONGIA"]));
ret.Add(temp);
}
return(ret);
}
private void btn_XoaChiTietHD_Click(object sender, EventArgs e)
{
ChiTietHoaDonDTO cthd = new ChiTietHoaDonDTO();
cthd.Tu_id = int.Parse(gridViewCTHD.GetRowCellValue(gridViewCTHD.FocusedRowHandle, "tu_id").ToString());
cthd.Hd_ma = txtmahd.Text;
DialogResult dialogResult = XtraMessageBox.Show("Bạn có chắc chắn muốn xóa thức uống vừa chọn", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dialogResult == DialogResult.Yes)
{
if (!ChiTietHoaDonBUS.CTHD_ThemXoaSuaHuyBan(cthd, 3))
{
XtraMessageBox.Show("Lỗi", "Thông báo");
}
gridCTHD_Load(txtmahd.Text);
txtThanhTien_txtTongCong_Load();
}
}
