private void btnLapHD_Click(object sender, EventArgs e)
{
var result = from c in db.HoaDonTTs select c;
HoaDonTT hd = new HoaDonTT()
{
MaHoaDon = "HD" + (result.Count() + 1),
MaKhachhang = txtMaKH.Text,
NgayThanhToan = Convert.ToDateTime(txtNgayTT.Text),
TriGia = float.Parse(txtTriGia.Text),
Xoa = 0
};
db.HoaDonTTs.Add(hd);
string mahoadon = "HD" + (result.Count() + 1);
for (int i = 0; i < dgvHoaDon.Rows.Count; i++)
{
var re = from c in db.CT_HoaDon select c;
CT_HoaDon ct = new CT_HoaDon()
{
MaCTHoaDon = "CTHD" + (re.Count() + 1),
MaHoaDon = mahoadon,
MaPhieuThuePhong = dgvHoaDon[0, i].Value.ToString(),
SoNgayThue = int.Parse(dgvHoaDon[3, i].Value.ToString()),
ThanhTien = float.Parse(dgvHoaDon[4, i].Value.ToString()),
TriGia = float.Parse(dgvHoaDon[5, i].Value.ToString())
};
db.CT_HoaDon.Add(ct);
db.SaveChanges();
}
db.SaveChanges();
MessageBox.Show("Lập hóa đơn thành công");
}
private void btnXoaHD_Click(object sender, EventArgs e)
{
string mahd = txtMaHD.Text;
HoaDonTT hd = db.HoaDonTTs.Find(mahd);
if (hd == null)
{
MessageBox.Show("Có lỗi xảy ra.");
return;
}
hd.Xoa = 1;
db.SaveChanges();
if (db.SaveChanges() == 0)
{
MessageBox.Show("Xóa thành công hóa đơn này");
ResetForm();
}
}
private void txtMaHD_TextChanged(object sender, EventArgs e)
{
if (txtMaHD.Text == "")
{
return;
}
string mahd = txtMaHD.Text;
HoaDonTT hd = db.HoaDonTTs.Find(mahd);
txtMaKH.Text = hd.MaKhachhang;
KhachHang kh = db.KhachHangs.Find(hd.MaKhachhang);
txtKhach.Text = kh.TenKhachHang;
txtDiaChi.Text = kh.DiaChi;
txtNgayTT.Text = String.Format("{0:d/M/yyyy}", hd.NgayThanhToan);
var result = from c in db.CT_HoaDon
from a in db.PhieuThuePhongs
from b in db.Phongs
where (c.MaHoaDon == mahd && c.MaPhieuThuePhong == a.MaPhieuThuePhong && a.MaPhong == b.MaPhong)
select new { c.MaPhieuThuePhong, a.MaPhong, c.SoNgayThue, c.ThanhTien, c.TriGia, b.TenPhong };
string[] row1;
foreach (var i in result)
{
row1 = new string[] {
i.MaPhieuThuePhong,
i.MaPhong,
i.TenPhong,
i.SoNgayThue.ToString(),
i.ThanhTien.ToString(),
i.TriGia.ToString()
};
dgvHoaDon.Rows.Add(row1);
}
}
private void btnUpdateHD_Click(object sender, EventArgs e)
{
string mahd = txtMaHD.Text;
HoaDonTT hd = db.HoaDonTTs.Find(mahd);
for (int i = 0; i < (dgvHoaDon.Rows.Count - 1); i++)
{
string maptp = dgvHoaDon[0, i].Value.ToString();
CT_HoaDon ctd = db.CT_HoaDon.Find(maptp);
int songaythue = int.Parse(dgvHoaDon[2, i].Value.ToString());
double thanhtien = double.Parse(dgvHoaDon[4, i].Value.ToString());
double dongia = double.Parse(dgvHoaDon[3, i].Value.ToString());
if (ctd != null)
{
ctd.SoNgayThue = songaythue;
ctd.TriGia = thanhtien;
}
else
{
var result = from c in db.CT_HoaDon select c;
int id = 0;
foreach (var a in result)
{
id = id + 1;
}
CT_HoaDon cthd = new CT_HoaDon()
{
MaCTHoaDon = "CTHD" + (id + 1),
MaHoaDon = mahd,
MaPhieuThuePhong = maptp,
SoNgayThue = songaythue,
ThanhTien = dongia,
TriGia = thanhtien
};
db.CT_HoaDon.Add(cthd);
}
}
var re = from c in db.CT_HoaDon where c.MaHoaDon == mahd select c;
foreach (var b in re)
{
int check = 0;
for (int i = 0; i < dgvHoaDon.Rows.Count - 1; i++)
{
if (dgvHoaDon[0, i].Value.ToString() == b.MaPhieuThuePhong)
{
check = check + 1;
}
}
if (check == 0)
{
db.CT_HoaDon.Remove(b);
}
}
double trigia = double.Parse(txtTriGia.Text);
hd.TriGia = trigia;
db.SaveChanges();
if (db.SaveChanges() == 0)
{
MessageBox.Show("Cập nhật hóa đơn thành công");
}
}
