public ActionResult AllocatedClassroom(AllocatedClassroom aClassroom) { ViewBag.Message = aAllocatedClassroomManager.Save(aClassroom); ViewBag.Days = GetDaysForDropDownList(); ViewBag.Rooms = GetRoomsForDropDownList(); ViewBag.Departments = aDepartmentManager.GetDepartmentsForDropDownList(); return(View()); }
public string AllocateClassroom(AllocatedClassroom allocatedClassroom) { if (admin.AllocateClassroom(allocatedClassroom) >= 0) { return("Success"); } return("Failed"); }
public async Task <ActionResult> DeleteConfirmed(int id) { AllocatedClassroom allocatedClassroom = await db.AllocatedClassroms.FindAsync(id); db.AllocatedClassroms.Remove(allocatedClassroom); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
// GET: AllocatedClassrooms/Delete/5 public async Task <ActionResult> Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AllocatedClassroom allocatedClassroom = await db.AllocatedClassroms.FindAsync(id); if (allocatedClassroom == null) { return(HttpNotFound()); } return(View(allocatedClassroom)); }
public string Save(AllocatedClassroom aClassroom) { aClassroom.Status = true; if (allocatedClassroomGateway.CheckRoomAndDay(aClassroom) && allocatedClassroomGateway.CheckTimeSchedule(aClassroom)) { return("This room is already allocated"); } else { int rowAffected = allocatedClassroomGateway.Save(aClassroom); if (rowAffected > 0) { return("Room allocated successfully"); } return("Allocating failed"); } }
public int AllocateClassroom(AllocatedClassroom allocatedClassroom) { string query = "INSERT INTO AllocateClassroom (CourseId, RoomId, DayId,FromTime,ToTime)" + "VALUES(@courseId, @roomId, @dayId, @fromTime, @toTime)"; Gateway gateway = new Gateway(query); gateway.SqlCommand.Parameters.Clear(); gateway.SqlCommand.Parameters.AddWithValue("@courseId", allocatedClassroom.CourseId); gateway.SqlCommand.Parameters.AddWithValue("@roomId", allocatedClassroom.RoomId); gateway.SqlCommand.Parameters.AddWithValue("@dayId", allocatedClassroom.DayId); gateway.SqlCommand.Parameters.AddWithValue("@fromTime", allocatedClassroom.FromTime); gateway.SqlCommand.Parameters.AddWithValue("@toTime", allocatedClassroom.ToTime); int rowAffected = gateway.SqlCommand.ExecuteNonQuery(); gateway.Connection.Close(); return(rowAffected); }
public async Task <ActionResult> Create([Bind(Include = "AllocatedClassroomId,DepartmentId,CourseId,RoomId,DayId,FromTime,ToTime,AllocationStatus")] AllocatedClassroom allocatedClassroom) { if (ModelState.IsValid) { allocatedClassroom.IsAllocated = true; db.AllocatedClassroms.Add(allocatedClassroom); await db.SaveChangesAsync(); FlashMessage.Confirmation("Room Successfully Allocated"); return(RedirectToAction("Create")); } ViewBag.CourseId = new SelectList(db.Courses, "CourseId", "CourseCode", allocatedClassroom.CourseId); ViewBag.DayId = new SelectList(db.Days, "DayId", "DayName", allocatedClassroom.DayId); ViewBag.DepartmentId = new SelectList(db.Departments, "DepartmentId", "DepartmentCode", allocatedClassroom.DepartmentId); ViewBag.RoomId = new SelectList(db.Rooms, "RoomId", "RoomNo", allocatedClassroom.RoomId); return(View(allocatedClassroom)); }
public bool CheckRoomAndDay(AllocatedClassroom aClassroom) { string query = "SELECT * FROM AllocatedRooms WHERE Day = '" + aClassroom.Day + "' AND RoomId = '" + aClassroom.RoomId + "' "; Command = new SqlCommand(query, Connection); Connection.Open(); Reader = Command.ExecuteReader(); bool hasRow = false; if (Reader.HasRows) { hasRow = true; } Reader.Close(); Connection.Close(); return(hasRow); }
public List <AllocatedClassroom> GetAllRooms() { string query = "SELECT * FROM Room"; Command = new SqlCommand(query, Connection); Connection.Open(); Reader = Command.ExecuteReader(); List <AllocatedClassroom> allRooms = new List <AllocatedClassroom>(); while (Reader.Read()) { AllocatedClassroom aRoom = new AllocatedClassroom(); aRoom.RoomId = (int)Reader["Id"]; aRoom.RoomNo = Reader["RoomNo"].ToString(); allRooms.Add(aRoom); } Reader.Close(); Connection.Close(); return(allRooms); }
public bool CheckTimeSchedule(AllocatedClassroom aClassroom) { string query = "SELECT * FROM AllocatedRooms WHERE (StartTime >= '" + aClassroom.FromTime + "' AND FinishTime <= '" + aClassroom.ToTime + "') OR (StartTime <= '" + aClassroom.ToTime + "' AND " + " FinishTime >= '" + aClassroom.FromTime + "')"; Command = new SqlCommand(query, Connection); Connection.Open(); Reader = Command.ExecuteReader(); bool hasRow = false; if (Reader.HasRows) { hasRow = true; } Reader.Close(); Connection.Close(); return(hasRow); }
public int Save(AllocatedClassroom aClassroom) { string query = "INSERT INTO AllocatedRooms VALUES(@departmentId,@courseId,@roomId,@day,@startTime,@finishTime,@status)"; Command = new SqlCommand(query, Connection); Command.Parameters.Clear(); Command.Parameters.Add("departmentId", SqlDbType.Int); Command.Parameters["departmentId"].Value = aClassroom.DepartmentId; Command.Parameters.Add("courseId", SqlDbType.Int); Command.Parameters["courseId"].Value = aClassroom.CourseId; Command.Parameters.Add("roomId", SqlDbType.Int); Command.Parameters["roomId"].Value = aClassroom.RoomId; Command.Parameters.Add("day", SqlDbType.VarChar); Command.Parameters["day"].Value = aClassroom.Day; Command.Parameters.Add("startTime", SqlDbType.VarChar); Command.Parameters["startTime"].Value = aClassroom.FromTime; Command.Parameters.Add("finishTime", SqlDbType.VarChar); Command.Parameters["finishTime"].Value = aClassroom.ToTime; Command.Parameters.Add("status", SqlDbType.Bit); Command.Parameters["status"].Value = aClassroom.Status; Connection.Open(); int rowAffected = Command.ExecuteNonQuery(); Connection.Close(); return(rowAffected); }
public ActionResult AllocateClassroom(AllocatedClassroom allocatedClassroom) { var message = admin.AllocateClassroom(allocatedClassroom); return(Json(message, JsonRequestBehavior.AllowGet)); }