public int delPhat(string maphat)
{
try
{
CHITIETPHAT ph = linqToMySQL.CHITIETPHATs.Where(t => t.MAPHAT == maphat).FirstOrDefault();
ph.GHICHU = "1";
linqToMySQL.SubmitChanges();
return(1);
}
catch { return(0); }
}
////XuLy
//public double tienphat(DateTime ngaydukien,DateTime ngaytra)
//{
// double day = (ngaytra - ngaydukien).TotalDays;
// day = (double) Math.Round((decimal)day);
// if (day < 1)
// return 0;
// else
// {
// return day * 1000;
// }
//}
public bool ktSVPhat(string masv)
{
List <PHAT> phat = linqToMySQL.PHATs.Where(t => t.MADG == masv).Select(t => t).ToList <PHAT>();
foreach (PHAT item in phat)
{
CHITIETPHAT ct = linqToMySQL.CHITIETPHATs.Where(t => t.MAPHAT == item.MAPHAT).Select(t => t).FirstOrDefault();
if (ct != null && ct.GHICHU == "0")
{
return(false);
}
}
return(true);
}
public void addCTPhat(string maphat, string loai, string masach, int ngayquahan)
{
CHITIETPHAT ct = new CHITIETPHAT();
ct.MAPHAT = maphat;
ct.MALOAIVIPHAM = loai;
ct.GHICHU = "0";
DIEUKHOANVIPHAM dk = linqToMySQL.DIEUKHOANVIPHAMs.Where(t => t.MADIEUKHOAN == loai).Select(t => t).FirstOrDefault();
if (dk.MADIEUKHOAN == "DK001")
{
ct.TIENPHAT = dk.SOTIENPHAT * ngayquahan;
}
else
{
SACH s = linqToMySQL.SACHES.Where(t => t.MASACH == masach).Select(t => t).FirstOrDefault();
ct.TIENPHAT = dk.SOTIENPHAT / 100 * s.GIA;
}
linqToMySQL.CHITIETPHATs.InsertOnSubmit(ct);
linqToMySQL.SubmitChanges();
}