public string Save(ClassRoomAllocate classRoom)
{
var startTime = DateTime.Parse(classRoom.StartTime.ToString("HH:mm"));
var endTime = DateTime.Parse(classRoom.EndTime.ToString("HH:mm"));
if (endTime < startTime)
{
return("You Try To Allocated Next Day");
}
if (allocateClassRoomsGateway.IsExitsClassroom(classRoom.RoomId, startTime.ToString(), endTime.ToString(), classRoom.Day))
{
return("Already Allocated This Room at this time");
}
int rawAffected = allocateClassRoomsGateway.Save(classRoom);
if (rawAffected > 0)
{
return("Allocated Successfull");
;
}
else
{
return("Failed to allocated");
}
}
public ActionResult RoomAllocation(ClassRoomAllocate aClassRoomAllocate)
{
ViewBag.Departments = aDepartmentManager.GetAllDepartments();
ViewBag.Days = Weeks();
ViewBag.Rooms = aClassRoomManager.GetAllRooms();
ViewBag.Message = aClassRoomManager.Save(aClassRoomAllocate);
return(View());
}
public ActionResult ClassroomAllocation(ClassRoomAllocate classRoomAllocate)
{
string message = classRoomAllocationManager.Allocate(classRoomAllocate);
ViewBag.Message = message;
ViewBag.Departments = classRoomAllocationManager.GetAllDepartmentByDropdown();
ViewBag.Courses = classRoomAllocationManager.GetAllCourseByDropdown();
ViewBag.Rooms = classRoomAllocationManager.GetAllRoomByDropdown();
ViewBag.Day = classRoomAllocationManager.GetAllDayByDropdown();
return(View());
}
public int Save(ClassRoomAllocate classRoom)
{
string query = "INSERT INTO AllocateClassRooms (DepartmentId,CourseId,RoomNoId,Day,StartTime,EndTime) VALUES ('" + classRoom.DepartmentId + "','" + classRoom.CourseId + "','" + classRoom.RoomId + "','" + classRoom.Day + "','" + classRoom.StartTime + "','" + classRoom.EndTime + "')";
SqlConnection connection = new SqlConnection(connectionString);
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
int rawAffected = command.ExecuteNonQuery();
connection.Close();
return(rawAffected);
}
public ActionResult AllocateClassRoom(ClassRoomAllocate classRoom)
{
var departments = departmentManager.GetAllDepartments();
ViewBag.Departments = departments;
var rooms = allocateClass.GetRooms();
ViewBag.Rooms = rooms;
string msg = allocateClass.Save(classRoom);
ViewBag.Msg = msg;
return(View());
}
//**************** Shedule Uniqe *******************************
public bool IsSheduleTimeExists(ClassRoomAllocate classRoomAllocate)
{
string query = "SELECT * FROM ClassRoomAllocate WHERE RoomId='" + classRoomAllocate.RoomId + "'AND DayId='" + classRoomAllocate.DayId + "' AND FromTime ='" + classRoomAllocate.FromTime + "' AND ToTime='" + classRoomAllocate.ToTime + "' AND Status='Allocated' ";
//string query = "SELECT * FROM ClassRoomAllocate FromTime BETWEEN '" + classRoomAllocate.FromTime + "' AND ToTime='" + classRoomAllocate.ToTime + "'";
Command = new SqlCommand(query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
bool isExists = Reader.HasRows;
Connection.Close();
return(isExists);
}
public int TimeIsExist(ClassRoomAllocate aClassRoomAllocate)
{
Query = "SELECT COUNT(Id) FROM RoomAllocation_tb WHERE Day ='" + aClassRoomAllocate.Day + "' AND RoomId = '" + aClassRoomAllocate.RoomId + "' AND Status ='True' AND (('" + aClassRoomAllocate.FromTime + "' >= StartTime AND '" + aClassRoomAllocate.ToTime + "' <= EndTime) OR ('" + aClassRoomAllocate.ToTime + "' >= StartTime AND '" + aClassRoomAllocate.ToTime + "' <= EndTime))";
Command = new SqlCommand(Query, Connection);
Connection.Open();
object value = Command.ExecuteScalar();
int a = 0;
if (value != null)
{
a += (int)value;
}
Connection.Close();
return(a);
}
public string Save(ClassRoomAllocate aClassRoomAllocate)
{
if (TimeIsExist(aClassRoomAllocate) >= 1)
{
return("This Schedule is Already Booked ");
}
if (aClassRoomGateway.Save(aClassRoomAllocate) > 0)
{
return("Class Room Allocation Successfully Done");
}
else
{
return("Failed");
}
}
public int Save(ClassRoomAllocate aClassRoomAllocate)
{
Query = "INSERT INTO RoomAllocation_tb (DeptId, CourseId, RoomId, Day, StartTime, EndTime, Status) " +
"VALUES (@deptid, @courseid, @roomid, @day, @start, @end, 'True')";
Command = new SqlCommand(Query, Connection);
Command.Parameters.Clear();
Command.Parameters.AddWithValue("deptid", aClassRoomAllocate.DeptId);
Command.Parameters.AddWithValue("courseid", aClassRoomAllocate.CourseId);
Command.Parameters.AddWithValue("roomid", aClassRoomAllocate.RoomId);
Command.Parameters.AddWithValue("day", aClassRoomAllocate.Day);
Command.Parameters.AddWithValue("start", aClassRoomAllocate.FromTime);
Command.Parameters.AddWithValue("end", aClassRoomAllocate.ToTime);
Connection.Open();
int rowCount = Command.ExecuteNonQuery();
Connection.Close();
return(rowCount);
}
//*************************************Allocate Classroom *****************************
public string Allocate(ClassRoomAllocate classRoomAllocate)
{
if (classRoomAllocationGateway.IsSheduleTimeExists(classRoomAllocate))
{
return("Shedule Already Exist");
}
else
{
int rowEffect = classRoomAllocationGateway.Allocate(classRoomAllocate);
if (rowEffect > 0)
{
return("Save Successfull");
}
else
{
return("Save Failed");
}
}
}
//*************************************Allocate Classroom *****************************
public int Allocate(ClassRoomAllocate classRoomAllocate)
{
//string query = "INSERT INTO ClassRoomAllocate VALUES(@DeptId,@CourseId,@RoomId,@DayId,@FromTime,@ToTime,@Status)";
string query = "INSERT INTO ClassRoomAllocate VALUES(@DeptId,@CourseId,@RoomId,@DayId,@FromTime,@ToTime,@Status)";
Command = new SqlCommand(query, Connection);
Command.Parameters.AddWithValue("@DeptId", classRoomAllocate.DeptId);
Command.Parameters.AddWithValue("@CourseId", classRoomAllocate.CourseId);
Command.Parameters.AddWithValue("@RoomId", classRoomAllocate.RoomId);
Command.Parameters.AddWithValue("@DayId", classRoomAllocate.DayId);
Command.Parameters.AddWithValue("@FromTime", classRoomAllocate.FromTime);
Command.Parameters.AddWithValue("@ToTime", classRoomAllocate.ToTime);
Command.Parameters.AddWithValue("@Status", classRoomAllocate.Status = "Allocated");
Connection.Open();
int rowEffect = Command.ExecuteNonQuery();
Connection.Close();
return(rowEffect);
}
public int TimeIsExist(ClassRoomAllocate aClassRoomAllocate)
{
return(aClassRoomGateway.TimeIsExist(aClassRoomAllocate));
}
