public ActionResult Add(int?Id
, string ClassName
, string Description
, string ListDepartmentID
, bool Status
)
{
ClassRoomService classRoomService = new ClassRoomService();
ClassRoom classRoom = classRoomService.FindByKey(Id);
classRoom.ClassName = ClassName;
classRoom.Description = Description;
if (!string.IsNullOrEmpty(ListDepartmentID))
{
classRoom.DepartmentID = Convert.ToInt32(ListDepartmentID);
}
classRoom.Description = Description;
classRoom.Status = Status;
classRoom.IsDelete = false;
if (Id.HasValue)
{
classRoomService.Update(classRoom);
setAlert("Sửa lớp thành công", "success");
}
else
{
classRoomService.Insert(classRoom);
setAlert("Thêm lớp thành công", "success");
}
return(RedirectToAction("Index"));
}
public ActionResult Add(int?Id)
{
ClassRoomService classroomservice = new ClassRoomService();
ClassRoom classroom = classroomservice.FindByKey(Id);
return(View(classroom));
}
public int Insert(ClassRoom room)
{
try
{
string query =
"INSERT INTO t_AllocateClassRoom VALUES(@deptId,@courseId,@roomId,@dayId,@StartTime,@endTime,@allocationStatus)";
CommandObj.CommandText = query;
CommandObj.Parameters.Clear();
CommandObj.Parameters.AddWithValue("@deptId", room.DepartmentId);
CommandObj.Parameters.AddWithValue("@courseId", room.CourseId);
CommandObj.Parameters.AddWithValue("@roomId", room.RoomId);
CommandObj.Parameters.AddWithValue("@dayId", room.DayId);
CommandObj.Parameters.AddWithValue("@startTime", room.StartTime.ToShortTimeString());
CommandObj.Parameters.AddWithValue("@endTime", room.Endtime.ToShortTimeString());
CommandObj.Parameters.AddWithValue("@allocationStatus", 1);
ConnectionObj.Open();
int rowAffected = CommandObj.ExecuteNonQuery();
return(rowAffected);
}
catch (Exception exception)
{
throw new Exception("Could not saved", exception);
}
finally
{
CommandObj.Dispose();
ConnectionObj.Close();
}
}
public ActionResult Add(int?id)
{
ClassRoomService service = new ClassRoomService();
ClassRoom classRoom = service.FindByKey(id);
return(View(classRoom));
}
public ActionResult SearchTest(QueryParams queryParams)
{
EquipmentResult result = new EquipmentResult();
Z_Room room = ZRoomService.GetEntity(u => u.F_RoomNo == queryParams.classroom).FirstOrDefault();
//获取该教室所有的设备
var zeList = ZEquipmentService.GetEntity(u => u.F_RoomId == room.F_Id).ToList();
byte fun = (byte)Convert.ToInt32(AppSettingUtils.GetValue("Search"));
ClassRoom classRoom = PortService.GetReturnDataTest(queryParams.classroom);
if (classRoom != null)
{
classRoom.Name = room?.F_FullName;
classRoom.ClassNo = room.F_EnCode; //教室编码
classRoom.Id = room.F_RoomNo;
var list = classRoom.SonserList;
classRoom.AbnormalSonserList = classRoom.SonserList.Where(u => u.Online == StateType.Offline).ToList();
classRoom.NormalSonserList = classRoom.SonserList.Where(u => u.Online == StateType.Online).ToList();
result.Count = zeList.Count;
result.ExceptionCount = classRoom.AbnormalSonserList.Count;
result.NormalCount = classRoom.NormalSonserList.Count;
result.AppendData = classRoom;
}
else
{
result.Message = "查询设备信息失败！请重试";
}
return(Json(result));
}
public void RemoveFavoriteClassRoom(Teacher teacher, ClassRoom classRoom)
{
if (favTeachersClassRooms.ContainsKey(teacher))
{
favTeachersClassRooms[teacher].Remove(classRoom);
}
}
/// <summary>
/// 初始化设备节点
/// </summary>
/// <param name="classroom">教室地址</param>
/// <returns></returns>
public ActionResult Init(string classroom)
{
byte b = 0x00;
byte fun = 0x1f;
EResult = PortService.SendConvertCmd(fun, classroom, "00", b);
EResult.Message = EResult.Status ? "查询设备信息成功" : "查询设备信息失败";
ClassRoom classRoom = PortService.GetReturnData(classroom);
var list = classRoom.SonserList;
List <Z_Equipment> zeList = new List <Z_Equipment>();
Z_Room room = ZRoomService.GetEntity(u => u.F_RoomNo == classroom).FirstOrDefault();
ZEquipmentService.DeleteEntitys(ZEquipmentService.GetEntity(u => u.F_RoomId == room.F_Id).ToList());
if (room != null)
{
foreach (var item in list)
{
var zEquipment = new Z_Equipment
{
F_Id = Guid.NewGuid().ToString(),
F_RoomId = room.F_Id,
F_FullName = item.Name,
F_EquipmentType = item.Type + "",
F_EnabledMark = true,
F_EquipmentNo = item.Id.IndexOf('_') != -1 ? item.Id.Split('_')[0] : item.Id
};
zeList.Add(zEquipment);
}
}
ZEquipmentService.AddEntitys(zeList);
EResult.AppendData = list;
return(Json(EResult, JsonRequestBehavior.AllowGet));
}
public ActionResult SearchAll(QueryParams queryParams)
{
EquipmentResult result = new EquipmentResult();
try
{
//查询该教室
Z_Room room = ZRoomService.GetEntity(u => u.F_RoomNo == queryParams.classroom).FirstOrDefault();
if (room == null) //没有该教室
{
result.Message = "教室地址有误！";
}
else
{
ClassRoom classRoom = PortService.Search(room, ref result);
//PortService.CloseConnect();
result.AppendData = classRoom;
}
}
catch (Exception exception)
{
result.ErrorData = exception.ToString();
result.Message = "查询设备信息失败";
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public bool CreateClassRoom(ClassRoom objClass)
{
var parameters = new
{
Name = objClass.Name,
Description = objClass.Description,
Location = objClass.Location,
InsertedOn = DateTime.Now,
InsertedBy = objClass.InsertedBy,
DepartmentId = objClass.DepartmentId,
OrganizationId = objClass.OrganizationId
};
using (IDbConnection connection = OpenConnection())
{
const string storedProcedure = "usp_addClassRoom";
int rowsAffected = connection.Execute(storedProcedure, parameters, commandType: CommandType.StoredProcedure);
SetIdentity <int>(connection, id => objClass.ClassRoomId = id);
if (rowsAffected > 0)
{
return(true);
}
return(false);
}
}
public void populateTimeTable(TimeTable timetb1)
{
int i = 0;
System.Console.WriteLine("populating started.......");
while ((i < 3))
{
TimeTable tempTimetable = timetb1;
List <ClassRoom> allrooms = tempTimetable.getRoom();
var allroomsIterator = allrooms.GetEnumerator();
while (allroomsIterator.MoveNext())
{
ClassRoom room = allroomsIterator.Current;
List <Day> weekdays = room.getWeek().getWeekDays();
weekdays.Shuffle();
if (!room.isLaboratory())
{
var daysIterator = weekdays.GetEnumerator();
while (daysIterator.MoveNext())
{
Day day = daysIterator.Current;
day.getTimeSlot().Shuffle();
}
}
}
this.timetables.Add(tempTimetable);
i++;
}
System.Console.WriteLine("populating done.......");
System.Console.WriteLine("display called.......");
this.display();
}
public void ClassroomCheckedChange(object sender, PropertyChangedEventArgs e)
{
if (e.PropertyName == "IsChecked")
{
ClassRoom classroom = sender as ClassRoom;
if (classroom.IsChecked.HasValue)
{
ICollection <ClassRoom> beforeChange = SelectedClassrooms;
classroom.ClassroomBuilding.PropertyChanged -= new PropertyChangedEventHandler(ClassroomBuildingCheckedChange);
//没有一个选中
if (classroom.ClassroomBuilding.ClassRooms.Count(c => c.IsChecked == true) == 0)
{
beforeChange.Add(sender as ClassRoom);
classroom.ClassroomBuilding.IsChecked = false;
}
//全部选中
else if (classroom.ClassroomBuilding.ClassRooms.Count(c => c.IsChecked != true) == 0)
{
beforeChange.Remove(sender as ClassRoom);
classroom.ClassroomBuilding.IsChecked = true;
}
else
{
classroom.ClassroomBuilding.IsChecked = null;
}
ICollection <ClassRoom> afterChange = SelectedClassrooms;
RaiseSelectedClassroomsChanged(beforeChange, afterChange);
classroom.ClassroomBuilding.PropertyChanged += new PropertyChangedEventHandler(ClassroomBuildingCheckedChange);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (((ELearn.User)Session["user"]) == null)
{
Response.Redirect("/default.aspx");
}
List <ELearn.User> users = new List <ELearn.User>();
if (((String)Session["userType"]).Equals("student"))
{
users.AddRange(ClassRoom.getClassroomTeachers(((Student)Session["user"]).classRoomID));
}
else if (((String)Session["userType"]).Equals("teacher"))
{
users.AddRange(Teacher.getAllTeachers());
users.AddRange(Teacher.GetTeacherStudents(((ELearn.User)Session["user"]).userID));
}
else if (((String)Session["userType"]).Equals("staff"))
{
users = ELearn.User.getAllUsers();
}
foreach (ELearn.User usr in users)
{
list1.Items.Add(new ListItem(usr.name, usr.userID.ToString()));
}
}
public ActionResult AddClassRoom(ClassRoom aClassRoom)
{
ViewBag.Categories = GetCategoriesForDropdownList();
ViewBag.Buildings = GetBuildingsForDropdownList();
ViewBag.Building = aTimeTableManager.GetAllBuilding();
ViewBag.Message = aTimeTableManager.AddClassRoom(aClassRoom);
return(View());
}
private bool seatingChartTooBig(ClassModel classModel, ClassRoom classRoom)
{
var seatingChartHorizontal = classModel.SeatingChartByStudentID.GetLength(0);
var seatingChartVertical = classModel.SeatingChartByStudentID.GetLength(1);
return(seatingChartHorizontal > classRoom.SeatsHorizontally &&
seatingChartVertical > classRoom.SeatsVertically);
}
public ClassRoomDTO(ClassRoom c)
{
ClassRoomId = c.ClassRoomId;
Name = c.Name;
SchoolId = c.SchoolId;
Projects = c.Projects.Select(g => new ProjectDTO(g)).ToList();
Pupils = c.Pupils.Select(p => new PupilDTO(p)).ToList();
}
private void ClassRoom_Click(object sender, EventArgs e)
{
//查询空闲
ClassRoom classRoom = new ClassRoom();
classRoom.MdiParent = this;
classRoom.Show();
}
private static void Main(string[] args)
{
ExcelentPupil excelentPupil = new ExcelentPupil();
BadPupil badPupil = new BadPupil();
GoodPupil goodPupil = new GoodPupil();
ClassRoom classRoom = new ClassRoom(goodPupil, badPupil, excelentPupil);
classRoom.ShowPupil();
}
public ClassRoom getClass()
{
// static data
Level l1 = new Level(1, "first grade");
ClassRoom c1 = new ClassRoom(1, l1);
return(c1);
}
public ClassroomVM(ClassRoom classroom, Department[] departments) : this(departments)
{
numberOfClassroom.Value = classroom.NumberOfClassroom;
capacity.Value = classroom.Capacity;
codeOfClassroom.Value = classroom.CodeOfClassroom;
specifics.Value = classroom.Specifics;
department.Value = departments.Single(d => d.CodeOfDepartment == classroom.CodeOfDepartment);
}
public ActionResult Index(ClassRoom classRoom)
{
ViewBag.Message = classRoomAllocationBll.AllocateClassRoom(classRoom);
ViewBag.Departments = departmentBll.GetDepartments();
ViewBag.days = Weekdayses();
ViewBag.Rooms = classRoomAllocationBll.GetRooms();
return(View());
}
public void DeleteClassRoom(ClassRoom classRoom)
{
if (classRoom == null)
{
throw new ArgumentNullException(nameof(classRoom));
}
_scoolDbContext.ClassRooms.Remove(classRoom);
}
public ActionResult DeleteConfirmed(int id)
{
ClassRoom classRoom = db.ClassRooms.Find(id);
db.ClassRooms.Remove(classRoom);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public static ClassRoomDTO ClassRoomToDTO(ClassRoom classRoom)
{
return(new ClassRoomDTO()
{
Id = classRoom.Id,
Label = classRoom.Label
});
}
public MessageDTO addUpdateStandrdDivision(ClassRoomDto classRoomDetail)
{
ClassRoom classR = Mapper.Map <ClassRoomDto, ClassRoom>(classRoomDetail);
Message msg = _class.createUpdateDivision(classR);
var result = Mapper.Map <Message, MessageDTO>(msg);
return(result);
}
public ActionResult Allocate(ClassRoom aClassRoom)
{
ViewBag.Message = aAllocateClassroomManager.Save(aClassRoom);
ViewBag.DepartmentList = aDepartmentManager.GetAllDepartmentForDropdown();
ViewBag.DayList = aDayManager.GetAllDayForDropdown();
ViewBag.RoomList = aRoomManager.GetAllRoomForDropdown();
return(View());
}
public void Init()
{
Pupil[] pupils = new Pupil[4];
pupils[0] = new GoodPupil();
pupils[1] = new GoodPupil();
pupils[2] = new BadPupil();
pupils[3] = new ExcellentPupil();
_target = new ClassRoom(pupils[0], pupils[1], pupils[2], pupils[3]);
}
public static ClassRoomEditViewModel ToEditableViewModel(this ClassRoom Model)
{
return(new ClassRoomEditViewModel()
{
ID = Model.ID,
Name = Model.Name,
SchoolID = Model.SchoolID
});
}
private static void Main(string[] args)
{
ExcelentPupil excelentPupil = new ExcelentPupil();
BadPupil badPupil = new BadPupil();
GoodPupil goodPupil = new GoodPupil();
ClassRoom classRoom = new ClassRoom(goodPupil, badPupil, excelentPupil);
classRoom.ShowPupil();
}
public async Task <IActionResult> Create(ClassRoom temp)
{
if (ModelState.IsValid)
{
_Context.ClassRoomList.Add(temp);
await _Context.SaveChangesAsync();
}
return(View("Index", await _Context.ClassRoomList.ToListAsync()));
}
private void AddButton_Click(object sender, RoutedEventArgs e)
{
ClassRoom NewClassRoom = new ClassRoom(this.ClassRoomName.Text.ToString(), this.ClassRoomDescription.Text.ToString());
ApplicationContext db = ApplicationContext.GetDbConnectionHandler();
db.Add(NewClassRoom);
db.SaveChanges();
this.Close();
}
public Schedule(int scheduleID, string day, TimeSpan start, TimeSpan end, ClassRoom classRoom, Subject subject)
{
this.scheduleID = scheduleID;
this.day = day;
this.start = start;
this.end = end;
this.classRoomID = classRoom.classRoomID;
this.subjectID = subject.subjectID;
}
private async void Button_Click_Add_ClassRoom(object sender, RoutedEventArgs e)
{
ClassRoom SchClassRoom = new ClassRoom();
SchClassRoom.Name = TextBoxClass.Text;
await Table.Database.SaveItemAsync <ClassRoom>(SchClassRoom);
LoadData();
}
public void AddFavoriteClassRoom(Teacher teacher, ClassRoom classRoom)
{
if (favTeachersClassRooms.ContainsKey(teacher))
{
favTeachersClassRooms[teacher].Add(classRoom);
}
else
{
favTeachersClassRooms.Add(teacher, new List<ClassRoom> { classRoom });
}
}
private void AddClassRoom(Teacher teacher, ClassRoom classRoom)
{
if (settings.ContainsKey(teacher))
{
settings[teacher].Add(classRoom);
}
else
{
settings.Add(teacher, new List<ClassRoom> { classRoom });
}
}
public List<FactorSettings> CheckClassRoom(ClassRoom classRoom)
{
this.ClassRoom = classRoom;
List<FactorSettings> usedFactors = new List<FactorSettings>();
Factors = FactorsEditors.GetUsersFactors(CurrentBase.Factors);
foreach (FactorSettings factor in Factors)
{
if (factor.Data != null && factor.Data.GetType() == typeof(Dictionary<Teacher, List<ClassRoom>>))
{
Dictionary<Teacher, List<ClassRoom>> data = (Dictionary < Teacher, List< ClassRoom >>)factor.Data;
data = (Dictionary<Teacher, List<ClassRoom>>)FactorsEditors.RestoreLinks(data, store);
foreach (List<ClassRoom> list in data.Values)
{
if (list.Contains(ClassRoom))
{
usedFactors.Add(factor);
break;
}
}
}
if (factor.Data != null && factor.Data.GetType() == typeof(Dictionary<StudentsClass, List<ClassRoom>>))
{
Dictionary<StudentsClass, List<ClassRoom>> data = (Dictionary<StudentsClass, List<ClassRoom>>)factor.Data;
data = (Dictionary<StudentsClass, List<ClassRoom>>)FactorsEditors.RestoreLinks(data, store);
foreach (List<ClassRoom> list in data.Values)
{
if (list.Contains(ClassRoom))
{
usedFactors.Add(factor);
break;
}
}
}
if (factor.Data != null && factor.Data.GetType() == typeof(List<FixedClasses>))
{
List<FixedClasses> data = (List<FixedClasses>)factor.Data;
data = (List<FixedClasses>)FactorsEditors.RestoreLinks(data, store);
foreach (FixedClasses list in data)
{
if (list.Room == ClassRoom )
{
usedFactors.Add(factor);
break;
}
}
}
}
return usedFactors;
}
public void DoSomething()
{
Pupil p1 = new ExcelentPupil();
Pupil p2 = new GoodPupil();
Pupil p3 = new BadPupil();
Pupil p4 = new GoodPupil();
Console.WriteLine("Class1:");
ClassRoom Class1;
Class1 = new ClassRoom(p1 , p2 , p3 , p4);
Console.WriteLine("Class2:");
ClassRoom Class2 = new ClassRoom(p1 , p2 , p3);
Console.WriteLine("Class3");
ClassRoom Class3 = new ClassRoom(p1, p3);
Console.ReadKey();
}
public FixedClasses(StudentsClass sClass, int time, ClassRoom room)
{
this.sClass = sClass;
this.Time = time;
this.Room = room;
}
Label CreateLabel(int row, int column, StudentsClass sClass, ClassRoom room, MouseButtonEventHandler mLeft, MouseButtonEventHandler mRight)
{
Label l = new Label();
if (sClass != null)
{
l.Background = new SolidColorBrush(Color.FromRgb(210, 255, 205));//фон ячейки с парой
}
else
{
l.Background = Brushes.White;
}
l.Height = CELL_HEIGHT;
l.Width = CELL_WIDTH;
l.BorderBrush = new SolidColorBrush(Color.FromRgb(255, 140, 0));//границы ячеек
l.BorderThickness = new Thickness(1);
l.SetValue(Grid.RowProperty, row);
l.SetValue(Grid.ColumnProperty, column);
if (sClass != null)
l.Content = sClass.Name + "(" + room.Housing + "/" + room.Number + ")";
l.HorizontalContentAlignment = HorizontalAlignment.Center;
l.MouseLeftButtonDown += mLeft;
l.MouseRightButtonDown += mRight;
l.FontSize = 11;
l.FontWeight = FontWeights.Bold;
return l;
}
public void MainMethod()
{
PrincipleRoom princi = new PrincipleRoom(1);
ClassRoom room2 = new ClassRoom(2, princi);
ClassRoom room3 = new ClassRoom(3, princi);
ClassRoom room4 = new ClassRoom(4, princi);
ClassRoom room5 = new ClassRoom(5, princi);
ClassRoom room6 = new ClassRoom(6, princi);
princi.RaiseSchoolBell("3");
}
public List<ClassRoomType> GetClassRoomTypeSecond(ClassRoom classRoom)
{
List<ClassRoomType> typeRoomReturn = new List<ClassRoomType>();
if (classRoom.ClassRoomTypes == null) return typeRoomReturn;
for (int indexTypeRoom = 0; indexTypeRoom < classRoom.ClassRoomTypes.Count(); indexTypeRoom++)
{
if (classRoom.SecondTypesMask[indexTypeRoom] == true)
{
typeRoomReturn.Add(classRoom.ClassRoomTypes[indexTypeRoom]);
}
}
if (typeRoomReturn.Count == 0) return typeRoomReturn;
return typeRoomReturn;
}
public void EditClassRoom(ClassRoom room, List<string> prymaryDescription, List<string> secondDescription)
{
int id = (int)((Domain.IDomainIdentity<ClassRoom>)room).ID;
int housing = room.Housing, number = room.Number;
List<ClassRoom> classrooms = eStorage.ClassRooms.ToList();
classrooms.Remove(room);
BitArray SecondTypesMask = new BitArray(prymaryDescription.Count + secondDescription.Count, false);
List<ClassRoomType> type = new List<ClassRoomType>();
int indexMask = 0;
for (int index = 0; index < eStorage.ClassRoomsTypes.Count(); index++)
{
foreach (var item in prymaryDescription)
{
if (item == eStorage.ClassRoomsTypes[index].Description)
{
type.Add(eStorage.ClassRoomsTypes[index]);
indexMask++;
}
}
foreach (var item in secondDescription)
{
if (item == eStorage.ClassRoomsTypes[index].Description)
{
type.Add(eStorage.ClassRoomsTypes[index]);
SecondTypesMask[indexMask] = true;
indexMask++;
}
}
}
classrooms.Add(new ClassRoom(id, number, housing, type, SecondTypesMask));
eStorage = new Domain.Services.EntityStorage(eStorage.Classes.ToArray(), eStorage.ClassRoomsTypes.ToArray(), eStorage.StudentSubGroups.ToArray(), eStorage.Teachers.ToArray(), classrooms);
}
public void DelClassRoom(ClassRoom classRoom)
{
List<ClassRoom> classRooms = eStorage.ClassRooms.ToList();
classRooms.Remove(classRoom);
eStorage = new Domain.Services.EntityStorage(eStorage.Classes.ToArray(), eStorage.ClassRoomsTypes.ToArray(), eStorage.StudentSubGroups.ToArray(), eStorage.Teachers.ToArray(), classRooms);
}
public ClassRoom GetReference(ClassRoom extObj)
{
foreach (ClassRoom item in ClassRooms)
{
if (((IDomainIdentity<ClassRoom>)item).EqualsByParams(extObj) && ((IDomainIdentity<ClassRoom>)item).EqualsByID(extObj))
{
return item;
}
}
return null;
}
public Student()
{
Age = new Age();
Class = new ClassRoom();
}
public IList<ClassRoom> GetAvailableRooms()
{
SqlServerUtility sql = new SqlServerUtility();
SqlDataReader reader = sql.ExecuteSqlReader(SQL_GET_ALL_AVAILABLE_ROOMS);
IList<ClassRoom> roomList = new List<ClassRoom>();
if (reader != null && !reader.IsClosed)
{
while (reader.Read())
{
CY.GFive.Core.Business.ClassRoom room = new ClassRoom();
if (!reader.IsDBNull(0)) room.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) room.Code = reader.GetString(1);
if (!reader.IsDBNull(2)) room.Name = reader.GetString(2);
if (!reader.IsDBNull(3)) room.RoomCate = reader.GetString(3);
if (!reader.IsDBNull(4)) room.AvailNum = reader.GetInt32(4);
if (!reader.IsDBNull(5)) room.RoomState = reader.GetString(5);
if (!reader.IsDBNull(6)) room.Multimedia = reader.GetString(6);
room.MarkOld();
roomList.Add(room);
}
reader.Close();
}
return roomList;
}
public static object RestoreLinks(ClassRoom data, EntityStorage storage)
{
return storage.GetReference(data);
}
private void RemoveClassRoom(Teacher teacher, ClassRoom classRoom)
{
if (settings.ContainsKey(teacher))
{
settings[teacher].Remove(classRoom);
}
}
