public ActionResult Edit(RoomAssign roomAssign)
{
if (AdminSessionControl())
{
if (ModelState.IsValid)
{
var check = _roomAssign.CountRoomAssign(roomAssign);
if (check)
{
ViewBag.DepartmentId = new SelectList(db.Departments, "Id", "DepartmentCode", roomAssign.DepartmentId);
ViewBag.Room = new SelectList(db.Rooms, "Id", "RoomNo", roomAssign.RoomId);
ViewBag.Day = new SelectList(db.Day, "Id", "DayName", roomAssign.Day);
ViewBag.Message = "This Room is Assign for this time ";
return(View(roomAssign));
}
else
{
db.Entry(roomAssign).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
else
{
ViewBag.DepartmentId = new SelectList(db.Departments, "Id", "DepartmentCode", roomAssign.DepartmentId);
ViewBag.Room = new SelectList(db.Rooms, "Id", "RoomNo", roomAssign.RoomId);
ViewBag.Day = new SelectList(db.Day, "Id", "DayName", roomAssign.Day);
return(View(roomAssign));
}
}
else
{
return(AdminLoginFaild());
}
}
public bool CountRoomAssign(RoomAssign roomAssign)
{
int TeacherId = db.CourseAssigns.Where(
x =>
x.DepartmentId == roomAssign.DepartmentId && x.BatchId == roomAssign.BatchId &&
x.CourseId == roomAssign.CourseId && x.Flag != 0).Select(x => x.TeacherId).FirstOrDefault();
roomAssign.TeacherId = TeacherId;
string StartTime = "2017-01-01 " + roomAssign.StartTime.ToString("H:mm");
string EndTime = "2017-01-01 " + roomAssign.EndTime.ToString("H:mm");
roomAssign.StartTime = Convert.ToDateTime(StartTime);
roomAssign.EndTime = Convert.ToDateTime(EndTime);
bool CheckExist = false;
var count = db.RoomAssigns.Count(x => (roomAssign.Day == x.Day && roomAssign.RoomId == x.RoomId)
&&
((roomAssign.StartTime > x.StartTime && roomAssign.EndTime < x.EndTime)
||
(roomAssign.StartTime <x.StartTime && roomAssign.EndTime> x.EndTime)
||
(roomAssign.StartTime <x.StartTime && roomAssign.EndTime> x.StartTime)
||
(roomAssign.StartTime > x.StartTime && roomAssign.EndTime > x.EndTime)
));
if (count > 0)
{
CheckExist = true;
}
return(CheckExist);
}
public int Save(RoomAssign roomAssign)
{
Query = "INSERT INTO RoomAssign(DepartmentId,CourseId, RoomId,DayId,StartTime,StartAMPM,EndTime,EndAMPM,IsAssign) VALUES(@DepartmentId,@CourseId, @RoomId,@DayId,@StartTime,@StartAMPM,@EndTime,@EndAMPM,1)";
Command.CommandText = Query;
Command.Connection = Connection;
Command.Parameters.Clear();
Command.Parameters.Add("DepartmentId", SqlDbType.Int);
Command.Parameters["DepartmentId"].Value = roomAssign.DepartmentId;
Command.Parameters.Add("CourseId", SqlDbType.Int);
Command.Parameters["CourseId"].Value = roomAssign.CourseId;
Command.Parameters.Add("RoomId", SqlDbType.Int);
Command.Parameters["RoomId"].Value = roomAssign.RoomId;
Command.Parameters.Add("DayId", SqlDbType.Int);
Command.Parameters["DayId"].Value = roomAssign.DayId;
Command.Parameters.Add("StartTime", SqlDbType.VarChar);
Command.Parameters["StartTime"].Value = roomAssign.StartTime;
Command.Parameters.Add("StartAMPM", SqlDbType.VarChar);
Command.Parameters["StartAMPM"].Value = roomAssign.FromAmPm;
Command.Parameters.Add("EndTime", SqlDbType.VarChar);
Command.Parameters["EndTime"].Value = roomAssign.EndTime;
Command.Parameters.Add("EndAMPM", SqlDbType.VarChar);
Command.Parameters["EndAMPM"].Value = roomAssign.ToAmPm;
Connection.Open();
int rowsAffected = Command.ExecuteNonQuery();
Connection.Close();
return(rowsAffected);
}
public bool Save(RoomAssign roomAssign)
{
if (IsRoomAssigned(roomAssign.RoomId, roomAssign.DayId, roomAssign.StartTime, roomAssign.EndTime, roomAssign.FromAmPm, roomAssign.ToAmPm))
{
throw new Exception("Room is busy this time. try another slot!");
}
return(roomAssignGateway.Save(roomAssign) > 0);
}
public ActionResult Save(RoomAssign roomAssign)
{
try
{
ViewBag.Message = roomAssignManager.Save(roomAssign) ? "Room Assigned Successfully" : "Room Assigned Faild";
}
catch (Exception exception)
{
ViewBag.Message = exception.Message;
}
ViewBag.Departments = departmentManager.ShowAllDepartments();
return(View());
}
public ActionResult DeleteConfirmed(int id)
{
if (AdminSessionControl())
{
RoomAssign roomAssign = db.RoomAssigns.Find(id);
db.RoomAssigns.Remove(roomAssign);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
return(AdminLoginFaild());
}
}
// GET: RoomAssigns/Details/5
public ActionResult Details(int?id)
{
if (AdminSessionControl())
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
RoomAssign roomAssign = db.RoomAssigns.Find(id);
if (roomAssign == null)
{
return(HttpNotFound());
}
return(View(roomAssign));
}
else
{
return(AdminLoginFaild());
}
}
// GET: RoomAssigns/Edit/5
public ActionResult Edit(int?id)
{
if (AdminSessionControl())
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
RoomAssign roomAssign = db.RoomAssigns.Find(id);
if (roomAssign == null)
{
return(HttpNotFound());
}
ViewBag.DepartmentId = new SelectList(db.Departments, "Id", "DepartmentCode", roomAssign.DepartmentId);
ViewBag.Room = new SelectList(db.Rooms, "Id", "RoomNo", roomAssign.RoomId);
ViewBag.Day = new SelectList(db.Day, "Id", "DayName", roomAssign.Day);
return(View(roomAssign));
}
else
{
return(AdminLoginFaild());
}
}
