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));
}
