public object Laytatcathongtin(string bang, string cotdieukien, string dieukientimkiem, object giatri)
{
db = new QLMaEntities();
string s = "select * from " + bang + " where " + cotdieukien + " " + dieukientimkiem + " '" + giatri + "'";
if (bang == "NguoiDungs")
{
return(db.NguoiDungs.SqlQuery(s).DefaultIfEmpty().ToList());
}
else if (bang == "Mas")
{
return(db.Mas.SqlQuery(s).DefaultIfEmpty().ToList());
}
else if (bang == "LogDangNhaps")
{
return(db.LogDangNhaps.SqlQuery(s).DefaultIfEmpty().ToList());
}
else if (bang == "LogDangXuats")
{
return(db.LogDangXuats.SqlQuery(s).DefaultIfEmpty().ToList());
}
else
{
return(db.LSKhoas.SqlQuery(s).DefaultIfEmpty().ToList());
}
}
public object Login(string tk, string mk)
{
db = new QLMaEntities();
var a = (from c in db.NguoiDungs
where c.TaiKhoan == tk && c.MatKhau == mk
select c).FirstOrDefault();
return(a);
}
public void LichsuDX(int idND)
{
db = new QLMaEntities();
var ls = new LogDangXuat();
ls.IdND = idND;
ls.ThoiGianDX = DateTime.Now;
db.LogDangXuats.Add(ls);
db.SaveChanges();
}
public List <Ma> Thongke(DateTime frm, DateTime to)
{
to = to.AddDays(1);
db = new QLMaEntities();
List <Ma> dsma = (from n in db.Mas
where (n.ThoiGianKhoiTao >= frm.Date && n.ThoiGianKhoiTao <= to.Date)
select n).ToList();
return(dsma);
}
public object getinfo(string bang, int id)
{
db = new QLMaEntities();
if (bang == "NguoiDungs")
{
NguoiDung n = db.NguoiDungs.Where(c => c.IdND == id).FirstOrDefault();
return(n);
}
LSKhoa ls = db.LSKhoas.Where(c => c.IdDTKhoa == id && c.DoiTuong == false).FirstOrDefault();
return(ls);
}
public object Laytatcathongtin(string bang)
{
db = new QLMaEntities();
if (bang == "NguoiDungs")
{
return((from c in db.NguoiDungs select c).DefaultIfEmpty().ToList());
}
else if (bang == "Mas")
{
return((from c in db.Mas select c).DefaultIfEmpty().ToList());
}
else if (bang == "LogDangNhaps")
{
return((from c in db.LogDangNhaps select c).DefaultIfEmpty().ToList());
}
else if (bang == "LogDangXuats")
{
return((from c in db.LogDangXuats select c).DefaultIfEmpty().ToList());
}
else
{
return((from c in db.LSKhoas select c).DefaultIfEmpty().ToList());
}
}
