public void Delete(Guid CaThiID, Guid MonThiID, Guid PhongThiID) { CtMtsController ctmt = new CtMtsController(); Guid? ctmtID = ctmt.GetCtMtID(CaThiID, MonThiID); DiaDiem diadiem = db.DiaDiem.Where(u => u.CaMtId == ctmtID && u.PhongThiId == PhongThiID).FirstOrDefault(); db.DiaDiem.Remove(diadiem); db.SaveChanges(); }
public IQueryable <PhongThi> GetByCtMt(Guid CaThiID, Guid MonThiID) { CtMtsController ctmt = new CtMtsController(); Guid? ctmtID = ctmt.GetCtMtID(CaThiID, MonThiID); IQueryable <PhongThi> temp = db.PhongThi.FromSqlRaw("SELECT PhongThi.* FROM PhongThi " + "INNER JOIN DiaDiem ON DiaDiem.PhongThiID = PhongThi.PhongThiID " + $"WHERE DiaDiem.CaMtID = '{ctmtID}'").OrderBy(u => u.PhongThiName); return(temp); }
public IQueryable <User> GetByDiaDiem(Guid CaThiID, Guid MonThiID, Guid PhongThiID) { CtMtsController ctmt = new CtMtsController(); Guid? camtid = ctmt.GetCtMtID(CaThiID, MonThiID); DiaDiemsController diadiem = new DiaDiemsController(); Guid? diadiemid = diadiem.GetDiaDiemID(PhongThiID, camtid); string query = "SELECT [User].* FROM [User] " + "INNER JOIN SV_DiaDiem ON SV_DiaDiem.UserID = [User].UserID " + $"WHERE SV_DiaDiem.DiaDiemID = '{diadiemid}'"; IQueryable <User> user = db.User.FromSqlRaw(query); return(user); }
public void Add(Guid CaThiID, Guid MonThiID, Guid PhongThiID) { CtMtsController ctmt = new CtMtsController(); Guid? ctmtID = ctmt.GetCtMtID(CaThiID, MonThiID); bool isValid = db.DiaDiem.Where(u => u.CaMtId == ctmtID && u.PhongThiId == PhongThiID).Count() == 0; if (isValid) { DiaDiem diadiem = new DiaDiem(); diadiem.DiaDiemId = Guid.NewGuid(); diadiem.CaMtId = ctmtID; diadiem.PhongThiId = PhongThiID; db.DiaDiem.Add(diadiem); db.SaveChanges(); } }