public int Save(AllocateClassroom allocateClassroom)
{
string from = allocateClassroom.TimeFrom.ToShortTimeString();
string to = allocateClassroom.TimeTo.ToShortTimeString();
string query = "INSERT INTO AllocateClassrooms(CourseId,RoomId,DayId,TimeFrom,TimeTo,Status) VALUES(@CourseId,@RoomId,@DayId,'" + from + "','" + to + "',@Status)";
SqlCommand command = new SqlCommand(query, Connection);
command.Parameters.Clear();
command.Parameters.Add("@CourseId", SqlDbType.VarChar);
command.Parameters["@CourseId"].Value = allocateClassroom.CourseId;
command.Parameters.Add("@RoomId", SqlDbType.VarChar);
command.Parameters["@RoomId"].Value = allocateClassroom.RoomId;
command.Parameters.Add("@DayId", SqlDbType.VarChar);
command.Parameters["@DayId"].Value = allocateClassroom.DayId;
command.Parameters.Add("@Status", SqlDbType.VarChar);
command.Parameters["@Status"].Value = 1;
Connection.Open();
int rowsAffected = command.ExecuteNonQuery();
Connection.Close();
return(rowsAffected);
}
public void IsRoomAllocated(AllocateClassroom allocateClassroom)
{
var allcocationList = GetAllAllocationList(allocateClassroom);
string msg;
if (allcocationList.Count == 0)
{
Message = "";
}
else
{
bool status = false;
foreach (var a in allcocationList)
{
if ((allocateClassroom.FromTime >= a.FromTime && allocateClassroom.FromTime < a.ToTime) ||
(allocateClassroom.ToTime > a.FromTime && allocateClassroom.ToTime <= a.ToTime))
{
Message = "Time Clash for room alocation. Please Try another time.";
status = true;
}
}
if (status == false)
{
Message = "";
}
else
{
Message = "Time Clash for room alocation. Please Try another time.";
}
}
}
public ActionResult AllocateClassroom(AllocateClassroom allocateClassroom)
{
_allocateClassRoomManager.IsRoomAllocated(allocateClassroom);
if (_allocateClassRoomManager.Message == "")
{
bool result = _allocateClassRoomManager.Save(allocateClassroom);
if (result)
{
ViewBag.SuccessMessage = "Class Room Allocated Successfully";
}
else
{
ViewBag.ErrorMessage = "Class Room Allocation Failed";
}
}
else
{
ViewBag.ErrorMessage = _allocateClassRoomManager.Message;
}
ViewBag.Department = _departmentManager.GetAllDepartments();
ViewBag.Classroom = _classroomManager.GetAllRooms();
ViewBag.Day = _dayManager.GetAllDays();
return(View());
}
public ActionResult AllocateClassRoom(AllocateClassroom classroom)
{
FillDepartmentDropdown();
FillRoomDropdown();
if (ModelState.IsValid)
{
if (classroom.FromTime >= classroom.ToTime)
{
FlashMessage.Danger("From time should be less than to time");
ModelState.Clear();
return(View(classroom));
}
if (!_classRoomManager.IsClassRoomAvailable(classroom.Day, classroom.FromTime, classroom.ToTime, classroom.RoomId))
{
FlashMessage.Danger($"Class room is not available between {classroom.FromTime.ToShortTimeString()} to {classroom.ToTime.ToShortTimeString()} on {classroom.Day}");
ModelState.Clear();
return(View(classroom));
}
_classRoomManager.SaveAllocatedClassRoom(classroom);
FlashMessage.Confirmation("Class room successfully allocated");
return(RedirectToAction("AllocateClassRoom"));
}
FlashMessage.Danger("Some error occured, please check all the input");
return(View(classroom));
}
public bool IsRoomAlreadyAllocated(AllocateClassroom allocateClassroom)
{
TimeSpan ftime = allocateClassroom.FromTime.TimeOfDay;
TimeSpan ttime = allocateClassroom.ToTime.TimeOfDay;
List <AllocateClassroom> allocateClassrooms = aRoomGateway.IsRoomAlreadyAllocated(allocateClassroom.DayId, allocateClassroom.RoomId);
foreach (AllocateClassroom classroom in allocateClassrooms)
{
TimeSpan aFtime = classroom.FromTime.TimeOfDay;
TimeSpan aTtime = classroom.ToTime.TimeOfDay;
if (TimeSpan.Compare(ftime, aFtime) >= 0 && TimeSpan.Compare(ftime, aTtime) < 0)
{
return(true);
}
else if (TimeSpan.Compare(ttime, aFtime) > 0 && TimeSpan.Compare(ttime, aTtime) < 0)
{
return(true);
}
else if (TimeSpan.Compare(ftime, aFtime) <= 0 && TimeSpan.Compare(ttime, aTtime) > 0)
{
return(true);
}
//if (allocateClassroom.FromTime >= classroom.FromTime && allocateClassroom.FromTime<classroom.ToTime)
//{
// return true;
//}
//else if (allocateClassroom.ToTime > classroom.FromTime && allocateClassroom.ToTime < classroom.ToTime)
//{
// return true;
//}
}
return(false);
}
public int SaveAllocateClassroomInfo(AllocateClassroom allocateClassroom)
{
_query = "INSERT INTO AllocateClassroom(CourseId,RoomId,DayId,AllocateFromDate,AllocateToDate) values(@CourseId, @RoomId,@DayId,@AllocateFromDate,@AllocateToDate)";
_command = new SqlCommand(_query, _connection);
TimeSpan time = new TimeSpan();
time.ToString();
//cmd.Parameters.AddWithValue("@Date", Convert.ToDateTime(DateTime.Now.ToShortDateString()));
//cmd.Parameters.AddWithValue("@Time", Convert.ToDateTime(DateTime.Now.ToString("HH:mm:ss")));
_command.Parameters.AddWithValue("@CourseId", allocateClassroom.CourseId);
_command.Parameters.AddWithValue("@RoomId", allocateClassroom.RoomId);
_command.Parameters.AddWithValue("@DayId", allocateClassroom.DayId);
_command.Parameters.AddWithValue("@AllocateFromDate", allocateClassroom.AllocateFromDate.ToString("HH:mm:ss"));
_command.Parameters.AddWithValue("@AllocateToDate", Convert.ToDateTime(allocateClassroom.AllocateToDate.ToString("HH:mm:ss")));
_connection.Open();
int rowAffect = _command.ExecuteNonQuery();
_connection.Close();
return(rowAffect);
}
public ActionResult AllocateClassroom(AllocateClassroom allocateClassroom)
{
ViewBag.departments = ClassroomManager.GetAllDepartments();
ViewBag.rooms = ClassroomManager.GetAllRooms();
ViewBag.msg = ClassroomManager.Save(allocateClassroom);
return(View());
}
public int Save(AllocateClassroom allocate)
{
Query = "INSERT INTO AllocateClassroom (DepartmentId, CourseId, RoomId, FromTime, ToTime, Allocate, Day)" +
" VALUES ('" + allocate.DepartmentId + "','" + allocate.CourseId + "','" + allocate.RoomId + "','"
+ allocate.FromTime + "','" + allocate.ToTime + "','" + allocate.Allocate + "','" + allocate.Day + "')";
return(GetRowAffect(Query));
}
public List <AllocateClassroom> GetAllAllocationData()
{
Qurey = "SELECT * FROM allocateClassroom where status=@status";
Command = new SqlCommand(Qurey, Connection);
Command.Parameters.AddWithValue("@status", "active");
List <AllocateClassroom> allocateClassrooms = new List <AllocateClassroom>();
Connection.Open();
Reader = Command.ExecuteReader();
while (Reader.Read())
{
AllocateClassroom allocate = new AllocateClassroom();
allocate.Id = Convert.ToInt32(Reader["id"]);
allocate.CourseId = Convert.ToInt32(Reader["courseId"]);
allocate.DepartmentId = Convert.ToInt32(Reader["departmentId"]);
allocate.DayId = Convert.ToInt32(Reader["dayId"]);
allocate.RoomId = Convert.ToInt32(Reader["roomId"]);
allocate.StartingTime = Reader["fromTime"].ToString();
allocate.EndingTime = Reader["toTime"].ToString();
//allocate.FromTime = Convert.ToDouble(Reader["from"]);
//allocate.ToTime = Convert.ToDouble(Reader["to"]);
allocateClassrooms.Add(allocate);
}
Reader.Close();
Connection.Close();
return(allocateClassrooms);
}
public ActionResult AllocateClassroom(AllocateClassroom allocateClassroom)
{
try
{
if (ModelState.IsValid)
{
string msg;
int rowAffceted = _allocateClassroomManager.SaveAllocateRoomInfo(allocateClassroom);
msg = rowAffceted > 0 ? "Course Saved Successfully" : "Course Saved Failed";
ViewBag.msg = msg;
}
else
{
ViewBag.msg = "Student Information is Not valid";
}
}
catch (Exception e)
{
ViewBag.msg = e.Message;
}
finally
{
ViewBag.Rooms = _allocateClassroomManager.GetAllRooms();
ViewBag.Departments = _departmentManager.GettAllDepartment();
}
return(View());
}
public ActionResult AllocateClassrooms(AllocateClassroom allocateClassroom)
{
DateTime fromTime = allocateClassroom.FromTime;
if (fromTime.ToShortTimeString().Count() == 7)
{
allocateClassroom.StartingTime = 0 + fromTime.ToShortTimeString();
}
else
{
allocateClassroom.StartingTime = fromTime.ToShortTimeString();
}
DateTime toTime = allocateClassroom.ToTime;
if (toTime.ToShortTimeString().Count() == 7)
{
allocateClassroom.EndingTime = 0 + toTime.ToShortTimeString();
}
else
{
allocateClassroom.EndingTime = toTime.ToShortTimeString();
}
ViewBag.Departments = departmentManager.GetAllDepartments();
ViewBag.Classrooms = classroomManager.GetAllClassrooms();
ViewBag.Days = classroomManager.GetAllDays();
if (ModelState.IsValid)
{
ViewBag.Message = classroomManager.SaveClassroomAllocation(allocateClassroom);
}
return(View());
}
public int SaveAllocateClassRoom(AllocateClassroom aRoom)
{
SqlConnection connection = new SqlConnection(connectionString);
//string queary = "insert into tbl_Student(StudentName,Email,Contact,Dates,Addres,Id)VALUES('" + aStudent.Name + "','" + aStudent.Email + "','" + aStudent.ContactNo + "','" + aStudent.Date + "','" + aStudent.Address + "','" + aStudent.Id + "')";
string queary = "insert into tbl_Allocateion(Id,CourseName,RoomName,Day,Forms,Tows)values(@id,@course,@room,@day,@fromdate,@todate)";
SqlCommand command = new SqlCommand(queary, connection);
command.Parameters.Add("@id", SqlDbType.Int);
command.Parameters["@id"].Value = aRoom.DepartmentId;
command.Parameters.Add("@course", SqlDbType.VarChar);
command.Parameters["@course"].Value = aRoom.CourseName;
command.Parameters.Add("@room", SqlDbType.VarChar);
command.Parameters["@room"].Value = aRoom.RoomNo;
command.Parameters.Add("@day", SqlDbType.VarChar);
command.Parameters["@day"].Value = aRoom.Day;
command.Parameters.Add("@fromdate", SqlDbType.Time);
command.Parameters["@fromdate"].Value = aRoom.From;
command.Parameters.Add("@todate", SqlDbType.Time);
command.Parameters["@todate"].Value = aRoom.To;
connection.Open();
int roweffected = command.ExecuteNonQuery();
connection.Close();
return(roweffected);
}
public AllocateClassroom ifExitsTime(AllocateClassroom room)
{
SqlConnection connection = new SqlConnection(connectionString);
//string queary = "select*from tbl_AllocateCla where id=" + aClassRoom.Department + " and CourseID="+aClassRoom.CourseName+" and RoomId="+aClassRoom.RoomNo+" and DayId="+aClassRoom.Day+" and Froms="+aClassRoom.From+"and Twos="+aClassRoom.To+"";
string queary = "select*from tbl_Allocateion";
SqlCommand command = new SqlCommand(queary, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
AllocateClassroom classRoom = null;
while (reader.Read())
{
classRoom = new AllocateClassroom();
classRoom.AllocateClassroomId = (int)reader["Al_ID"];
classRoom.DepartmentId = (int)reader["Id"];
classRoom.CourseName = reader["CourseName"].ToString();
classRoom.RoomNo = reader["RoomName"].ToString();
classRoom.Day = reader["Day"].ToString();
classRoom.From = (TimeSpan)reader["Forms"];
classRoom.To = (TimeSpan)reader["Tows"];
}
reader.Close();
connection.Close();
return(classRoom);
}
public List <AllocateClassroom> GetAllAllocationList(AllocateClassroom allocateClassroom)
{
Command.CommandText = "SELECT * FROM AllocateClassroom where ClassroomId='" + allocateClassroom.ClassroomId + "' AND DayId='" + allocateClassroom.DayId + "'";
Connection.Open();
SqlDataReader reader = Command.ExecuteReader();
List <AllocateClassroom> allocateClassrooms = new List <AllocateClassroom>();
while (reader.Read())
{
AllocateClassroom ac = new AllocateClassroom();
ac.Id = (int)reader["Id"];
ac.DepartmentId = (int)reader["DepartmentId"];
ac.CourseId = (int)reader["CourseId"];
ac.ClassroomId = (int)reader["ClassroomId"];
ac.DayId = (int)reader["DayId"];
ac.ClassroomId = (int)reader["ClassroomId"];
ac.FromTime = (int)reader["FromTime"];
ac.ToTime = (int)reader["ToTime"];
allocateClassrooms.Add(ac);
}
reader.Close();
Connection.Close();
return(allocateClassrooms);
}
public ActionResult Allocate(AllocateClassroom allocate)
{
DepartmentManager aDepartmentManager = new DepartmentManager();
RoomManager aRoomManager = new RoomManager();
sevendaysManager aSevendaysManager = new sevendaysManager();
ViewBag.aldepartments = aDepartmentManager.GetAllDepartmentInfo();
ViewBag.allrooms = aRoomManager.GetAllRooms();
ViewBag.sevendays = aSevendaysManager.GetAllDays();
AllocateClassRoomManager allocateClassRoomManager = new AllocateClassRoomManager();
bool allocateRoom = allocateClassRoomManager.GetRoomCheck(allocate);
if (allocate.From > allocate.To)
{
ViewBag.message = "Your Time Formate isn't Right";
}
else if (allocateRoom)
{
ViewBag.message = "Room Is Not Free";
}
else
{
if (allocateClassRoomManager.SaveAllocateClassRoom(allocate) > 0)
{
ViewBag.message = "Room Is Allocated";
}
else
{
ViewBag.message = "Failed To Allocated";
}
}
return(View());
}
public List <AllocateClassroom> IsScheduleExists(AllocateClassroom allocateClassroom)
{
Query = "SELECT * FROM AllocateClassroom WHERE RoomId = @roomId AND Day = @day AND Allocate =@allocate ";
Command = new SqlCommand(Query, Connection);
Connection.Open();
Command.Parameters.Clear();
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("allocate", SqlDbType.Bit);
Command.Parameters["allocate"].Value = 1;
Reader = Command.ExecuteReader();
List <AllocateClassroom> allocateClassrooms = new List <AllocateClassroom>();
if (Reader.Read())
{
AllocateClassroom classroom = new AllocateClassroom()
{
FromTime = Reader["FromTime"].ToString(),
ToTime = Reader["ToTime"].ToString(),
Allocate = Reader["Allocate"].ToString()
};
allocateClassrooms.Add(classroom);
}
Reader.Close();
Connection.Close();
return(allocateClassrooms);
}
public List <Course> GetAllCourses(AllocateClassroom allocateClassroom)
{
Query = "SELECT * FROM Course Where DepartmentId = @id";
Command = new SqlCommand(Query, Connection);
Connection.Open();
Command.Parameters.Clear();
Command.Parameters.Add("id", SqlDbType.Int);
Command.Parameters["id"].Value = allocateClassroom.DepartmentId;
Reader = Command.ExecuteReader();
List <Course> courses = new List <Course>();
while (Reader.Read())
{
Course course = new Course()
{
Id = (int)Reader["Id"],
Name = Reader["Name"].ToString()
};
courses.Add(course);
}
Reader.Close();
Connection.Close();
return(courses);
}
public ActionResult Save(AllocateClassroom allocateClassroom)
{
try
{
int rowsAffected = allocateClassroomManager.Save(allocateClassroom);
if (rowsAffected > 0)
{
ViewBag.Message = "Saved";
}
else
{
ViewBag.Message = "Save failed";
}
}
catch (Exception exception)
{
ViewBag.Message = exception.Message;
}
ViewBag.Department = GetAllDepartments();
ViewBag.Course = GetAllCourses();
ViewBag.Day = GetAllDay();
ViewBag.Room = GetAllRoom();
return(View());
}
public string Allocate(AllocateClassroom _allocateClassroom)
{
if (_allocateClassRoomGateway.Check(_allocateClassroom))
{
return("Room is already allocated");
}
return(_allocateClassRoomGateway.Allocate(_allocateClassroom));
}
public int Save(AllocateClassroom allocateClassroom)
{
if (IsScheduleExist(allocateClassroom.TimeFrom, allocateClassroom.TimeTo))
{
throw new Exception("The Time Schedule already exists or partially overlapping!");
}
return(allocateClassroomGateway.Save(allocateClassroom));
}
public ActionResult Save(AllocateClassroom allocateClassroom)
{
ViewBag.Departments = departmentManager.GetAll();
ViewBag.Rooms = manager.GetAllRoom();
allocateClassroom.Allocate = "Yes";
ViewBag.msg = manager.Save(allocateClassroom);
return(View());
}
public ActionResult DeleteConfirmed(int id)
{
AllocateClassroom allocateClassroom = db.AllocateClassrooms.Find(id);
db.AllocateClassrooms.Remove(allocateClassroom);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void SaveAllocatedClassRoom(AllocateClassroom classroom)
{
using (_projectDbContext = new ProjectDbContext())
{
_projectDbContext.AllocateClassrooms.Add(classroom);
_projectDbContext.SaveChanges();
}
}
public List <AllocateClassroom> GetAllAllocateClassroomList()
{
List <AllocateClassroom> listOfAllocateClassroom = new List <AllocateClassroom>();
DBPlayer db = new DBPlayer();
try
{
db.cmdText = "SELECT * FROM AllocateClassroomListView ORDER BY RoomNo";
db.Open();
SqlDataReader reader = db.command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
AllocateClassroom allocateClassroom = new AllocateClassroom();
allocateClassroom.Id = int.Parse(reader["Id"].ToString());
allocateClassroom.RoomNo = reader["RoomNo"].ToString();
allocateClassroom.Day = reader["Day"].ToString();
allocateClassroom.FromTime = Convert.ToDateTime(reader["FromTime"].ToString());
allocateClassroom.ToTime = Convert.ToDateTime(reader["ToTime"].ToString());
allocateClassroom.Time = allocateClassroom.FromTime.ToShortTimeString() + " - " + allocateClassroom.ToTime.ToShortTimeString();
allocateClassroom.TimeDuration = reader["Duration"].ToString();
allocateClassroom.AllocationDate = Convert.ToDateTime(reader["AllocationDate"].ToString());
allocateClassroom.CourseId = int.Parse(reader["CourseId"].ToString());
allocateClassroom.CourseCode = reader["CourseCode"].ToString();
allocateClassroom.CourseName = reader["CourseName"].ToString();
allocateClassroom.DepartmentId = int.Parse(reader["DepartmentId"].ToString());
allocateClassroom.DepartmentName = reader["DepartmentName"].ToString();
allocateClassroom.StatusFlag = Convert.ToBoolean(reader["Status"]);
if (Convert.ToBoolean(reader["Status"]))
{
allocateClassroom.Status = "Allocated";
}
else
{
allocateClassroom.Status = "Unallocated";
}
listOfAllocateClassroom.Add(allocateClassroom);
}
}
reader.Close();
}
catch (Exception)
{
throw;
}
finally
{
db.Close();
}
return(listOfAllocateClassroom);
}
public int SaveAllocateRoomInfo(AllocateClassroom allocateClassroom)
{
if (IsRoomAvailable(allocateClassroom.Day, allocateClassroom.FromTime, allocateClassroom.ToTime, int.Parse(allocateClassroom.RoomNo)))
{
return(_allocateClassroomGateway.SaveAllocateRoomInfo(allocateClassroom));
}
throw new Exception("Room Is Not Available With This Time!!");
}
public ActionResult Index(AllocateClassroom _allocateClassroom)
{
ViewBag.Message = _allocateClassRoomManager.Allocate(_allocateClassroom);
ViewBag.StartTime = _startTimeManager.GetAllTimes();
ViewBag.EndTime = _endTimeManager.GetAllTimes();
ViewBag.Rooms = _roomManager.GetAllRooms();
ViewBag.Days = _daysManager.GetAllDays();
ViewBag.Departments = _departmentManager.GetAllDepartment();
return(View());
}
public ActionResult AllocateClassrooms(AllocateClassroom allocateClassroom)
{
ViewBag.departments = aDepartmentManager.ViewAllDepartments();
ViewBag.rooms = aRoomManager.GetAllRooms();
ViewBag.days = aRoomManager.GetDays();
//string fromTime = allocateClassroom.FromTime.ToShortTimeString();
//string toTime = allocateClassroom.ToTime.ToShortTimeString();
//DateTime t = DateTime.Parse(toTime);
//allocateClassroom.Ttime = toTime;
//allocateClassroom.Ftime = fromTime;
//DateTime time = DateTime.Parse("6/22/2009 09:30AM");
//DateTime compare = DateTime.Parse(time.ToShortDateString() + " 2:00PM");
//bool greater = (time < compare);
//TimeSpan t1 = allocateClassroom.FromTime.TimeOfDay;
//TimeSpan t2 = time.TimeOfDay;
//int com = TimeSpan.Compare(t1, t2);
//DateTime time1 = DateTime.Parse("6/21/2009 10:00AM");
//DateTime compare1 = DateTime.Parse("5/23/2009 10:00PM");
//bool greater1 = (time > compare);
//DateTime time2 = DateTime.Parse("5/21/2009 10:00AM");
//DateTime compare2 = DateTime.Parse("5/21/2009 10:00AM");
//bool greater2 = (time == compare);
//dt.ToString("HH:mm"); // 07:00 // 24 hour clock // hour is always 2 digits
//if (allocateClassroom.FromTime>allocateClassroom.ToTime)
//{
// Response.Write("totime");
// //Console.WriteLine("tym_one is before tym_two");
//}
//else if (allocateClassroom.FromTime < allocateClassroom.ToTime)
//{
// Response.Write("fromtime");
// //Console.WriteLine("tym_one is after tym_two");
//}
//else
//{
// Response.Write("same");
// //Console.WriteLine("tym_one is the same as tym_two");
//}
ViewBag.message = aRoomManager.AllocateRoom(allocateClassroom);
return(View());
}
public ActionResult Index(int departmentId, AllocateClassroom allocateClassroom)
{
ViewBag.Departments = _departmentManager.GetAllDepartmentsManager();
ViewBag.Rooms = _roomManager.GetAllRoomsManager();
ViewBag.Days = _dayManager.GetAllDaysManager();
ViewBag.message = _allocateClassroomManager.AllocateClassroominfoSave(allocateClassroom);
return(View());
}
public bool UpdateAllocateClassroom(AllocateClassroom allocateClassroom)
{
bool flag = false;
DBPlayer db = new DBPlayer();
try
{
string fromTime = allocateClassroom.FromTime.ToString("hh:mm tt");
string toTime = allocateClassroom.ToTime.ToString("hh:mm tt");
TimeSpan start = TimeSpan.Parse(allocateClassroom.FromTime.ToString("HH:mm"));
TimeSpan end = TimeSpan.Parse(allocateClassroom.ToTime.ToString("HH:mm"));
//TimeSpan duration = allocateClassroom.ToTime - allocateClassroom.FromTime;
TimeSpan duration = new TimeSpan(0, 0, 0, (int)allocateClassroom.ToTime.Subtract(allocateClassroom.FromTime).TotalSeconds);
db.cmdText = "UPDATE AllocateClassrooms SET RoomNo = @RoomNo, Day = @Day, FromTime = @FromTime, ToTime = @ToTime, StartTime = @StartTime, EndTime = @EndTime, Duration = @Duration, AllocationDate = @AllocationDate, Status = @Status WHERE Id = @Id AND DepartmentId = @DepartmentId AND CourseId = @CourseId";
db.command.Parameters.AddWithValue("@RoomNo", allocateClassroom.RoomNo);
db.command.Parameters.AddWithValue("@Day", allocateClassroom.Day);
db.command.Parameters.AddWithValue("@FromTime", fromTime);
db.command.Parameters.AddWithValue("@ToTime", toTime);
db.command.Parameters.AddWithValue("@StartTime", start);
db.command.Parameters.AddWithValue("@EndTime", end);
db.command.Parameters.AddWithValue("@Duration", duration);
db.command.Parameters.AddWithValue("@AllocationDate", DateTime.Now);
db.command.Parameters.AddWithValue("@Status", allocateClassroom.StatusFlag);
db.command.Parameters.AddWithValue("@Id", allocateClassroom.Id);
db.command.Parameters.AddWithValue("@DepartmentId", allocateClassroom.DepartmentId);
db.command.Parameters.AddWithValue("@CourseId", allocateClassroom.CourseId);
db.Open();
int rowsAffected = db.command.ExecuteNonQuery();
if (rowsAffected > 0)
{
flag = true;
}
else
{
flag = false;
}
}
catch (Exception)
{
throw;
}
finally
{
db.Close();
}
return(flag);
}
public int SaveAllocation(AllocateClassroom aClassroom)
{
Query = "INSERT INTO AllocateClassroom VALUES ('" + aClassroom.DepartmentId + "','" + aClassroom.CourseId +
"','" + aClassroom.RoomId + "','" + aClassroom.DayId + "','" + aClassroom.FromTime + "','" +
aClassroom.ToTime + "','True')";
Command = new SqlCommand(Query, Connection);
Connection.Open();
int rowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffected);
}
