public ActionResult Save(AllocateClassRoom allocateClassRoom)
{
if (allocateClassRoom.FromTime.Length == 7)
{
allocateClassRoom.FromTime = "0" + allocateClassRoom.FromTime;
}
if (allocateClassRoom.ToTime.Length == 7)
{
allocateClassRoom.ToTime = "0" + allocateClassRoom.ToTime;
}
if (ModelState.IsValid)
{
ViewBag.Departments = allocateClassRoomManager.GetDepartmentsForDropdown();
ViewBag.Rooms = allocateClassRoomManager.GetRoomForDropdown();
ViewBag.WeekDays = allocateClassRoomManager.GetWeekDaysForDropdown();
ViewBag.Message = allocateClassRoomManager.saveAllocateClass(allocateClassRoom);
return(View());
}
else
{
ViewBag.Departments = allocateClassRoomManager.GetDepartmentsForDropdown();
ViewBag.Rooms = allocateClassRoomManager.GetRoomForDropdown();
ViewBag.WeekDays = allocateClassRoomManager.GetWeekDaysForDropdown();
string message = "Validation Error";
ViewBag.Message = message;
return(View());
}
}
public string SaveAllocate(AllocateClassRoomViewModel aAllocateClassRoomViewModel)
{
string msg = CheckTime(aAllocateClassRoomViewModel);
if (msg == "Full")
{
return("Class room is Full in this Time Zone");
}
if (msg == "Ok")
{
AllocateClassRoom aAllocateClassRoom = new AllocateClassRoom();
aAllocateClassRoom.IsAcTive = true;
aAllocateClassRoom.RoomId = aAllocateClassRoomViewModel.RoomId;
aAllocateClassRoom.CourseId = aAllocateClassRoomViewModel.CourseId;
aAllocateClassRoom.DayId = aAllocateClassRoomViewModel.DayId;
aAllocateClassRoom.DepartmentId = aAllocateClassRoomViewModel.DepartmentId;
string tempDate = aAllocateClassRoomViewModel.From.ToString("yyyy-MM-dd HH:mm:ss");
aAllocateClassRoom.From = tempDate;
tempDate = aAllocateClassRoomViewModel.To.ToString("yyyy-MM-dd HH:mm:ss");
aAllocateClassRoom.To = tempDate;
bool flag = aUnitOfWork.Repository <AllocateClassRoom>().InsertModel(aAllocateClassRoom);
aUnitOfWork.Save();
return("Class Room allocated Succesfully");
}
return("Class Room allocation failed, try some valid time");
}
public string SaveAlocateClassRoom(AllocateClassRoom allocateClassRoom)
{
if (allocateClassRoom.DateTimeFrom.TimeOfDay < allocateClassRoom.DateTimeTo.TimeOfDay)
{
allocateClassRoom.DateTimeTo = allocateClassRoom.DateTimeTo.AddMinutes(-1);
int rowCount = allocateClassRoomGateway.IsRoomFree(allocateClassRoom.RoomId, allocateClassRoom.DateTimeFrom,
allocateClassRoom.DateTimeTo, allocateClassRoom.DayId);
if (rowCount == 0)
{
int rowAffected = allocateClassRoomGateway.SaveAlocateClassRoom(allocateClassRoom);
if (rowAffected > 0)
{
return(" Class Room Allocated sucessfully");
}
else
{
return("Class Room not allocated");
}
}
else
{
return("Class room is not free");
}
}
else
{
return("Pls select Class Duration carefully");
}
}
public string Save(AllocateClassRoom allocate)
{
//if (allocate.FromRadioButton == "PM")
//{
// allocate.FromTime = (Convert.ToInt32(allocate.FromTime) + 12).ToString();
//}
//if (allocate.ToRadioButton == "PM")
//{
// allocate.EndTime = (Convert.ToInt32(allocate.EndTime) + 12).ToString();
//}
if (allocateGateway.CheckRoomAvailablity(allocate))
{
return("Room Already Allocated");
}
else
{
int rowAffected = allocateGateway.Save(allocate);
if (rowAffected > 0)
{
return("Room Allocate Successfull");
}
else
{
return("save failed");
}
}
}
public string Save(AllocateClassRoom allocateClassRoom)
{
var allocateClassRoomInfo = allocateClassRoomGateway.GetAllocateInfoByDayAndRoomId(allocateClassRoom.DayId,
allocateClassRoom.RoomId);
bool notAllowed = false;
if (allocateClassRoomInfo != null)
{
foreach (AllocateClassRoom info in allocateClassRoomInfo)
{
DateTime dbFromTime = DateTime.Parse(info.FromTime);
DateTime dbToTime = DateTime.Parse(info.ToTime);
DateTime fromTime = DateTime.Parse(allocateClassRoom.FromTime);
DateTime toTime = DateTime.Parse(allocateClassRoom.ToTime);
if ((fromTime >= dbFromTime && toTime <= dbToTime) || (fromTime < dbFromTime && toTime >= dbToTime) ||
(fromTime < dbFromTime && (toTime > dbFromTime && toTime <= dbToTime)) || (fromTime >= dbFromTime && fromTime < dbToTime) && toTime >= dbToTime)
{
notAllowed = true;
}
}
}
if (notAllowed)
{
return("Classroom already scheduled in selected time! Choose another time period");
}
else
{
int rowAffected = allocateClassRoomGateway.Save(allocateClassRoom);
if (rowAffected > 0)
{
return("Class Room Allocated!");
}
return("Failed to allocated class room");
}
}
public List <AllocateClassRoom> CheckTimeOverlapping(string day, int roomId)
{
string query = "SELECT AllocTimeFrom, AllocTimeTo FROM AllocateRoom where RoomAllocDay=@day and RoomID=@roomId";
SqlCommand command = new SqlCommand(query, connection);
command.Parameters.Clear();
command.Parameters.Add("day", SqlDbType.VarChar);
command.Parameters["day"].Value = day;
command.Parameters.Add("roomId", SqlDbType.Int);
command.Parameters["roomId"].Value = roomId;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
List <AllocateClassRoom> timeList = new List <AllocateClassRoom>();
while (reader.Read())
{
AllocateClassRoom roomObj = new AllocateClassRoom();
roomObj.STime = (TimeSpan)(reader["AllocTimeFrom"]);
roomObj.ETime = (TimeSpan)(reader["AllocTimeTo"]);
timeList.Add(roomObj);
}
reader.Close();
connection.Close();
return(timeList);
}
// get all from and to time by room no and day from allocate classrooms table
public List <AllocateClassRoom> GetAllTimeForSameRoomAndDay(AllocateClassRoom allocateClassRoom)
{
Connection.Open();
string query = "SELECT * FROM AllocateClassRoom WHERE RoomId = @roomId AND DayId = @dayId AND TYPE = 'ALLOCATED'";
Command = new SqlCommand(query, Connection);
Command.Parameters.AddWithValue("@roomId", allocateClassRoom.RoomId);
Command.Parameters.AddWithValue("@dayId", allocateClassRoom.DayId);
Reader = Command.ExecuteReader();
List <AllocateClassRoom> allocateClassRooms = new List <AllocateClassRoom>();
while (Reader.Read())
{
AllocateClassRoom allocateClass = new AllocateClassRoom();
allocateClass.StartTime = Reader["StartTime"].ToString();
allocateClass.EndTime = Reader["EndTime"].ToString();
allocateClassRooms.Add(allocateClass);
}
Reader.Close();
Connection.Close();
return(allocateClassRooms);
}
private void LoadDDLForCreateView(AllocateClassRoom allocateClassRoom)
{
ViewBag.CourseId = new SelectList(db.Courses, "CourseId", "Name", allocateClassRoom.CourseId);
ViewBag.DayId = new SelectList(db.Days, "DayId", "TimeDay", allocateClassRoom.DayId);
ViewBag.DepartmentId = new SelectList(db.Departments, "DepartmentId", "Name", allocateClassRoom.DepartmentId);
ViewBag.RoomId = new SelectList(db.Rooms, "RoomId", "RoomNo", allocateClassRoom.RoomId);
}
public ActionResult AllocateClassrooms(AllocateClassRoom allocateClassRoom)
{
if (ModelState.IsValid)
{
if (CheckTimeIsValidOrNot(allocateClassRoom))
{
ViewBag.Response = allocateClassManager.AllocateClassrooms(allocateClassRoom);
}
else
{
ViewBag.Response = "Invalid";
}
}
else
{
ViewBag.Response = "Empty";
}
ViewBag.Departments = departmentManager.GetAllDepartmentsForDropDown();
ViewBag.Rooms = roomManager.GetAllRoomsForDropDown();
ViewBag.Days = dayManager.GetAllDaysForDropDown();
ModelState.Clear();
return(View());
}
public string saveAllocateClass(AllocateClassRoom aAllocateClassRoom)
{
bool checkValid = CheckValidationAmPm(aAllocateClassRoom.FromTime, aAllocateClassRoom.ToTime);
if (checkValid == false)
{
return("Input time range is not valid");
}
bool isExited = allocateClassRoomGateway.saveAllocateClass(aAllocateClassRoom);
if (isExited == false)
{
return("Overlapping Time Shedule.Please input Valid time");
}
else
{
int row = allocateClassRoomGateway.SaveRoomForShedule(aAllocateClassRoom);
if (row > 0)
{
return("Save successfully");
}
else
{
return("Insert Failed");
}
}
}
public List <AllocateClassRoom> GetAllocateInfoByDayAndRoomId(int dayId, int roomId)
{
string query = "SELECT * FROM AllocateClassroom WHERE RoomId='" + roomId + "' AND DayId = '" + dayId + "' ";
Command = new SqlCommand(query, Connection);
Connection.Open();
List <AllocateClassRoom> allocateClassRooms = new List <AllocateClassRoom>();
Reader = Command.ExecuteReader();
bool isExistRow = Reader.HasRows;
if (isExistRow)
{
while (Reader.Read())
{
AllocateClassRoom allocateClassRoom = new AllocateClassRoom();
allocateClassRoom.FromTime = Reader["FromTime"].ToString();
allocateClassRoom.ToTime = Reader["ToTime"].ToString();
allocateClassRooms.Add(allocateClassRoom);
}
}
else
{
allocateClassRooms = null;
}
Reader.Close();
Connection.Close();
return(allocateClassRooms);
}
public ActionResult AllocateClassRoom(AllocateClassRoom allocateClassRoom)
{
if (ModelState.IsValid)
{
string message;
DateTime fromTime = DateTime.Parse(allocateClassRoom.FromTime);
DateTime toTime = DateTime.Parse(allocateClassRoom.ToTime);
if (fromTime > toTime)
{
message = "Invalid time range!";
ViewBag.Message = message;
}
else
{
message = allocateClassRoomManager.Save(allocateClassRoom);
ViewBag.Message = message;
}
ModelState.Clear();
}
else
{
ViewBag.Message = "Model state is invalid!";
}
ViewBag.Rooms = allocateClassRoomManager.GetAllRooms();
ViewBag.Days = allocateClassRoomManager.GetAllDays();
ViewBag.Departments = departmentManager.GetAllDepartments();
return(View());
}
public bool CheckTimeIsValidOrNot(AllocateClassRoom allocateClassRoom)
{
//int fromHour = allocateClassRoom.FromHour;
//int toHour = allocateClassRoom.ToHour;
//int fromMin = allocateClassRoom.FromMin;
//int toMin = allocateClassRoom.ToMin;
//string fromFormat = allocateClassRoom.FromFormat;
//string toFormat = allocateClassRoom.ToFormat;
TimeSpan time1 = DateTime.Parse(allocateClassRoom.StartTime).TimeOfDay;
TimeSpan time2 = DateTime.Parse(allocateClassRoom.EndTime).TimeOfDay;
TimeSpan diff = DateTime.Parse("1:00:00").TimeOfDay;
if (time1 < time2)
{
if (time2 - time1 < diff)
{
return(false);
}
else
{
return(true);
}
}
else
{
return(false);
}
}
public string SaveAllocateClassRoom(AllocateClassRoom allocateClassRoom)
{
if (classRoomGateway.SaveAllocateClassRoom(allocateClassRoom) > 0)
{
return("Save Successfull.");
}
return("Sory! Save fail.");
}
public ActionResult Allocate(AllocateClassRoom allocateClassRoom)
{
ViewBag.message = classRoomManager.SaveAllocateClassRoom(allocateClassRoom);
ViewBag.departmentList = classRoomManager.GetAllDepartmetns();
ViewBag.roomNo = GetAllRoomNo();
ViewBag.day = GetAllDay();
return(View());
}
public string Save(AllocateClassRoom allocateClassRoom)
{
if (allocateClassRoomGateway.Save(allocateClassRoom) > 0)
{
return("The class room allocated successfully.");
}
return("Failed to allocate the class room.");
}
public ActionResult DeleteConfirmed(int id)
{
AllocateClassRoom allocateclassroom = db.AllocateClassRooms.Find(id);
db.AllocateClassRooms.Remove(allocateclassroom);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Save(AllocateClassRoom allocateClassRoom)
{
ViewBag.Message = allocateClassRoomManager.Save(allocateClassRoom);
ViewBag.Departments = GetDepartments();
ViewBag.Courses = GetCourses();
ViewBag.Rooms = GetRooms();
ViewBag.Days = GetDays();
return(View());
}
public ActionResult Create(AllocateClassRoom model)
{
if (ModelState.IsValid)
{
db.AllocateClassRooms.Add(model);
db.SaveChanges();
}
return(RedirectToAction("Create"));
}
//
// GET: /AllocateClassRoom/Details/5
public ActionResult Details(int id = 0)
{
AllocateClassRoom allocateclassroom = db.AllocateClassRooms.Find(id);
if (allocateclassroom == null)
{
return(HttpNotFound());
}
return(View(allocateclassroom));
}
public int SaveAllocateClassRoom(AllocateClassRoom allocate)
{
Query = "INSERT INTO AllocateClassRoom(DepartmentId,CourseId,RoomNo,DayN,StrartFrom,EndTo) VALUES (" + allocate.DepartmentId + "," + allocate.CourseId + ",'" + allocate.RoomNo + "','" + allocate.Day + "','" + allocate.From + "','" + allocate.To + "')";
Command.CommandText = Query;
Connection.Open();
int rowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffected);
}
public ActionResult UnallocateClassroom(AllocateClassRoom allocateClassRoom)
{
var allocates = classRoomSechudelDAL.AllocateClassRoomGetAll();
foreach (var item in allocates)
{
item.IsUnallocate = true;
}
classRoomSechudelDAL.Complete();
ViewBag.SMessage = "Unallocate Classroom Successfully!";
return(View());
}
public ActionResult Allocate(AllocateClassRoom allocate)
{
DepartmentBind();
ViewBag.Courses = allocateManager.GetAllCourse();
ViewBag.Days = allocateManager.GetAllDay();
ViewBag.RoomNo = allocateManager.GetAllRoom();
//ViewBag.Departments = aDepartmentManager.GetAllDepartments();
ViewBag.Message = allocateManager.Save(allocate);
return(View());
}
public string SaveAllocation(AllocateClassRoom allocateClassRoomObj)
{
string startTime = allocateClassRoomObj.StartTime;
bool check = TimeOverlapping(startTime, allocateClassRoomObj.Day, allocateClassRoomObj.RoomId);
if (!check)
{
string message = gateway.SaveAllocation(allocateClassRoomObj);
return(message);
}
return("Not Possible");
}
public int SaveAlocateClassRoom(AllocateClassRoom allocateClassRoom)
{
Query = "INSERT INTO AllocateClassRoom(DepartmentId,CourseId,RoomId,DayId,DateFrom,DateTo,StatusId) Values('" +
allocateClassRoom.DepartmentId + "','" + allocateClassRoom.CourseId + "','" +
allocateClassRoom.RoomId + "','" + allocateClassRoom.DayId + "','" +
allocateClassRoom.DateTimeFrom + "','" + allocateClassRoom.DateTimeTo + "','1')";
Connection.Open();
Command = new SqlCommand(Query, Connection);
int rowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffected);
}
public ActionResult Edit([Bind(Include = "AllocateClassRoomId,CourseID,RoomsId,DaysId")] AllocateClassRoom allocateclassroom)
{
if (ModelState.IsValid)
{
db.Entry(allocateclassroom).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CourseID = new SelectList(db.CourseDbSet, "CourseID", "CourseCode", allocateclassroom.CourseID);
ViewBag.DaysId = new SelectList(db.DayDbSet, "DaysId", "DaysName", allocateclassroom.DaysId);
ViewBag.RoomsId = new SelectList(db.RoomseDbSet, "RoomsId", "RoomsName", allocateclassroom.RoomsId);
return(View(allocateclassroom));
}
public int Save(AllocateClassRoom allocateClassRoom)
{
allocateClassRoom.Action = "Allocated";
string query =
"INSERT INTO AllocateClassroom(DepartmentId, CourseId, RoomId, DayId, FromTime, ToTime, Action) " +
"VALUES('" + allocateClassRoom.DepartmentId + "','" + allocateClassRoom.CourseId + "','" + allocateClassRoom.RoomId + "','" + allocateClassRoom.DayId + "','" + allocateClassRoom.FromTime + "','" + allocateClassRoom.ToTime + "','" + allocateClassRoom.Action + "')";
Command = new SqlCommand(query, Connection);
Connection.Open();
int rowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffected);
}
//
// GET: /AllocateClassRoom/Edit/5
public ActionResult Edit(int id = 0)
{
AllocateClassRoom allocateclassroom = db.AllocateClassRooms.Find(id);
if (allocateclassroom == null)
{
return(HttpNotFound());
}
ViewBag.DepartmentId = new SelectList(db.Departments, "DepartmentId", "Name", allocateclassroom.DepartmentId);
ViewBag.CourseId = new SelectList(db.Courses, "CourseId", "Code", allocateclassroom.CourseId);
ViewBag.ClassRoomId = new SelectList(db.ClassRooms, "ClassRoomId", "RoomNo", allocateclassroom.ClassRoomId);
ViewBag.WeekDayId = new SelectList(db.WeekDays, "WeekDayId", "Day", allocateclassroom.WeekDayId);
return(View(allocateclassroom));
}
public ActionResult Edit([Bind(Include = "AllocateClassRoomId,DepartmentId,CourseId,RoomId,DayId,StartTime,EndTime")] AllocateClassRoom allocateclassroom)
{
if (ModelState.IsValid)
{
db.Entry(allocateclassroom).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CourseId = new SelectList(db.Courses, "CourseId", "Code", allocateclassroom.CourseId);
ViewBag.DayId = new SelectList(db.Days, "DayId", "TimeDay", allocateclassroom.DayId);
ViewBag.DepartmentId = new SelectList(db.Departments, "DepartmentId", "Code", allocateclassroom.DepartmentId);
ViewBag.RoomId = new SelectList(db.Rooms, "RoomId", "RoomNo", allocateclassroom.RoomId);
return(View(allocateclassroom));
}
// GET: /AllocateClassRoom/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AllocateClassRoom allocateclassroom = db.AllocateClassRooms.Find(id);
if (allocateclassroom == null)
{
return(HttpNotFound());
}
return(View(allocateclassroom));
}
