public ActionResult RoomAllocation(RoomAllocation roomAllocation)
{
ViewBag.Message = roomAllocationSaveManager.SaveRoomAllocation(roomAllocation);
List<Department> departmentsList = departmentManager.GetDepartmentsList();
List<Room> roomList = roomManager.GetRoomList();
ViewBag.departmentsList = departmentsList;
ViewBag.roomList = roomList;
return View();
}
public int SaveRoomAllocte(RoomAllocation roomAllocation)
{
connection.ConnectionString = connectionString;
string sqlQuery = "INSERT INTO roomAllocation_tbl VALUES('" + roomAllocation.DepartmentId + "','" + roomAllocation.CourseId + "','" + roomAllocation.RoomNo + "','" + roomAllocation.DayList + "','" + roomAllocation.FromTime + " " + roomAllocation.FromExtension + "','" + roomAllocation.ToTime + " " + roomAllocation.ToExtension + "',1)";
SqlCommand command = new SqlCommand(sqlQuery, connection);
connection.Open();
int isInserted = command.ExecuteNonQuery();
connection.Close();
return isInserted;
}
public string SaveRoomAllocation(RoomAllocation roomAllocation)
{
if (roomAllocationSaveGatway.SaveRoomAllocte(roomAllocation) > 0)
{
return "Allocation Successfull .";
}
else
{
return "Allocation Failed";
}
}