private void btnLecturers_Click(object sender, EventArgs e)
{
ActivateButton(sender);
Lec lc = new Lec();
lc.Show();
}
//Post Accounts
public void Post([FromBody] Lec lec)
{
using (MSSQL400028Entities1 entities = new MSSQL400028Entities1())
{
entities.Lec.Add(lec);
entities.SaveChanges();
}
}
//Update Accounts (Put)
public void Put(string id, [FromBody] Lec lec)
{
using (MSSQL400028Entities1 entities = new MSSQL400028Entities1())
{
var entity = entities.Lec.FirstOrDefault(e => e.Rid == id);
entity.Rid = lec.Rid;
entity.AdminID = lec.AdminID;
entity.Class = lec.Class;
entity.LecTime = lec.LecTime;
entity.DeviceID = lec.DeviceID;
entity.Extra = lec.Extra;
entities.SaveChanges();
}
}
public List <Lec> DaysTable(int id)
{
List <Lec> ll = new List <Lec>();
student s = (from x in db.students where x.Id == id select x).First();
var l = (from x in db.lectures where x.clas == s.clas && x.year == s.year && x.specialization_id == s.specialization_id select x).ToList();
foreach (var x in l)
{
Lec lc = new Lec();
lc.time = x.lecture_at_id;
lc.day = x.dayinweek;
lc.material = x.material.material_name;
lc.hall = x.hall.name;
ll.Add(lc);
}
return(ll);
}
