private void InitDoor()
{
u1 = new OfficeUser() { Birthday = DateTime.Today, EmployeeNumber = "12046", Gender = Gender.Male, Name = "Devin" };
t1 = new Teacher() { Birthday = Convert.ToDateTime("1984-1-1"), EmployeeNumber = "12334", Gender = Gender.Female, Major = "Math", Name = "StevenMath" };
Session.SaveOrUpdate(u1);
Session.SaveOrUpdate(t1);
Student s1 = new Student() { Birthday = Convert.ToDateTime("1983-12-20"), Gender = Gender.Male, Name = "Jack" };
Session.SaveOrUpdate(s1);
Lab l1 = new Lab() { Address = "Teaching Tower 1", Description = "For chemistry", Size = 70, LabSubject = "Primary Chemistry" };
Classroom cr1 = new Classroom() { Address = "Teaching Building 2", Description = "Common Room", RoomNumber = "402", Size = 150 };
Session.SaveOrUpdate(l1);
Session.SaveOrUpdate(cr1);
Session.Flush();
Education e1=new Education(){Employee = t1,GraduateYear = 2003,University = "UESTC"};
Education e11 = new Education() { Employee = t1, GraduateYear = 2007, University = "BJU" };
Education e2 = new Education() { Employee = u1, GraduateYear = 2001, University = "USTC" };
t1.Educations.Add(e1);
t1.Educations.Add(e11);
u1.Educations.Add(e2);
DoorKey doorKey = new DoorKey() { Name = "401 Key" };
doorKey.Employees = new List<Employee>();
doorKey.Employees.Add(u1);
doorKey.Employees.Add(t1);
Session.SaveOrUpdate(doorKey);
Session.Flush();
}
public FullClassRecord(ClassTime classTime, Group group, Subject subject,
Lecturer lecturer, Classroom classroom)
{
Group = group;
ClassTime = classTime;
Subject = subject;
Lecturer = lecturer;
Classroom = classroom;
}
public Schedule chooseRandomSchedule(Classroom clas)
{
Random rndElement = new Random();
int index;
if (clas.scheduleList.Count > 0)
{
index = rndElement.Next(0, clas.scheduleList.Count);
return clas.scheduleList[index];
}
else return null;
}
public static ClassroomInfoModel CreateClassroomInfoModel(Classroom classroom, bool available = false)
{
return new ClassroomInfoModel()
{
Id = classroom.Id,
Capacity = classroom.Capacity,
Number = classroom.Number,
Type = classroom.Type,
Available = available //DEFAULT FALSE
};
}
static void Main()
{
Classroom newClassroom = new Classroom("12A", new Discipline("Math", 30));
Student pesho = new Student("Pesho", 12, newClassroom);
Console.WriteLine(
"{0} is a student in {1}, he is number {2} in class. He studies: {3}.",
pesho.Name,
pesho.Class.Identifier,
pesho.ClassNumber,
string.Join(", ", pesho.SubjectNames));
}
public string[] GetAllStudents_NoLinq(Classroom[] classes)
{
var allStudents = new List<string>();
foreach (var classroom in classes)
{
foreach (var student in classroom.Students)
{
allStudents.Add(student);
}
}
return allStudents.ToArray();
}
private bool _populate_classrooms(string json)
{
JSONNode _json = JSON.Parse (json);
foreach (JSONNode node in ((JSONArray)_json ["result"])) {
Classroom cRoom = new Classroom (node);
Button button = ((Button)Instantiate (buttonModel));
button.GetComponentInChildren <Text> ().text = cRoom._name;
button.onClick.AddListener (() => setClassroom (cRoom));
button.transform.parent = ContentPanel.transform;
}
return true;
}
private void setClassroom(Classroom cRoom)
{
getSession().classroom = cRoom;
switch (getSession ().user._type) {
case 0:
uiBehaviour.setState (uiBehaviour.CLASROOM_STADISTIC_STATE);
break;
case 1:
uiBehaviour.setState (uiBehaviour.CLASSROOM_STATE);
break;
}
}
public void TestInsert3ClassData()
{
Place p=new Place(){Address = "place",Description = "this is a place",Size = 100};
Session.SaveOrUpdate(p);
Classroom c = new Classroom() { Address = "place", Description = "this is a place", Size = 100,RoomNumber = "301"};
Session.SaveOrUpdate(c);
Lab l = new Lab() { Address = "place", Description = "this is a place", Size = 100,LabSubject = "Physical"};
Session.SaveOrUpdate(l);
Session.Flush();
var list = NewSession.QueryOver<Place>().List();
Assert.Greater(list.Count,0);
foreach (var place in list)
{
Debug.WriteLine(place.GetType().ToString());
}
}
public async Task <ReturnMessage> GetClassroomAsync(string imei)
{
string requestUrl = $@"SupperSchool/AuthenticationClassRoom?classRoomImei={imei}";
ReturnMessage bmsMessage = await Request(requestUrl);
if (!bmsMessage.HasError)
{
JObject jObject = JObject.Parse(bmsMessage.Data.ToString());
string sClassroom = jObject.SelectToken("classroom").ToString();
Classroom classroom = JsonConvert.DeserializeObject <Classroom>(sClassroom);
bmsMessage.Data = classroom;
}
return(bmsMessage);
}
public IEnumerable <object> GetReservationsByClassroomId(long id)
{
Classroom classroom = this.Context.Classrooms.FirstOrDefault(c => c.id == id);
List <Reservation> reservations = this.Context.Reservations.Where(r => r.classroom_id == id).ToList();
List <object> events = new List <object>();
reservations.ForEach(r => {
events.Add(new {
classroom = classroom,
title = $"{r.start_time.Hour}:00 - {r.end_time.Hour}:00",
start = r.date_of_reservation.ToString("MM/dd/yyyy HH:mm:ss"),
end = r.date_of_reservation.ToString("MM/dd/yyyy HH:mm:ss")
});
});
return(events);
}
public JsonResult AddorUpdateClassroom(Classroom model)
{
bool result = false;
if (model.Id == 0)
{
result = CrRepo.Add(model);
}
else
{
Classroom Cr = CrRepo.Get(c => c.Id == model.Id);
Cr.ClassName = model.ClassName;
Cr.Description = model.Description;
Cr.TeacherId = model.TeacherId;
result = CrRepo.Update(Cr);
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public async Task ShouldPostClassroomAsync()
{
// given
Classroom randomClassroom = CreateRandomClassroom();
Classroom inputClassroom = randomClassroom;
Classroom expectedClassroom = inputClassroom;
// when
await this.otripleSApiBroker.PostClassroomAsync(inputClassroom);
Classroom actualClassroom =
await this.otripleSApiBroker.GetClassroomByIdAsync(inputClassroom.Id);
// then
actualClassroom.Should().BeEquivalentTo(expectedClassroom);
await this.otripleSApiBroker.DeleteClassroomByIdAsync(actualClassroom.Id);
}
static void Main()
{
Point p = new Point(11, 9);
Triangle t = new Triangle(new Point(11, 9), new Point(11, 9), new Point(11, 9));
Student st = new Student(76521, "Ze MAria");
Classroom cl = new Classroom(
new Student(76521, "Ze MAria"),
new Student(871364, "Maria Salome")
);
Logger l = new Logger()
.For <Point>(pt => String.Format("({0}, {1})", pt.X, pt.Y))
.For <DateTime>(dt => dt.ToString("yyyy-MM-dd"));
l.Fields(p);
l.Fields(t);
l.Fields(st);
l.Fields(cl);
}
public bool IsThisClassRoomsOverlapped(Classroom classroom)
{
string query = "SELECT * FROM Classrooms WHERE (('" + classroom.ClassStartFrom + "' BETWEEN ClassStartFrom AND ClassEndAt) OR ('" + classroom.ClassEndAt + "' BETWEEN ClassStartFrom AND ClassEndAt)) AND RoomId ='" + classroom.RoomId + "' AND Day ='" + classroom.Day + "'";
SqlCommand.CommandText = query;
SqlConnection.Open();
SqlDataReader reader = SqlCommand.ExecuteReader();
List <Classroom> roomsAllocateClassrooms = new List <Classroom>();
if (reader.HasRows)
{
SqlConnection.Close();
return(true);
}
SqlConnection.Close();
return(false);
}
public IHttpActionResult PostClassroom(Classroom classroom)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
classroom.SchoolFK = classroom.School.SchoolId;
classroom.TeacherFK = classroom.Teacher.TeacherId;
classroom.Teacher = null;
classroom.School = null;
db.ClassroomsDb.Add(classroom);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = classroom.ClassroomId }, classroom));
}
private void ClassroomCombo_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
classroom = ClassroomCombo.SelectedItem as Classroom;
if (classroom.Teacher == null)
{
classroom.Teacher = new Teacher("Dummy", "Person", new List <string>()
{
"dummy text"
});
}
if (classroom.Subject == null)
{
classroom.Subject = "No subject!";
}
lblTeacher.Content = classroom.Teacher.Fullname;
lblSubject.Content = classroom.Subject;
lstStudents.ItemsSource = classroom.Students;
}
public void AddClassRoom_WhenExistingClassroomAtSameTime_ReturnInvalid()
{
var existingRoom = new Classroom(
_defaultDate.AddHours(1),
_defaultDate.AddHours(3),
DayOfWeek.Monday);
var newRoom = new Classroom(
_defaultDate.AddHours(1),
_defaultDate.AddHours(3),
DayOfWeek.Monday);
_student.AddClassroom(existingRoom);
_student.AddClassroom(newRoom);
Assert.That(_student.Invalid, Is.True);
}
private void Button3_Click(object sender, EventArgs e)
{
using (var db = new AcademyDB())
{
Classroom classroom = db.Classrooms.FirstOrDefault(cr => cr.id == selectroomId);
//
classroom.Deleted = true;
if (db.SaveChanges() != 0)
{
MessageBox.Show("Deleted");
FormRefresh();
}
else
{
MessageBox.Show("Error!");
}
}
}
public String Save(Classroom classroom)
{
if (classroom.StartTime > classroom.Endtime)
{
return("To time can't less than From time )");
}
bool isTimeScheduleValid = IsTimeScheduleValid(classroom.RoomId, classroom.DayId, classroom.StartTime, classroom.Endtime);
if (isTimeScheduleValid != true)
{
if (classroomGateway.Save(classroom) > 0)
{
return("Saved Successfully !");
}
return("Failed to save");
}
return("Overlapping not allowed");
}
public async Task <ActionResult> Update(Classroom classroom)
{
if (classroom != null)
{
var result = await _classroomService.GetClassroomAsync(classroom.ClassroomId);
if (result != null)
{
result.Name = classroom.Name;
await _classroomService.UpdateClassroomAsync(result);
return(RedirectToAction("List", new { id = result.SchoolId }));
}
}
return(HttpNotFound());
}
public async Task <IActionResult> OnGetAsync(string id)
{
if (id == null)
{
return(NotFound());
}
Classroom = await Context.Classrooms
.Include(c => c.Teacher)
.Include(c => c.Enrollments)
.FirstOrDefaultAsync(m => m.ClassroomID == id);
if (Classroom == null)
{
return(NotFound());
}
return(Page());
}
// Delete button
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
var senderGrid = (DataGridView)sender;
// if column is Delete button column
if (senderGrid.Columns[e.ColumnIndex] is DataGridViewButtonColumn && e.RowIndex >= 0 && e.RowIndex != dataGridView1.Rows.Count - 1)
{
DataGridViewRow row = dataGridView1.Rows[e.RowIndex];
DialogResult result = MessageBox.Show(row.Cells[1].Value.ToString(), "Are you sure to delete?", MessageBoxButtons.OKCancel);
if (result == DialogResult.OK)
{
using (var db = new AcademyDB())
{
int clsID = (int)row.Cells[0].Value;
Classroom cls = db.Classroom.FirstOrDefault(c => c.id == clsID);
Group grup = db.Group.FirstOrDefault(gr => gr.ClassroomID == clsID);
if (grup != null)
{
DialogResult res = MessageBox.Show("The " + cls.Name + " contains group " + grup.Name + " if u will delete this classroom all group will be deleted", "Are you sure to delete?", MessageBoxButtons.OKCancel);
if (res == DialogResult.OK)
{
cls.Deleted = true;
}
}
else
{
cls.Deleted = true;
}
if (db.SaveChanges() != 0)
{
refreshForm();
}
else
{
MessageBox.Show("Classroom not deleted");
}
}
}
}
}
/// <summary>Adding classroom</summary>
private void Potvrda_Click(object sender, RoutedEventArgs e)
{
Console.WriteLine("Adding Classroom with data: {0}, {1}, {2}, {3}, {4}, {5}, {6}", Identificator.Text, Description.Text, Helper.ParseStringToInt(brojMijestaUpDown.Text),
Helper.CheckBoxToBool(ProjectorNeeded), Helper.CheckBoxToBool(TableNeeded), Helper.CheckBoxToBool(SmartTableNeeded), Helper.GetOSFromString(OperatingSystem.Text));
if (!Validate())
{
return;
}
if (string.IsNullOrEmpty(SelectedClassroom.Id))
{
Classroom created =
ClassroomHandler.Instance.Add(Identificator.Text, Description.Text, Helper.ParseStringToInt(brojMijestaUpDown.Text),
Helper.CheckBoxToBool(ProjectorNeeded), Helper.CheckBoxToBool(TableNeeded), Helper.CheckBoxToBool(SmartTableNeeded),
Helper.GetOSFromString(OperatingSystem.Text), (MainWindow)Window.GetWindow(this));
TerminHandler.Instance.AddClassroom(created.Id);
((MainWindow)Window.GetWindow(this)).GlobalnaShema.AddResource(created);
((MainWindow)Window.GetWindow(this)).AddClassroomButton(created);
}
else
{
ClassroomHandler.Instance.Update(SelectedClassroom.Id, Identificator.Text, Description.Text, Helper.ParseStringToInt(brojMijestaUpDown.Text),
Helper.CheckBoxToBool(ProjectorNeeded), Helper.CheckBoxToBool(TableNeeded), Helper.CheckBoxToBool(SmartTableNeeded),
Helper.GetOSFromString(OperatingSystem.Text), (MainWindow)Window.GetWindow(this));
}
if (SoftwaresList.SelectedItems != null && SoftwaresList.SelectedItems.Count > 0)
{
List <string> softwares = new List <string>();
foreach (Software s in SoftwaresList.SelectedItems)
{
softwares.Add(s.Id);
}
ClassroomHandler.Instance.FindById(Identificator.Text).InstalledSoftware = softwares;
}
((MainWindow)Window.GetWindow(this)).Ucionice_Show();
}
public bool OpenData()
{
bool result = true;
Console.Write("Ingrese el ID del salon: ");
Id = Console.ReadLine();
bool found = false;
ClassroomList.ForEach(newRoom =>
{
if (!(found))
{
found = newRoom.Id == Id;
if (found)
{
Room = newRoom;
}
}
});
if (!found)
{
Console.WriteLine("Salon no encontrado");
result = false;
}
else
{
Console.Write("Ingrese el tiempo para abrir el salon: ");
int newVal;
Int32.TryParse(Console.ReadLine(), out newVal);
IntValidate.Value = newVal;
result = result && IntValidate.ValidateField();
On = newVal;
if (!result)
{
Console.WriteLine("Datos invalidos");
}
}
return(result);
}
private void btnShow_Click(object sender, EventArgs e)
{
try
{
bool sonuc;
Classroom cs = new Classroom();
cs.ClassroomName = txtClassName.Text.Trim();
cs.Capacity = Convert.ToInt32(txtCapacity.Text.Trim());
sonuc = classroomid == 0 ? ClassroomBL.InsertClassroom(cs) : ClassroomBL.UpdateClassroom(cs);
MessageBox.Show(sonuc ? "Başarılı" : "Başarısız");
btnCancel.PerformClick();
}
catch (SqlException ex)
{
MessageBox.Show("Hata" + ex.Number);
}
}
public Student(
Name firstName,
Name lastName,
StudentNumber studentNumber,
Classroom classroom,
IEnumerable <Contact> contacts,
string citizenshipIdentity,
string notes,
string source)
{
FirstName = firstName;
LastName = lastName;
StudentNumber = studentNumber;
Classroom = classroom;
CitizenshipIdentity = citizenshipIdentity;
_contacts.AddRange(contacts);
Notes = notes;
Source = source;
}
/// <summary>
/// Returns a user.
/// </summary>
private ClassroomMembership GetStudent(Classroom classroom, string team, string sectionName)
{
return(new ClassroomMembership()
{
Classroom = classroom,
ClassroomId = classroom.Id,
GitHubTeam = team,
SectionMemberships = Collections.CreateList
(
new SectionMembership()
{
Section = new Section()
{
Name = sectionName
}
}
)
});
}
private void RemoveStudents(Classroom classroom, List <Guid> studentIds)
{
var idsAtuais = classroom.DeliveryPlans.SelectMany(x => x.Students).Select(x => x.Id).ToList();
if (studentIds == null)
{
studentIds = new List <Guid>();
}
var studentsToDelete = idsAtuais.Except(studentIds).ToList();
foreach (var item in _context.GetList <Student>().Where(a => studentsToDelete.Contains(a.Id)).ToList())
{
foreach (var deliveryPlan in item.DeliveryPlans.Where(p => p.Classroom.Id == classroom.Id).ToList())
{
deliveryPlan.Students.Remove(item);
}
}
}
public JsonResult Create([FromBody] Reservation reservation)
{
if (reservation == null)
{
return(new JsonResult(new { error = "2", errormessage = "Not found!" }));
}
Reservation item = this.Context.Reservations.FirstOrDefault(
c =>
c.classroom_id == reservation.classroom_id &&
c.date_of_reservation == new DateTime(reservation.date_of_reservation.Year, reservation.date_of_reservation.Month, reservation.date_of_reservation.Day, 0, 0, 0) &&
c.start_time == new DateTime(reservation.date_of_reservation.Year, reservation.date_of_reservation.Month, reservation.date_of_reservation.Day, reservation.start_time.Hour + 2, 0, 0) &&
c.end_time == new DateTime(reservation.date_of_reservation.Year, reservation.date_of_reservation.Month, reservation.date_of_reservation.Day, reservation.end_time.Hour + 2, 0, 0)
);
if (item != null)
{
return(new JsonResult(new { error = "1", errormessage = "This timeslot has already been taken!" }));
}
Classroom classroom = this.Context.Classrooms.FirstOrDefault(c => c.id == reservation.classroom_id);
User user = this.Context.Users.FirstOrDefault(c => c.id == reservation.user_id);
//Confirmation mail of reservation
string subject = "Reservatie gemaakt op HRO!";
string body = "U heeft lokaal " + classroom.name + " gereserveerd op ";
body += reservation.date_of_reservation.Day + "-" + reservation.date_of_reservation.Month + "-" + reservation.date_of_reservation.Year;
body += "om " + reservation.start_time.Hour + " tot " + reservation.end_time.Hour;
//Send mail
Helper.NotificationMail(user, subject, body);
reservation.user_id = reservation.user_id;
reservation.date_of_reservation = new DateTime(reservation.date_of_reservation.Year, reservation.date_of_reservation.Month, reservation.date_of_reservation.Day, 0, 0, 0);
reservation.created_at = new DateTime(reservation.start_time.Year, reservation.start_time.Month, reservation.start_time.Day, reservation.start_time.Hour + 2, 0, 0);
reservation.start_time = new DateTime(reservation.date_of_reservation.Year, reservation.date_of_reservation.Month, reservation.date_of_reservation.Day, reservation.start_time.Hour + 2, 0, 0);
reservation.end_time = new DateTime(reservation.date_of_reservation.Year, reservation.date_of_reservation.Month, reservation.date_of_reservation.Day, reservation.end_time.Hour + 2, 0, 0);
this.Context.Reservations.Add(reservation);
this.Context.SaveChanges();
return(new JsonResult(new { error = "0", errormessage = "Success!" }));
}
public int Save(Classroom classroom)
{
Query =
"INSERT INTO Classroom(DepartmentId,CourseId,RoomId,DayId,StartTime,Endtime,AllocationStatus) VALUES(@deptId,@courseId,@roomId,@dayId,@StartTime,@endTime,@allocationStatus)";
Command = new SqlCommand(Query, Connection);
Command.Parameters.Clear();
Command.Parameters.AddWithValue("@deptId", classroom.DepartmentId);
Command.Parameters.AddWithValue("@courseId", classroom.CourseId);
Command.Parameters.AddWithValue("@roomId", classroom.RoomId);
Command.Parameters.AddWithValue("@dayId", classroom.DayId);
Command.Parameters.AddWithValue("@startTime", classroom.StartTime.ToShortTimeString());
Command.Parameters.AddWithValue("@endTime", classroom.Endtime.ToShortTimeString());
Command.Parameters.AddWithValue("@allocationStatus", 1);
Connection.Open();
int rowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffected);
}
private void btnDelete_Click(object sender, RoutedEventArgs e)
{
if (dgrMain.SelectedIndex != -1)
{
Classroom c = classroomShow.ElementAt(dgrMain.SelectedIndex);
MainWindow.classrooms.Remove(c);
foreach (Subject cc in MainWindow.subjects)
{
for (int i = c.Termini.Count - 1; i > -1; i--)
{
if (cc.Naziv.Equals(c.Termini[i].Predmet))
{
cc.BrTermina += 1;
}
}
}
save();
}
}
public async Task ShouldPutClassroomAsync()
{
// given
Classroom randomClassroom = CreateRandomClassroom();
await this.otripleSApiBroker.PostClassroomAsync(randomClassroom);
Classroom modifiedClassroom = UpdateClassroomRandom(randomClassroom);
// when
await this.otripleSApiBroker.PutClassroomAsync(modifiedClassroom);
Classroom actualClassroom =
await this.otripleSApiBroker.GetClassroomByIdAsync(randomClassroom.Id);
// then
actualClassroom.Should().BeEquivalentTo(modifiedClassroom);
await this.otripleSApiBroker.DeleteClassroomByIdAsync(actualClassroom.Id);
}
private void OpenClassroom(int ClassroomValue)
{
SelectedClassroomValue = ClassroomValue;
Classroom Classroom = Classrooms[ClassroomValue];
Point Location = Classroom.Locations[0];
for (int y = 0; y < 5; y++)
{
for (int x = 0; x < 5; x++)
{
PictureBox PreviewTile = (PictureBox)tableLayoutPanel1.GetControlFromPosition(x, y);
if (Location.X + x - 2 < 0 || Location.Y + y - 2 < 0)
{
PreviewTile.Image = BlockTypes[0][0].Tile;
}
else
{
PreviewTile.Image = ((PictureBox)theGrid.GetControlFromPosition(Location.X + x - 2, Location.Y + y - 2)).BackgroundImage;
}
}
}
label34.Text = "Classroom " + Classroom.Number.ToString("D3");
numericUpDown11.Value = Classroom.Number;
if (Classroom.Blackboard.ItemID != -1)
{
pictureBox29.Image = ItemLargeIcons.Images[Classroom.Blackboard.ItemID];
button15.Enabled = true;
}
else
{
pictureBox29.Image = new Bitmap(64, 64);
button15.Enabled = false;
}
label42.Text = Language.GetString(Classroom.Blackboard.NameResource);
label41.Text = Language.GetString(Classroom.Blackboard.DescriptionResource);
tabControl1.SelectedTab = ClassroomViewer;
}
public ActionResult Create([Bind(Include = "ClassroomID,ClassroomName")] Classroom classroom)
{
try
{
if (ModelState.IsValid)
{
db.Classrooms.Add(classroom);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(classroom));
}
catch
{
Console.WriteLine("An error has occured");
return(null);
}
}
public async Task <IActionResult> Post([FromBody] Classroom value) // CREATE
{
if (value != null)
{
await DbContext.Classroom.AddAsync(value);
await DbContext.SaveChangesAsync();
value.subject = await DbContext.Subjects.SingleOrDefaultAsync(m => m.Id == value.subjectsId);
value.professor = await DbContext.Professor.SingleOrDefaultAsync(m => m.Id == value.professorId);
return(Ok(value));
}
else
{
return(BadRequest());
}
}
private bool Delete()
{
using (MyAcademyEntities db = new MyAcademyEntities())
{
Classroom DeletedData = db.Classrooms.Where(x => x.ID_room == SelectedID).FirstOrDefault();
string Dialog = "Seçilmiş " + DeletedData.Name_room + " otağını silmək istəyirsiniz?";
DialogResult result = MessageBox.Show(Dialog, "Silmək Sorğusu!", MessageBoxButtons.YesNo);
if (DialogResult.Yes != result)
{
MessageBox.Show("Seçilmiş " + DeletedData.Name_room + " otağı Silinmədi.", "Silmək Sorğusuna cavab");
return(false);
}
else
{
DeletedData.Status_room = false;
return(GoCheck.isDeleted(db.SaveChanges()));
}
}
}
public void t4_classrooms_can_be_renamed()
{
School s = new School("Evariste Galois");
Classroom c1 = s.AddClassRoom("CE1-1");
Classroom c2 = s.AddClassRoom("CE1-2");
Assert.That(s.FindClassRoom("CE1-1"), Is.SameAs(c1));
Assert.That(s.FindClassRoom("CE1-2"), Is.SameAs(c2));
c1.Name = "XRQ-3712";
Assert.That(s.FindClassRoom("CE1-1"), Is.Null);
Assert.That(c1.Name, Is.EqualTo("XRQ-3712"));
Assert.That(s.FindClassRoom("XRQ-3712"), Is.SameAs(c1));
Assert.Throws <ArgumentException>(() => c1.Name = "CE1-2");
Assert.DoesNotThrow(() => c2.Name = "CE1-2");
Assert.DoesNotThrow(() => c1.Name = "XRQ-3712");
}
public ActionResult Create(Classroom model, string returnUrl)
{
try
{
ApplicationUser teacher;
if (model.Teacher == null)
{
teacher = UserManager.FindById(User.Identity.GetUserId());
}
else
{
teacher = UserManager.FindByEmail(model.Teacher.Email);
}
if (teacher != null)
{
if (UserManager.IsInRole(teacher.Id, "Teacher"))
{
model.Teacher = db.Users.Find(teacher.Id);
db.Classrooms.Add(model);
db.SaveChanges();
if (string.IsNullOrEmpty(returnUrl))
{
return(RedirectToAction("Index", "Home"));
}
return(Redirect(returnUrl));
}
else
{
ModelState.AddModelError("", "Этот пользователь не преподаватель!");
return(View());
}
}
else
{
ModelState.AddModelError("", "Такого пользователя не существует!");
return(View());
}
}
catch (Exception e)
{
return(RedirectToAction("Index", "Error", new { error = e.Message }));
}
}
public static string[] GetAllStudents(Classroom[] classes)
{
return classes.SelectMany(c => c.Students).ToArray();
}
private static void test_properties_without_parameters()
{
Employee e = new Employee();
e.Name = "Jeffrey Richter"; // Задаем имя сотрудника
e.Age = 48; // Задаем возраст сотрудника
Console.WriteLine(e.Name); // Выводим на экран "Jeffrey Richter"
Employee1 e1 = new Employee1();
e1.SetName("Jeffrey Richter"); // Обновление имени сотрудника
String EmployeeName = e1.GetName(); // Получение возраста сотрудника
e1.SetAge(41); // Обновление возраста сотрудника
e1.SetAge(-5); // Выдача исключения
// ArgumentOutOfRangeException
Int32 EmployeeAge = e1.GetAge(); // Получение возраста сотрудника
Employee2 e2 = new Employee2();
e2.Name = "Jeffrey Richter"; // "Задать" имя сотрудника
String EmployeeName2 = e2.Name; // "Получить" имя сотрудника
e2.Age = 41; // "Задать" возраст сотрудника
e2.Age = -5; // Вброс исключения
// ArgumentOutOfRangeException
Int32 EmployeeAge2 = e2.Age; // "Получить" возраст сотрудника
Employee e3 = new Employee() { Name = "Jeff", Age = 45 };
String s = new Employee { Name = "Jeff", Age = 45 }.ToString().ToUpper();
Classroom classroom = new Classroom
{
Students = { "Jeff", "Kristin", "Aidan", "Grant" }
};
// Вывести имена 4 студентов, находящихся в классе
foreach (var student in classroom.Students)
Console.WriteLine(student);
var table = new Dictionary<String, Int32> {{ "Jeffrey", 1 }, { "Kristin", 2 }, { "Aidan", 3 }, { "Grant", 4 }};
// Определение типа, создание сущности и инициализация свойств
var o1 = new { Name = "Jeff", Year = 1964 };
// Вывод свойств на консоль
Console.WriteLine("Name={0}, Year={1}", o1.Name, o1.Year); // Выводит:
// Name=Jeff, Year=1964
String Name = "Grant";
DateTime dt = DateTime.Now;
// Анонимный тип с двумя свойствами
// 1. Строковому свойству Name назначено значение Grant
// 2. Свойству Year типа Int32 Year назначен год из dt
var o2 = new { Name, dt.Year };
// Совпадение типов позволяет осуществлять операции сравнения и присваивания
Console.WriteLine("Objects are equal: " + o1.Equals(o2));
o1 = o2; // Присваивание
// Это работает, так как все объекты имею один анонимный тип
var people = new[] {
o1, // См. ранее в этом разделе
new { Name = "Kristin", Year = 1970 },
new { Name = "Aidan", Year = 2003 },
new { Name = "Grant", Year = 2008 }
};
// Организация перебора массива анонимных типов
// (ключевое слово var обязательно).
foreach (var person in people)
Console.WriteLine("Person={0}, Year={1}", person.Name, person.Year);
// String myDocuments = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments);
// var query =
// from pathname in Directory.GetFiles(myDocuments)
// let LastWriteTime = File.GetLastWriteTime(pathname)
// where LastWriteTime > (DateTime.Now - TimeSpan.FromDays(7))
// orderby LastWriteTime
// select new { Path = pathname, LastWriteTime };
// foreach (var file in query)
// Console.WriteLine("LastWriteTime={0}, Path={1}",
// file.LastWriteTime, file.Path);
}
/// <summary>
/// The first stage in editing a Classroom.
/// </summary>
/// <param name="id">The ClassroomID of the Course to edit. Zero indicates "new".</param>
/// <returns>The edit view.</returns>
public ActionResult Edit(int id)
{
Classroom classroom;
if (id == 0)
{
classroom = new Classroom() { ClassroomId = 0 };
User user = this.db.Query<User>().Where(u => u.EmailAddress == this.ControllerContext.HttpContext.User.Identity.Name).FirstOrDefault();
if (user != null)
{
classroom.UserId = user.UserId;
}
classroom.Start = new DateTime(DateTime.Today.Year, DateTime.Today.Month, DateTime.Today.Day, 8, 30, 0);
}
else
{
classroom = this.db.Query<Classroom>().Where(c => c.ClassroomId == id).FirstOrDefault();
if (classroom == null)
{
return this.HttpNotFound();
}
}
ViewBag.Session = Guid.NewGuid().ToString();
this.PopulateTemp(id, ViewBag.Session);
ViewBag.DataCenterId = new SelectList(this.db.Query<DataCenter>(), "DataCenterId", "Name", classroom.DataCenterId);
ViewBag.CourseId = new SelectList(this.db.Query<Course>(), "CourseId", "Name", classroom.CourseId);
ViewBag.UserId = new SelectList(this.db.Query<User>(), "UserId", "EmailAddress", classroom.UserId);
return this.View(classroom);
}
public Classroom ProcessRow(Classroom classroom, MySqlDataReader Reader)
{
return this.ProcessRow(classroom, Reader, 0);
}
public bool Delete(Classroom classroom)
{
return this.Delete(classroom.Id);
}
public void Save(Classroom classroom)
{
this._db.OpenConnection();
MySqlCommand command = this._db.CreateCommand();
command.CommandText = "UPDATE classroom SET room_number=?room_number WHERE id = ?id";
command.Parameters.Add(new MySqlParameter("?id", MySqlDbType.Int32)).Value = classroom.Id;
command.Parameters.Add(new MySqlParameter("?room_number", MySqlDbType.String)).Value = classroom.Room_number.ToString();
this._db.ExecuteCommand(command);
this._db.CloseConnection();
}
public Classroom ProcessRow(Classroom classroom, MySqlDataReader Reader, int offset)
{
classroom.Id = Reader.GetInt32(0 + offset);
classroom.Room_number = Reader.GetString(1 + offset);
return classroom;
}
/*
Напишите решение этой задачи с помощью Linq в одно выражение.
### Краткая справка
* `IEnumerable<R> SelectMany(this IEnumerable<T> items, Func<T, IEnumerable<R>> f)`
* `T[] ToArray(this IEnumerable<T> items)`
*/
public string[] GetAllStudents(Classroom[] classes)
{
throw new NotImplementedException();
}
public static StatisticOfClassroom StaticticOfClassroom(Schedule schedule, Classroom classroom)
{
return new StatisticOfClassroom(schedule, classroom);
}
public void SetUp()
{
ReBuildDatabase();
OfficeUser u1=new OfficeUser(){Birthday = DateTime.Today,EmployeeNumber = "12046",Gender = Gender.Male,Name = "Devin"};
Teacher t1=new Teacher(){Birthday = Convert.ToDateTime("1984-1-1"),EmployeeNumber = "12334",Gender = Gender.Female,Major = "Math",Name = "StevenMath"};
Session.SaveOrUpdate(u1);
Session.SaveOrUpdate(t1);
Student s1=new Student(){Birthday = Convert.ToDateTime("1983-12-20"),Gender = Gender.Male,Name = "Jack"};
Session.SaveOrUpdate(s1);
Lab l1=new Lab(){Address = "Teaching Tower 1",Description = "For chemistry",Size = 70,LabSubject = "Primary Chemistry"};
Classroom cr1=new Classroom(){Address = "Teaching Building 2",Description = "Common Room",RoomNumber = "402",Size = 150};
Session.SaveOrUpdate(l1);
Session.SaveOrUpdate(cr1);
Session.Flush();
DoorKey doorKey = new DoorKey() { Name = "401 Key" };
doorKey.Employees = new List<Employee>();
doorKey.Employees.Add(u1);
doorKey.Employees.Add(t1);
Session.SaveOrUpdate(doorKey);
Session.Flush();
}
