private void dgvCongNo_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (this.dgvCongNo.CurrentRow.Selected)
{
this.dangThayDoiDL = true;
this.btnXacNhanThanhToan.Enabled = true;
this.txtSoTienTraHomNay.Enabled = true;
this.dateTimePickerNgayTra.Enabled = true;
this.btnCapNhatHanTraNo.Enabled = true;
cn = lstCongNo.Where(p => p.MACONGNO == this.dgvCongNo.CurrentRow.Cells["MACONGNO"].Value.ToString() && p.TRANGTHAI == true).FirstOrDefault();
KHACHHANG kh = KhachHangBUS.LayThongTin(this.dgvCongNo.CurrentRow.Cells["MAKHCongNo"].Value.ToString());
this.lblTenkh.Text = kh.TENKH;
this.lblDiaChi.Text = kh.DIACHI;
this.lblSDT.Text = kh.SDT;
//tongTien = this.dgvCongNo.CurrentRow.Cells["TONGTIENCN"].Value.ToString();
//tienConNo = this.dgvCongNo.CurrentRow.Cells["TIENCONNOCN"].Value.ToString();
this.lblTongTien.Text = Convert.ToDecimal(cn.TONGTIEN).ToString("#,##0") + " VND";
this.lblTienConNo.Text = Convert.ToDecimal(cn.TIENCONNO).ToString("#,##0") + " VND";
this.dateTimePickerNgayTra.Value = Convert.ToDateTime(this.dgvCongNo.CurrentRow.Cells["NGAYTRA"].Value);
}
else
{
Reset();
}
}
private static CONGNO LayBaoCao()
{
CONGNO cn = (from c in db.CONGNOes
orderby c.MaCongNo descending
select c).FirstOrDefault();
return(cn);
}
public static bool TimBaoCao(int thang, int nam)
{
CONGNO cn = (from t in db.CONGNOes
where t.NgayBatDau.Value.Month == thang && t.NgayBatDau.Value.Year == nam
select t).SingleOrDefault();
if (cn == null)
{
return(false);
}
return(true);
}
public static bool ThemCongNo(CONGNO congno)
{
return(CongNoDAO.ThemCongNo(congno));
}
public static bool CapNhatCongNo(CONGNO congno)
{
return(CongNoDAO.CapNhatCongNo(congno));
}
public static void ThemBaoCao(int thang, int nam)
{
// tìm ngày bắt đầu và kết thúc
DateTime NgayBD = new DateTime(nam, thang, 1);
DateTime NgayKT = new DateTime(nam, thang, 30);
switch (thang)
{
case 1:
case 3:
case 5:
case 7:
case 8:
case 10:
case 12:
NgayKT = new DateTime(nam, thang, 31);
break;
case 2:
NgayKT = new DateTime(nam, thang, 28);
if (NgayKT.AddDays(1).Month == thang)
{
NgayKT = NgayKT.AddDays(1);
}
break;
case 4:
case 6:
case 9:
case 11:
NgayKT = new DateTime(nam, thang, 30);
break;
}
// Bước 2: Lập báo cáo
List <CHITIETCONGNO> DsChiTiet = new List <CHITIETCONGNO>();
// Lấy báo cáo gần nhất
int MaCongNo = LayBaoCao().MaCongNo;
List <CHITIETCONGNO> DsChiTietGanNhat = (from ct in db.CHITIETCONGNOes
where ct.MaCongNo == MaCongNo
select ct).ToList();
IEnumerable <KHACHHANG> DsKhachHang = from kh in db.KHACHHANGs
select kh;
foreach (KHACHHANG kh in DsKhachHang)
{
CHITIETCONGNO cur = new CHITIETCONGNO();
cur.MaKH = kh.MaKH;
double NoDauKy = 0;
CHITIETCONGNO chitiet = DsChiTietGanNhat.Find(ct => ct.MaKH == kh.MaKH);
if (chitiet != null)
{
NoDauKy = chitiet.NoCuoi.Value;
}
cur.NoDau = NoDauKy;
double NoCuoiKy = 0;
List <HOADON> hd = (from h in db.HOADONs
where h.NgayHoaDon.Value.Month == thang && h.NgayHoaDon.Value.Year == nam && h.MaKH == kh.MaKH
select h).ToList();
List <THANHTOAN> tt = (from t in db.THANHTOANs
where t.NgayThanhToan.Value.Month == thang && t.NgayThanhToan.Value.Year == nam && t.MaKhachHang == kh.MaKH
select t).ToList();
double NoTrongKy = 0;
if (hd != null)
{
NoTrongKy = hd.Sum(h => h.TongTien.Value);
}
double ThanhToanTrongKy = 0;
if (tt != null)
{
ThanhToanTrongKy = tt.Sum(h => h.SoTien.Value);
}
cur.NoCuoi = NoDauKy + NoTrongKy - ThanhToanTrongKy;
DsChiTiet.Add(cur);
}
CONGNO congco = new CONGNO {
NgayBatDau = NgayBD, NgayKetThuc = NgayKT
};
try
{
db.CONGNOes.Add(congco);
db.SaveChanges();
}
catch { }
MaCongNo = LayBaoCao().MaCongNo;
foreach (CHITIETCONGNO ct in DsChiTiet)
{
ct.MaCongNo = MaCongNo;
db.CHITIETCONGNOes.Add(ct);
}
db.SaveChanges();
}
