public List <LichSuGD> getVanTinLichSuKH(DateTime dt1, DateTime dt2, string KH)
{
try
{
LichSuGD lsgd = new LichSuGD();
List <LichSuGD> listLSGD = new List <LichSuGD>();
var dh = (from a in data.Payments join b in data.DonHangs on a.MaDH equals b.MaDH where b.MaKH == KH select new { a, b });
if (dh.Count() != 0)
{
var filter = dh.Where(a => a.a.Ngay > dt1 && a.a.Ngay < dt2);
foreach (var i in filter)
{
lsgd.MGD = i.a.MaGD;
lsgd.ngay = i.a.Ngay;
lsgd.phi = i.a.Phi;
lsgd.sotien = i.b.SoTien;
listLSGD.Add(lsgd);
}
return(listLSGD);
}
else
{
return(null);
}
}
catch { return(null); }
}
public LichSuGD getLichSuGd(int MGD)
{
try
{
LichSuGD lsgd = new LichSuGD();
if (data.Payments.Where(a => a.MaGD == MGD).Count() != 0)
{
DateTime date = new DateTime();
Payment pm = data.Payments.Where(a => a.MaGD == MGD).Single();
DonHang dh = data.DonHangs.Where(a => a.MaDH == pm.MaDH).Single();
lsgd.MGD = MGD;
lsgd.ngay = date;
lsgd.phi = pm.Phi;
lsgd.sotien = dh.SoTien;
return(lsgd);
}
else
{
return(null);
}
}
catch { return(null); }
}