public ActionResult UnallocateClassRoom(AllocateClassRoom allocateClassRoom) { var unallocateClassRoom = unallocateClassRoomManager.UnallocateClassRoom(allocateClassRoom); ViewBag.Message = unallocateClassRoom; return View(); }
public int SaveAllocatedRoom(AllocateClassRoom allocateClassRoom) { connection.ConnectionString = connectionString; string query = "INSERT INTO AllocateClass(DepartmentId,CourseId,RoomId,Day,TimeStart,TimeEnd) VALUES(@DepartmentId,@CourseId,@RoomId,@Day,@TimeStart,@TimeEnd)"; SqlCommand command = new SqlCommand(query, connection); command.Parameters.Clear(); command.Parameters.Add("DepartmentId", SqlDbType.Int); command.Parameters["DepartmentId"].Value = allocateClassRoom.DepartmentId; command.Parameters.Add("CourseId", SqlDbType.Int); command.Parameters["CourseId"].Value = allocateClassRoom.CourseId; command.Parameters.Add("RoomId", SqlDbType.Int); command.Parameters["RoomId"].Value = allocateClassRoom.RoomId; command.Parameters.Add("Day", SqlDbType.VarChar); command.Parameters["Day"].Value = allocateClassRoom.Day; command.Parameters.Add("TimeStart", SqlDbType.DateTime); command.Parameters["TimeStart"].Value = allocateClassRoom.TimeStart; command.Parameters.Add("TimeEnd", SqlDbType.DateTime); command.Parameters["TimeEnd"].Value = allocateClassRoom.TimeEnd; connection.Open(); int rowAffected = command.ExecuteNonQuery(); connection.Close(); return rowAffected; }
public string UnallocateClassRoom(AllocateClassRoom allocateClassRoom) { if (unallocateClassRoomGateway.UnallocateClassRoom(allocateClassRoom) > 0) { return " Unallocation successfully"; } else { return "Unallocation fail!!!"; } }
public bool CheckTimeCollission(AllocateClassRoom allocateClassRoom) { connection.ConnectionString = connectionString; string query = "SELECT TimeStart,TimeEnd FROM AllocateClass WHERE Day=@Day AND RoomId=@RoomId"; SqlCommand command = new SqlCommand(); command.CommandText = query; command.Connection = connection; command.Parameters.Add("Day", SqlDbType.VarChar); command.Parameters["Day"].Value = allocateClassRoom.Day; command.Parameters.Add("RoomId", SqlDbType.Int); command.Parameters["RoomId"].Value = allocateClassRoom.RoomId; connection.Open(); SqlDataReader reader = command.ExecuteReader(); bool IstimeValid1 = false; // check if the query return value if (reader.HasRows) { while (reader.Read()) { DateTime start = (DateTime)reader["TimeStart"]; DateTime end = (DateTime)reader["TimeEnd"]; TimeSpan ts = new TimeSpan(0, 0, 5); //offsetting 5 seconds DateTime start2 = DateTime.Now; DateTime end2 = DateTime.Now; start2 = start + ts; end2 = end - ts; IstimeValid1 = TimeChecker(allocateClassRoom.TimeStart, allocateClassRoom.TimeEnd, start2, end2); //IstimeValid2 = TimeChecker(, start, end); } reader.Close(); connection.Close(); if (IstimeValid1) { return true; } else { return false; } } else { reader.Close(); connection.Close(); return true; } }
public string SaveClassAllocation(AllocateClassRoom allocateClassRoom) { if (allocateClassRoomGateway.CheckTimeCollission(allocateClassRoom)) { if (allocateClassRoomGateway.SaveAllocatedRoom(allocateClassRoom) > 0) { return "Class Room Allocated"; } else { return " Class room is not allocated"; } } else{ return "Time Collision"; } }
public int UnallocateClassRoom(AllocateClassRoom allocateClassRoom) { connection.ConnectionString = connectionString; string query = "Update AllocateClass Set RoomId=Null, Day=Null, TimeStart=Null, TimeEnd=Null"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); int rowAffected = command.ExecuteNonQuery(); connection.Close(); return rowAffected; }
public ActionResult AllocateClassRoom(AllocateClassRoom allocateClassRoom) { ViewBag.Departments = GetDepartmentForSelectList(); ViewBag.Rooms = GetRoomsForSelectList(); ViewBag.Days = GetDaysForSelectList(); //data manipulation DateTime start = new DateTime(2016, 1, 1, allocateClassRoom.TimeStart.Hour, allocateClassRoom.TimeStart.Minute, allocateClassRoom.TimeStart.Second); DateTime end = new DateTime(2016, 1, 1, allocateClassRoom.TimeEnd.Hour, allocateClassRoom.TimeEnd.Minute, allocateClassRoom.TimeEnd.Second); allocateClassRoom.TimeStart = start; allocateClassRoom.TimeEnd = end; ViewBag.TimeClash=allocateClassRoomManager.SaveClassAllocation(allocateClassRoom); return View(); }