public async Task <IHttpActionResult> CreateClass([FromBody] classroom form)
{
try
{
//find check duplicate
var classroom = db.classrooms.Where(a => a.class_code == form.class_code).FirstOrDefault();
if (classroom == null)
{
form.create_at = DateTime.Now;
db.Entry(form).State = System.Data.Entity.EntityState.Added;
int check = await db.SaveChangesAsync();
if (check > 0)
{
return(Ok(await ListClassroom()));
}
else
{
return(BadRequest("Create classroom fails."));
}
}
else
{
return(BadRequest("Class code duplicate."));
}
}
catch
{
return(BadRequest("Error."));
}
}
private JObject addClassroom(Command value)
{
var classroomObj = JsonConvert.DeserializeObject <Classroom>(value.data.ToString());
classroom classroom;
if (classroomObj.id != null)
{
classroom = _db.getClassRoom(classroomObj.id);
classroom.number = classroomObj.name;
classroom.idcroomtype = classroomObj.typeId;
_db.updateClassRoom(classroomObj.id, classroom);
classroomObj.id = classroom.idclassrooms;
}
else
{
classroom = new classroom();
classroom.number = classroomObj.name;
classroom.idcroomtype = classroomObj.typeId;
//TODO ewentualnie zwiększyć maksymalną długość w bazie
classroom.idclassrooms = Guid.NewGuid().ToString().Replace("-", "");
_db.insertClassRoom(ref classroom);
classroomObj.id = classroom.idclassrooms;
}
return(JObject.Parse(JsonConvert.SerializeObject(classroomObj)));
}
public ActionResult DeleteConfirmed(int id)
{
classroom classroom = _db.classrooms.Find(id);
_db.classrooms.Remove(classroom);
_db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Exclude = "Id")] classroom classroomToCreate)
{
if (!ModelState.IsValid)
{
return(View());
}
_db.classrooms.Add(classroomToCreate);
_db.SaveChanges();
return(RedirectToAction("Index"));
}
public async Task <IHttpActionResult> GetAllClass([FromBody] classroom form)
{
try
{
return(Ok(await ListClassroom()));
}
catch
{
return(BadRequest("Error."));
}
}
public ActionResult delclassroom(int id)
{
classroom del = new classroom()
{
classroomId = id
};
db.classroom.Attach(del);
db.classroom.Remove(del);
db.SaveChanges();
return(Json(new object()));
}
// GET: Allocation/view3/5
public ActionResult view3(int?id)
{
if (id == null)
{
id = 2;
}
classroom classroom = _db.classrooms.Find(id);
if (classroom == null)
{
return(HttpNotFound());
}
return(View(classroom));
}
// GET: Allocation/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
classroom classroom = _db.classrooms.Find(id);
if (classroom == null)
{
return(HttpNotFound());
}
return(View(classroom));
}
public ActionResult Edit(classroom classroomToEdit)
{
var originalclassroom = (from c in _db.classrooms
where c.class_id == classroomToEdit.class_id
select c).First();
if (!ModelState.IsValid)
{
return(View(originalclassroom));
}
_db.Entry(originalclassroom).CurrentValues.SetValues(classroomToEdit);
_db.SaveChanges();
return(RedirectToAction("Index"));
}
private List <List <TimeSlot> > GetLessonTimeSlotsForClassroom(classroom cr)
{
var lessonsInAWeek = cr.lessons.GroupBy(l => l.day.iddays).OrderBy(g => g.Key);
var timeSlots = CreateClearTimeSlotWeek();
var dayIndex = 0;
foreach (var dayOfLessons in lessonsInAWeek)
{
foreach (var lesson in dayOfLessons)
{
var duration = lesson.subject.time.GetValueOrDefault();
for (int slot = 0; slot < duration; ++slot)
{
timeSlots.ElementAt(dayIndex).ElementAt(lesson.start.Value + slot).Availability =
Availability.NonAvailable;
}
}
++dayIndex;
}
return(timeSlots);
}
public async Task <IHttpActionResult> UpdateClass(int id, [FromBody] classroom form)
{
try
{
var findClass = db.classrooms.Where(a => a.id == id).FirstOrDefault();
if (findClass != null)
{
//find check duplicate
var classroom = db.classrooms.Where(a => a.class_code == form.class_code && a.id != id).FirstOrDefault();
if (classroom == null)
{
findClass.class_code = form.class_code;
findClass.faculty_id = form.faculty_id;
db.Entry(findClass).State = System.Data.Entity.EntityState.Modified;
int check = await db.SaveChangesAsync();
if (check > 0)
{
return(Ok(await ListClassroom()));
}
else
{
return(BadRequest("Create classroom fails."));
}
}
else
{
return(BadRequest("Class code duplicate."));
}
}
else
{
return(BadRequest("Classroom not found."));
}
}
catch
{
return(BadRequest("Error."));
}
}
public async Task <IHttpActionResult> DeleteClass(int id, [FromBody] classroom form)
{
try
{
var findDetail = db.details.Where(a => a.classroom_id == id).ToList();
if (findDetail.Count() > 0)
{
findDetail.ForEach(a => a.classroom_id = null);
db.Entry(findDetail).State = System.Data.Entity.EntityState.Modified;
await db.SaveChangesAsync();
}
var findClass = db.classrooms.Where(a => a.id == id).FirstOrDefault();
if (findClass != null)
{
db.Entry(findClass).State = System.Data.Entity.EntityState.Deleted;
int check = await db.SaveChangesAsync();
if (check > 0)
{
return(Ok(await ListClassroom()));
}
else
{
return(BadRequest("Create classroom fails."));
}
}
else
{
return(BadRequest("Classroom not found."));
}
}
catch
{
return(BadRequest("Error."));
}
}
public ActionResult addclassroom(string name, int count, string type, int currid)
{
var t = from d in db.classroom where d.classroomId == currid select d;
if (t.Any())
{
t.FirstOrDefault().classroomName = name;
t.FirstOrDefault().capacity = count;
t.FirstOrDefault().type = type;
db.SaveChanges();
}
else
{
classroom clsroom = new classroom();
clsroom.classroomName = name;
clsroom.capacity = count;
clsroom.timeUsed = "";
clsroom.type = type;
db.classroom.Add(clsroom);
db.SaveChanges();
}
return(Json(new object()));
}
