public string UnAllocate(AllocateClassroomViewModel allocateClassroomViewModel)
{
if (unAllocateClassroomGateway.UnAllocate(allocateClassroomViewModel) > 0)
{
return("UnAllocate All Classroom Successfull");
}
else
{
return("Sorry, Nothing to UnAllocate.");
}
}
public int UnAllocate(AllocateClassroomViewModel allocateClassroomViewModel)
{
SqlConnection con = new SqlConnection(connectionString);
string query = "Delete from UnAllocateClassrooms";
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
int rowAffect = cmd.ExecuteNonQuery();
con.Close();
return(rowAffect);
}
public List <AllocateClassroomViewModel> GatAllAllocateRoomViewGateway(int?DepartmentId)
{
SqlConnection con = new SqlConnection(connectionString);
string query = "select * from ViewClassScheduleNew where DepartmentID = '" + DepartmentId + "'";
SqlCommand cmd = new SqlCommand(query, con);
List <AllocateClassroomViewModel> allocateClassroomViewModels = new List <AllocateClassroomViewModel>();
con.Open();
SqlDataReader dataReader = cmd.ExecuteReader();
if (dataReader.HasRows)
{
while (dataReader.Read())
{
AllocateClassroomViewModel allocateClassroomViewModel = new AllocateClassroomViewModel();
//allocateClassroomViewModel.DepartmentId = Convert.ToInt32(dataReader["DepartmentId"]);
allocateClassroomViewModel.CourseCode = dataReader["CourseCode"].ToString();
allocateClassroomViewModel.CourseName = dataReader["CourseName"].ToString();
if (dataReader["DayName"].ToString() != string.Empty)
{
allocateClassroomViewModel.RoomNo = dataReader["RoomNo"].ToString();
allocateClassroomViewModel.DayName = dataReader["DayName"].ToString();
allocateClassroomViewModel.FromDate = dataReader["FromDate"].ToString();
allocateClassroomViewModel.FromAmOrPm = dataReader["FromAmOrPm"].ToString();
allocateClassroomViewModel.ToDate = dataReader["ToDate"].ToString();
allocateClassroomViewModel.ToAmOrPm = dataReader["ToAmOrPm"].ToString();
}
else
{
allocateClassroomViewModel.DayName = "No day.";
allocateClassroomViewModel.RoomNo = null;
}
allocateClassroomViewModels.Add(allocateClassroomViewModel);
}
dataReader.Close();
}
con.Close();
return(allocateClassroomViewModels);
}
public ActionResult UnallocateClassroom(AllocateClassroomViewModel allocateClassroomViewModel)
{
ViewBag.message = unAllocateClassroomManager.UnAllocate(allocateClassroomViewModel);
TempData["Msg"] = ViewBag.message;
return(RedirectToAction("UnallocateClassroom"));
}
