public ActionResult Search(string q, int?limit)
{
q = q.RemoveDiacritics();
limit = limit ?? 50; //make sure we have a default limit
var schedule = MvcApplication.GetSchedule();
//search for people
//TODO: rename name to jmeno
var people = String.IsNullOrEmpty(q) ? null : (from student in schedule.STUDENTI
where student.login.StartsWith(q, StringComparison.OrdinalIgnoreCase) ||
student.jmeno.RemoveDiacritics().StartsWith(q, StringComparison.OrdinalIgnoreCase) ||
student.prijmeni.RemoveDiacritics().StartsWith(q, StringComparison.OrdinalIgnoreCase)
select new { id = student.id, typ = "student", name = String.Format("{0} {1}", student.jmeno, student.prijmeni) })
.Union(from ucitel in schedule.UCITELE
where (!String.IsNullOrEmpty(ucitel.login) && ucitel.login.StartsWith(q, StringComparison.OrdinalIgnoreCase)) ||
(!String.IsNullOrEmpty(ucitel.jmeno) && ucitel.jmeno.RemoveDiacritics().StartsWith(q, StringComparison.OrdinalIgnoreCase)) ||
(!String.IsNullOrEmpty(ucitel.prijmeni) && ucitel.prijmeni.RemoveDiacritics().StartsWith(q, StringComparison.OrdinalIgnoreCase))
select new { id = ucitel.id, typ = "ucitel", name = String.Format("{0} {1}", ucitel.jmeno, ucitel.prijmeni) }).Take(limit.Value).ToList();
//assemble the resulting JSON
var results = new
{
success = (people != null) && (people.Count > 0),
results = people
};
return(Json(results, JsonRequestBehavior.AllowGet));
}
public ActionResult Schedule(string id)
{
var data = MvcApplication.GetSchedule();
var minDate = DateTime.Now.AddHours(-2);
//query schedule
var events = (from stud in data.STUDENTI
join rel in data.LISTKY_STUDENTU on stud.id equals rel.student_id
join list in data.LISTKY on rel.listek_id equals list.id
join pred in data.PREDMETY on list.predmet_id equals pred.id
join mist in data.MISTNOSTI on list.mistnost_id equals mist.id
let date = GetDate(list.den_cis, list.zacatek)
let week = (date.WeekNumber() % 2 == 0) ? "S" : "L"//get even/odd week
where String.Equals(stud.id, id) &&
(date != DateTime.MinValue) && //eliminate invalid dates coming from the parsing function
date > minDate &&
(String.IsNullOrEmpty(list.sudy_lichy) || String.Equals(list.sudy_lichy, week))
select new
{
co = pred.nazev,
kde = mist.cislo,
kdy = date
//pocet_hodin = list.pocet_hodin
}).ToList();
//TODO: add limit to time when schedule is returned (only during term)?
if ((events != null) && (events.Count > 0))
{
return(Json(new { success = true, results = events }, JsonRequestBehavior.AllowGet));
}
events = (from teacher in data.UCITELE
join list in data.LISTKY on teacher.id equals list.ucitel1_id
join pred in data.PREDMETY on list.predmet_id equals pred.id
join mist in data.MISTNOSTI on list.mistnost_id equals mist.id
let date = GetDate(list.den_cis, list.zacatek)
let week = (date.WeekNumber() % 2 == 0) ? "S" : "L"//get even/odd week
where String.Equals(teacher.id, id) &&
(date != DateTime.MinValue) && //eliminate invalid dates coming from the parsing function
date > minDate &&
(String.IsNullOrEmpty(list.sudy_lichy) || String.Equals(list.sudy_lichy, week))
select new
{
co = pred.nazev,
kde = mist.cislo,
kdy = date
}).Distinct().ToList();
return(Json(new { success = (events != null) && events.Count > 0, results = events }, JsonRequestBehavior.AllowGet));
}
public ActionResult Authenticate(string login, string password)
{
if (String.IsNullOrEmpty(login) || String.IsNullOrEmpty(password))
{
Response.StatusCode = 403;
return(JsonError);
}
var path = @"LDAP://ldap.feld.cvut.cz:636/ou=people,o=feld.cvut.cz";
var userName = String.Format(@"uid={0},ou=people,o=feld.cvut.cz", login);
DirectoryEntry de = new DirectoryEntry(path, userName, password, AuthenticationTypes.SecureSocketsLayer);
try
{
var obj = de.NativeObject;
}
catch (Exception ex)
{
//System.Console.Write("Bind Failure: {0}", ex.Message);
Response.StatusCode = 403;
return(Json(new { success = false }, JsonRequestBehavior.AllowGet));
}
//var expires = DateTime.Now.AddDays(14);
//var authTicket = new FormsAuthenticationTicket(1, userName, DateTime.Now, expires, true, string.Empty);
//var authCookie = FormsAuthentication.GetAuthCookie(userName, true);
//authCookie.Value = FormsAuthentication.Encrypt(authTicket);
//Response.Cookies.Add(authCookie);
var token = Guid.NewGuid().ToString("N");
HttpContext.Application[token] = DateTime.Now.AddDays(14);
Response.AddHeader("FellowMeToken", token);
//auhorized, find the user id
var schedule = MvcApplication.GetSchedule();
var person = (from student in schedule.STUDENTI
where String.Compare(student.login, login, true) == 0
select student.id)
.Union(
from ucitel in schedule.UCITELE
where String.Compare(ucitel.login, login, true) == 0
select ucitel.id).SingleOrDefault();
return(Json(new { success = true, token = token, person = person }, JsonRequestBehavior.AllowGet));
}
public ActionResult Person(string id)
{
var schedule = MvcApplication.GetSchedule();
var student = schedule.STUDENTI.Select(stud => new
{
id = stud.id,
typ = "student",
name = String.Format("{0}{1} {2}", String.IsNullOrWhiteSpace(stud.titul) ? String.Empty : stud.titul + " ", stud.jmeno, stud.prijmeni),
email = stud.stud_email,
rocnik = stud.rocnik,
fakulta = stud.fakulta,
obor = stud.obor
}).SingleOrDefault(x => String.Equals(x.id, id));
if (student != null)
{
return(Json(new { success = true, results = student }, JsonRequestBehavior.AllowGet));
}
var ucitel = schedule.UCITELE.Select(uc => new
{
id = uc.id,
typ = "ucitel",
name = String.Format("{0}{1} {2}{3}",
String.IsNullOrWhiteSpace(uc.titul_pred) ? String.Empty : uc.titul_pred + " ",
uc.jmeno,
uc.prijmeni,
String.IsNullOrWhiteSpace(uc.titul_za) ? String.Empty : " " + uc.titul_za),
email = uc.uc_email,
katedra = (from kat in schedule.KATEDRY
where String.Equals(kat.id, uc.kat_id)
select kat.nazev_cz).SingleOrDefault(),
}).SingleOrDefault(x => String.Equals(x.id, id));
if (ucitel == null)
{
return(JsonError);
}
return(Json(new { success = true, results = ucitel }, JsonRequestBehavior.AllowGet));
}