static double RunSecondLabScript()
{
// вывести число преподавателей по кафедрам
var startTime = DateTime.Now;
var teacherGroups = TeacherLogic
.Read(new Teacher {
PassportNumber = null
})
.Join(context.Departments,
t => t.DepartmentId,
d => d.Id,
(t, d) => new
{
TeacherPassportNumber = t.PassportNumber,
DepartmentName = d.Name
})
.GroupBy(rec => rec.DepartmentName)
.ToList();
var finishTime = DateTime.Now;
foreach (var group in teacherGroups)
{
Console.WriteLine(group.Key + " " + group.Count());
}
Console.WriteLine("---Скрипт SecondLabScript выполнен");
return((finishTime - startTime).TotalMilliseconds);
}
public void GetFirstNextTeacherId()
{
SetUp();
TeacherLogic logic = new TeacherLogic();
int expectedValue = 1;
Assert.IsTrue(logic.GetNextIdFree().Equals(expectedValue));
}
public TimetableController()
{
_logic = new TimetableLogic();
_logicCourse = new CourseLogic();
_logicModule = new ModuleLogic();
_logicTeacher = new TeacherLogic();
_repo = new AttendanceRepository();
}
protected override void OnLoad(EventArgs e)
{
this.SemesterField.DataSource = SemesterLogic.GetAll();
this.SemesterField.DataBind();
this.TeacherField.DataSource = TeacherLogic.GetAll();
this.TeacherField.DataBind();
this.CourseStatusField.DataSource = Enum.GetValues(typeof(DataAccess.CourseStatus));
this.CourseStatusField.DataBind();
}
public void AddTeacherSuccess()
{
SetUp();
TeacherLogic testLogic = new TeacherLogic();
Teacher newTeacher = TeacherTest();
testLogic.Add(newTeacher);
Assert.IsTrue(testLogic.Exists(newTeacher));
}
public ActionResult EditCourse(int id)
{
List <TeacherEntity> listTeacher = new List <TeacherEntity>();
TeacherLogic teacherLogic = new TeacherLogic();
listTeacher = teacherLogic.listTeacher(); // Obtenemos la lista de todos los profesores
ViewBag.ListTeachers = listTeacher; // Lo guardamos en un ViewBag
return(View(courseLogic.searchTeacher(id)));
}
public void RemoveTeacher(object selectedObject)
{
if (!(selectedObject is Teacher))
{
throw new WrongObjectException("Se esperaba un objeto del tipo [Teacher]");
}
Teacher toDelete = selectedObject as Teacher;
TeacherLogic logic = new TeacherLogic();
logic.Remove(toDelete);
}
public IHttpActionResult GetMark([FromUri] int teacherId)
{
try
{
return(Ok(TeacherLogic.GetMark(teacherId)));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public IHttpActionResult GetTeacher(int userId)
{
try
{
return(Ok(TeacherLogic.GetTeacherByUserId(userId)));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public void AddInvalidTeacherSuccess()
{
SetUp();
TeacherLogic testLogic = new TeacherLogic();
Teacher newTeacher = new Teacher();
testLogic.Add(newTeacher);
int expectedTeacherListLength = 0;
Assert.IsTrue(testLogic.Length() == expectedTeacherListLength);
}
public void ModifyTeacherModifyNonExistent()
{
SetUp();
TeacherLogic testLogic = new TeacherLogic();
Teacher newTeacher = TeacherTest();
Teacher anotherTeacher = TeacherTest();
anotherTeacher.Id = 4;
testLogic.Modify(newTeacher, anotherTeacher);
Assert.IsFalse(testLogic.Exists(anotherTeacher));
}
public void LengthSuccess()
{
SetUp();
TeacherLogic testLogic = new TeacherLogic();
Teacher newTeacher = TeacherTest();
Teacher anotherTeacher = TeacherTest();
anotherTeacher.Id = 555;
testLogic.Add(newTeacher);
testLogic.Add(anotherTeacher);
Assert.IsTrue(testLogic.Length() == 2);
}
public void DeleteTeacherSuccess()
{
SetUp();
TeacherLogic testLogic = new TeacherLogic();
Teacher newTeacher = new Teacher();
newTeacher.Id = 4;
newTeacher.Name = "toDelete";
testLogic.Add(newTeacher);
testLogic.Remove(newTeacher);
Assert.IsFalse(testLogic.Exists(newTeacher));
}
public string GetOneTeacher(int teacherId)
{
try
{
TeacherLogic teacherLogic = new TeacherLogic();
return(teacherLogic.GetOneTeacher(teacherId));
}
catch (Exception e)
{
return(e.Message);
}
}
public void AddTeacherFail()
{
SetUp();
TeacherLogic testLogic = new TeacherLogic();
Teacher newTeacher = TeacherTest();
testLogic.Add(newTeacher);
testLogic.Add(newTeacher);
int expectedTeacherListLength = 2;
Assert.IsTrue(testLogic.Length() == expectedTeacherListLength);
}
public void ModifyTeacherFailCheckOldTeacher()
{
SetUp();
TeacherLogic testLogic = new TeacherLogic();
Teacher newTeacher = TeacherTest();
Teacher anotherTeacher = TeacherTest();
anotherTeacher.Id = -3;
anotherTeacher.Name = "";
testLogic.Add(newTeacher);
testLogic.Modify(newTeacher, anotherTeacher);
Assert.IsTrue(testLogic.Exists(newTeacher));
}
static double DeleteTeacher()
{
var teacher = new Teacher {
PassportNumber = "7332089703"
};
var startTime = DateTime.Now;
TeacherLogic.Delete(teacher);
var finishTime = DateTime.Now;
Console.WriteLine("---Скрипт DeleteTeacher выполнен");
return((finishTime - startTime).TotalMilliseconds);
}
public void AddDifferentObjectTeacherFail()
{
SetUp();
TeacherLogic testLogic = new TeacherLogic();
Teacher newTeacher = TeacherTest();
int intTest = 0;
testLogic.Add(newTeacher);
testLogic.Add(intTest);
int expectedTeacherListLength = 1;
Assert.IsTrue(testLogic.Length() == expectedTeacherListLength);
}
public void GetNextTeachertId()
{
SetUp();
TeacherLogic logic = new TeacherLogic();
int expectedValue = 0;
Teacher newTeacher = TeacherTest();
newTeacher.Id = 1;
logic.Add(newTeacher);
int obtainedValue = logic.GetNextIdFree();
Assert.IsFalse(obtainedValue.Equals(expectedValue));
}
public void ModifyTeacherSuccess()
{
SetUp();
TeacherLogic testLogic = new TeacherLogic();
Teacher newTeacher = TeacherTest();
Teacher anotherTeacher = TeacherTest();
anotherTeacher.Id = 99;
testLogic.Add(newTeacher);
newTeacher.Id = testLogic.GetNextIdFree() - 1;
anotherTeacher.Id = testLogic.GetNextIdFree() - 1;
testLogic.Modify(newTeacher, anotherTeacher);
Assert.IsTrue(testLogic.Exists(newTeacher));
}
public void AddTeacherLengthSuccess()
{
SetUp();
TeacherLogic testLogic = new TeacherLogic();
Teacher newTeacher = TeacherTest();
Teacher anotherTeacher = TeacherTest();
anotherTeacher.Id = 2;
testLogic.Add(newTeacher);
testLogic.Add(newTeacher);;
testLogic.Add(anotherTeacher);
int expectedTeacherListLength = 3;
Assert.IsTrue(testLogic.Length() == expectedTeacherListLength);
}
public void AddNewTeacher(string name, string lastName, List <Object> subjects)
{
TeacherLogic logic = new TeacherLogic();
Teacher newTeacher = new Teacher();
newTeacher.Id = logic.GetNextIdFree();
newTeacher.Subjects = new List <Subject>();
newTeacher.Name = name;
newTeacher.LastName = lastName;
foreach (Object item in subjects)
{
newTeacher.Subjects.Add((Subject)item);
}
logic.Add(newTeacher);
}
public void LoadAllTeacher(ListBox list)
{
TeacherLogic logic = new TeacherLogic();
List <Teacher> allObjects = new List <Teacher>();
allObjects = logic.GetAllTeachers();
if (allObjects.Count == 0)
{
throw new NoTeachersInSystemException("No hay profesores ingresados en el sistema");
}
foreach (Teacher item in allObjects)
{
list.Items.Add(item);
}
}
protected void Grid_ItemCommand(object sender, DataGridCommandEventArgs e)
{
if ("Edit".Equals(e.CommandName))
{
int primaryKey = (int)this.Grid.DataKeys[e.Item.ItemIndex];
this.OnEdit(TeacherLogic.GetByID(this.DataContext, primaryKey));
}
else if ("Delete".Equals(e.CommandName))
{
int primaryKey = (int)this.Grid.DataKeys[e.Item.ItemIndex];
this.OnDelete(TeacherLogic.GetByID(this.DataContext, primaryKey));
}
}
public void ModifyTeacher(object selectedObject, string name, string lastName, List <Object> subjects)
{
TeacherLogic logic = new TeacherLogic();
Teacher newTeacher = new Teacher();
Teacher oldTeacher = (Teacher)selectedObject;
newTeacher.Id = oldTeacher.Id;
newTeacher.Subjects = new List <Subject>();
newTeacher.Name = name;
newTeacher.LastName = lastName;
foreach (Object item in subjects)
{
newTeacher.Subjects.Add((Subject)item);
}
logic.Modify(selectedObject, newTeacher);
}
static double ReadTeachers()
{
var teacher = new Teacher
{
PassportNumber = null
};
var startTime = DateTime.Now;
var teachers = TeacherLogic.Read(teacher);
var finishTime = DateTime.Now;
foreach (var t in teachers)
{
Console.WriteLine($"{t.FirstName} {t.MiddleName} {t.LastName}");
}
Console.WriteLine("---Скрипт ReadTeachers выполнен");
return((finishTime - startTime).TotalMilliseconds);
}
protected override void OnLoad(EventArgs e)
{
base.OnLoad(e);
string idString = this.Request.QueryString["ID"];
int id;
if (int.TryParse(idString, out id))
{
this.Teacher = TeacherLogic.GetByID(this.DataContext, id);
if (!this.IsPostBack)
{
this.EditControl.DataBind(this.Teacher);
}
}
}
public void ModifyTeacherWithTheSameId()
{
SetUp();
TeacherLogic testLogic = new TeacherLogic();
Teacher newTeacher = TeacherTest();
Teacher anotherTeacher = TeacherTest();
anotherTeacher.Name = "new Name";
testLogic.Add(newTeacher);
testLogic.Add(anotherTeacher);
testLogic.Modify(newTeacher, anotherTeacher);
List <Teacher> list = testLogic.GetAllTeachers();
bool assertion = false;
if (list.Count != 0)
{
Teacher testTeacher = list.ElementAt(0);
assertion = testTeacher.Name.Equals("new Name");
}
Assert.IsTrue(assertion);
}
public void ModifyTeacherCheckUpdateSuccess()
{
SetUp();
TeacherLogic testLogic = new TeacherLogic();
Teacher newTeacher = TeacherTest();
Teacher anotherTeacher = TeacherTest();
int differentId = 99;
anotherTeacher.Id = differentId;
testLogic.Add(newTeacher);
anotherTeacher.Id = testLogic.GetNextIdFree() - 1;
testLogic.Modify(newTeacher, anotherTeacher);
List <Teacher> list = testLogic.GetAllTeachers();
bool validation = false;
if (list.Count != 0)
{
validation = (list.ElementAt(0).LastName == anotherTeacher.LastName);
}
Assert.IsTrue(validation);
}
protected void SaveButton_Click(object sender, EventArgs e)
{
if (this.ObjectID.HasValue)
{
Teacher obj = TeacherLogic.GetByID(this.DataContext, this.ObjectID.Value);
obj.SSN = this.SSNField.Text;
obj.FirstName = this.FirstNameField.Text;
obj.LastName = this.LastNameField.Text;
obj.Active = this.ActiveField.Checked;
this.DataContext.AcceptAllChanges();
OnSaved(obj);
}
else
{
Teacher obj = TeacherLogic.CreateTeacher(this.DataContext, this.SSNField.Text, this.FirstNameField.Text, this.LastNameField.Text, this.ActiveField.Checked);
this.DataContext.AcceptAllChanges();
OnSaved(obj);
}
}
