private void subject_data_grid_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
updateMode = true;
delete_btn_.IsEnabled = true;
DataGrid dataGrid = (DataGrid)sender;
subject = dataGrid.SelectedItem as SubjectEntity;
if (subject != null)
{
name_txtbx.Text = subject.SubjectName;
code_txtbx.Text = subject.SubjectCode;
year_combobx.Text = subject.Year.ToString();
sem_combobx.Text = subject.Semester.ToString();
lec_combobx.Text = subject.NoOfLecHrs.ToString();
tutorial_combobx.Text = subject.NoOfTuteHrs.ToString();
lab_combobx.Text = subject.NoOfLabHrs.ToString();
eval_combobx.Text = subject.NoOfEvalHrs.ToString();
lec_combobx_val = subject.NoOfLecHrs.ToString();
tute_combobx_val = subject.NoOfTuteHrs.ToString();
lab_combobx_val = subject.NoOfLabHrs.ToString();
eval_combobx_val = subject.NoOfEvalHrs.ToString();
year_combobx_val = subject.Year.ToString();
sem_combobx_val = subject.Semester.ToString();
}
}
private void OpenForm(SubjectEntity subject)
{
EditSubject form = new EditSubject(subject);
form.Show();
Close();
}
public void Add_new_subject_test()
{
var repo = new SubjectRepository(this.context);
var model = new SubjectEntity("AM", "Analiza matematyczna");
repo.AddNew(model);
}
private Subject SaveSubject(Subject subject, ScheduleContext context) //+
{
SubjectEntity subjectEntity;
var workWeek = GetWorkWeekByIdInner(subject.WorkWeek.Id, context);
if (workWeek == null)
{
throw new ArgumentOutOfRangeException(nameof(workWeek));
}
if (subject.Id != Guid.Empty)
{
subjectEntity = context.Subjects.First(x => x.Id == subject.Id).MapToEntity(subject, workWeek);
}
else
{
subjectEntity = new SubjectEntity().MapToEntity(subject, workWeek);
subjectEntity.Id = Guid.NewGuid();
context.Subjects.Add(subjectEntity);
}
var model = subjectEntity.MapToModel(workWeek.MapToModel());
return(model);
}
private SubjectEntity CreateSubjectEntity()
{
int SubjectId;
if (subjects.Count == 0)
{
SubjectId = 1;
}
else if (updateMode)
{
SubjectId = subject.SubjectId;
}
else
{
SubjectId = subjects.Last().SubjectId + 1;
}
subject = new SubjectEntity {
SubjectId = SubjectId,
SubjectCode = code_txtbx.Text,
SubjectName = name_txtbx.Text,
Year = int.Parse(year_combobx.Text),
Semester = int.Parse(sem_combobx.Text),
NoOfLecHrs = int.Parse(lec_combobx.Text),
NoOfTuteHrs = int.Parse(tutorial_combobx.Text),
NoOfLabHrs = int.Parse(lab_combobx.Text),
NoOfEvalHrs = int.Parse(eval_combobx.Text)
};
return(subject);
}
public async Task <T> UpdateAsync(T entity)
{
SubjectEntity subject = this.ForwardConverter(entity);
SubjectEntity updatedEntity = await this._repository.UpdateAsync(subject).ConfigureAwait(false);
return(this.BackwardConverter(updatedEntity));
}
/// <summary>
/// Actualiza una entidad asignatura
/// </summary>
/// <param name="subjectEntity">
/// </param>
/// <exception cref="SubjectNameDuplicateEntryException">
/// Lanza SubjectNameDuplicateEntryException si el nombre de la
/// asignatura ya existe
/// </exception>
/// <returns>
/// Retorna la entidad asignatura actualizada
/// </returns>
public async Task <SubjectEntity> Update(SubjectEntity subjectEntity)
{
//Recupera la asignatura a modificar
SubjectEntity entityToUpdate = await this.Get(subjectEntity.Id);
entityToUpdate.Name = subjectEntity.Name;
try
{
await _dbContext.SaveChangesAsync();
_logger.LogInformation("Asignatura actualizada correctamente");
}
catch (DbUpdateException ex)
{
if (ex.InnerException.Message.Contains("UQ_subject_name"))
{
_logger.LogWarning("La asignatura no se ha actualizado " +
"porque su nombre ya existe");
throw new SubjectNameDuplicateEntryException();
}
//Cualquier otra razón, lanzo la excepción
else
{
throw ex;
}
}
return(entityToUpdate);
}
/// <summary>
/// Updates a subject.
/// </summary>
/// <param name="itemToSave">The item to save.</param>
/// <param name="accountId">The account identifier.</param>
/// <returns>The result.</returns>
public ResultDto UpdateSubject(SubjectEditDto itemToSave, Guid?accountId)
{
ResultDto result = new ResultDto();
using (BzsEntityContainer ctx = this.CreateContainer())
{
SubjectEntity entity = ctx.SubjectSet.FirstOrDefault(f => f.Id == itemToSave.Id);
if (entity == null)
{
result.Error = "ERR-SUBJECT-NOT-EXISTS";
return(result);
}
if (entity.AccountId == null || entity.AccountId != accountId)
{
result.Error = "ERR-SUBJECT-ACCOUNT-INVALID";
return(result);
}
entity.Code = itemToSave.Code.Length > 10 ? itemToSave.Code.Substring(0, 9) : itemToSave.Code;
entity.Caption = itemToSave.Caption.Length > 50 ? itemToSave.Caption.Substring(0, 49) : itemToSave.Caption;
entity.ModDate = DateTime.Now;
entity.ModUser = Environment.UserName;
ctx.SaveChanges();
result.Success = true;
}
return(result);
}
public void Get_timetable_by_id_test()
{
var repo = new TimeTableRepository(context);
var classRepo = new ClassRepository(context);
var subjectRepo = new SubjectRepository(context);
ClassEntity clazz = new ClassEntity("GR1");
classRepo.AddNew(clazz);
SubjectEntity subject = new SubjectEntity("AM", "Analiza");
subjectRepo.AddNew(subject);
TimeTableEntity model = new TimeTableEntity("poniedziałek", clazz, subject);
TimeTableEntity model2 = new TimeTableEntity("wtorek", clazz, subject);
repo.AddNew(model);
repo.AddNew(model2);
var result = repo.GetById(2);
Assert.IsNotNull(result);
Assert.AreEqual(2, result.Id);
Assert.AreEqual(model2.Class.Id, result.Class.Id);
Assert.AreEqual(model2.Subject.Id, result.Subject.Id);
Assert.AreEqual(model2.Day, result.Day);
}
public void Get_presences_by_student_and_subject_test()
{
var repo = new PresenceRepository(this.context);
var studrepo = new StudentRepository(this.context);
var timerepo = new TimeTableRepository(this.context);
var classrepo = new ClassRepository(this.context);
var subrepo = new SubjectRepository(this.context);
ClassEntity clazz = new ClassEntity("GR1");
classrepo.AddNew(clazz);
StudentEntity model = new StudentEntity("Aneta", "Dams", clazz, true);
studrepo.AddNew(model);
SubjectEntity subject = new SubjectEntity("AM", "Analiza Matematyczna");
subrepo.AddNew(subject);
TimeTableEntity timeTable = new TimeTableEntity("poniedziałek", clazz, subject);
var model1 = new PresenceEntity(model, subject, DateTime.Now.Date, true);
var model2 = new PresenceEntity(model, subject, DateTime.Now.Date.AddDays(2), true);
repo.AddNew(model1);
repo.AddNew(model2);
var result = repo.GetAllByStudentAndSubject(model.Id, subject.Id);
Assert.IsNotNull(result);
Assert.AreEqual(2, result.Count);
Assert.AreEqual(model1.Id, result[0].Id);
Assert.AreEqual(model2.Id, result[1].Id);
}
public static async Task <RoleEntity> GivenARole(
this TestServerFixture fixture,
string name,
ApplicationEntity application,
SubjectEntity subject,
bool withPermissions = true)
{
var role = new RoleEntity(name, application.Id, $"{name} role");
await fixture.ExecuteDbContextAsync(async db =>
{
role.Subjects.Add(new RoleSubjectEntity {
SubjectId = subject.Id
});
if (withPermissions)
{
foreach (var permission in application.Permissions)
{
role.Permissions.Add(new RolePermissionEntity {
PermissionId = permission.Id
});
}
}
db.Add(role);
await db.SaveChangesAsync();
});
return(role);
}
public static async Task Seed(BaleaDbContext db)
{
if (!db.Roles.Any())
{
var john = new SubjectEntity("Alice", "1");
var mary = new SubjectEntity("Bob", "11");
db.Add(john);
db.Add(mary);
await db.SaveChangesAsync();
var application = new ApplicationEntity(BaleaConstants.DefaultApplicationName, "Default application");
var viewGradesPermission = new PermissionEntity(Policies.GradesView);
var editGradesPermission = new PermissionEntity(Policies.GradesEdit);
application.Permissions.Add(viewGradesPermission);
application.Permissions.Add(editGradesPermission);
var teacherRole = new RoleEntity("Teacher", "Teacher role");
teacherRole.Subjects.Add(new RoleSubjectEntity {
SubjectId = john.Id
});
teacherRole.Permissions.Add(new RolePermissionEntity {
Permission = viewGradesPermission
});
teacherRole.Permissions.Add(new RolePermissionEntity {
Permission = editGradesPermission
});
application.Roles.Add(teacherRole);
application.Delegations.Add(new DelegationEntity(john.Id, mary.Id, DateTime.UtcNow.AddDays(-1), DateTime.UtcNow.AddDays(1), true));
db.Applications.Add(application);
await db.SaveChangesAsync();
}
}
public JsonResult GetSubjectByItemId(string schollid, string itemid)
{
var result = new ReturnMessage(false)
{
Message = "加载失败!"
};
try
{
var data = new SubjectEntity();
var list = SubjectBLL.Instance.GetList(new SubjectEntity()
{
SchoolId = schollid, ItemId = itemid
});
if (list != null && list.Count() > 0)
{
data = list.FirstOrDefault();
}
result.IsSuccess = true;
result.Message = "获取成功!";
result.ResultData["Data"] = data;
}
catch (Exception ex)
{
ex.Data["Method"] = "ApplyController>>GetSubject";
new ExceptionHelper().LogException(ex);
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
List <VerticeEntity> DsMonThi()
{
List <VerticeEntity> ListVertice = new List <VerticeEntity>();
foreach (DataGridViewRow r in grwDanhSach.Rows)
{
if (Convert.ToString(r.Cells["NHÓM"].Value) != "")
{
SubjectEntity mt = new SubjectEntity(Convert.ToString(r.Cells["MÃ HP"].Value));
string phong1 = Convert.ToString(((DataGridViewTextBoxCell)r.Cells["PHÒNG"]).Value);
string nhom1 = Convert.ToString(r.Cells["NHÓM"].Value);
foreach (DataGridViewRow r2 in grwDanhSach.Rows)
{
if (r2.Index != r.Index)
{
string nhom2 = Convert.ToString(r2.Cells["NHÓM"].Value);
string phong2 = Convert.ToString(((DataGridViewTextBoxCell)r2.Cells["PHÒNG"]).Value);
if (DuLieu.CheckContain(nhom1, nhom2) || DuLieu.CheckContain(phong1, phong2))
{
mt.AddSubjectRelated(Convert.ToString(r2.Cells[1].Value));
}
}
}
ListVertice.Add(mt);
}
}
return(ListVertice);
}
/// <summary>
/// Retira la asignacion de profesor a una asignatura
/// </summary>
/// <param name="subjectId">
/// El id de la asignatura
/// </param>
/// <returns>
/// Retorna true
/// </returns>
public async Task <bool> RemoveAssignedTeacher(int subjectId)
{
SubjectEntity subjectEntity = await _subjectRepository
.UpdateAssignedTeacher(subjectId, null);
return(true);
}
private SubjectEntity MapOneSubject(SubjectModel subjectModel)
{
string subjectJson = TimetableSerializer.SerializeToJson(subjectModel);
string subjectHash = HashCoder.GetSha256Hash(subjectJson);
var info = new SubjectInfoEntity
{
Title = subjectModel.Title,
Teachers = subjectModel.Teachers,
LectureStartDate = subjectModel.LectureStartDate,
LectureEndDate = subjectModel.LectureEndDate,
PracticeStartDate = subjectModel.PracticeStartDate,
PracticeEndDate = subjectModel.PracticeEndDate
};
string infoJson = TimetableSerializer.SerializeToJson(info);
string infoHash = HashCoder.GetSha256Hash(infoJson);
info.Hash = infoHash;
string daysJson = TimetableSerializer.SerializeToJson(subjectModel.Days);
string daysHash = HashCoder.GetSha256Hash(daysJson);
SubjectEntity entity = new SubjectEntity
{
Info = info,
Days = MapSchoolDays(subjectModel.Days),
HashDays = daysHash,
Hash = subjectHash
};
return(entity);
}
/// <summary>
/// Inserta una nueva entidad asignatura
/// </summary>
/// <param name="subjectEntity">
/// La entidad asignatura a guardar
/// </param>
/// <exception cref="SubjectNameDuplicateEntryException">
/// Lanza SubjectNameDuplicateEntryException si el nombre de la
/// asignatura ya existe
/// </exception>
/// <returns>
/// Retorna la entidad asignatura guardada
/// con el id generado
/// </returns>
public async Task <SubjectEntity> Save(SubjectEntity subjectEntity)
{
try
{
await _dbContext.SubjectEntities.AddAsync(subjectEntity);
await _dbContext.SaveChangesAsync();
_logger.LogInformation("Asignatura guardada correctamente");
}
catch (DbUpdateException ex)
{
if (ex.InnerException.Message.Contains("UQ_subject_name"))
{
_logger.LogWarning("La asignatura no se ha guardado porque " +
"su nombre ya existe");
throw new SubjectNameDuplicateEntryException();
}
//Cualquier otra razón, lanzo la excepción
else
{
throw ex;
}
}
return(subjectEntity);
}
private T BackwardConverter(SubjectEntity entity)
{
T createdEntity = this._factory.GetSubjectModel() as T;
createdEntity.Id = entity.Id;
createdEntity.Name = entity.Name;
return(createdEntity);
}
private Subject ConvertToModel(SubjectEntity subjectEntity)
{
var subject = new Subject(subjectEntity.Name, subjectEntity.Credit);
subject.Load(subjectEntity.Id, subjectEntity.IsRegistered, subjectEntity.IsCompleted, subjectEntity.ActualRegisteredSubjectId);
return(subject);
}
private SubjectEntity ForwardConverter(T entity)
{
SubjectEntity createdEntity = this._factory.GetSubjectEntity();
createdEntity.Id = entity.Id;
createdEntity.Name = entity.Name;
return(createdEntity);
}
public bool IsSubjectApproved(int subjectId)
{
SubjectEntity subject = Context.Subjects
.AsNoTracking()
.SingleOrDefault(s => s.Id == subjectId);
return(subject.IsApproved);
}
public void DeleteSubjectEntity(SubjectEntity subjectEntityToDelete)
{
using (var db = new PlutoContext())
{
db.Entry(subjectEntityToDelete).State = EntityState.Deleted;
db.SaveChanges();
}
}
public void UpdateSubjectEntity(SubjectEntity subjectEntityToUpdate)
{
using (var db = new PlutoContext())
{
db.Entry(subjectEntityToUpdate).State = EntityState.Modified;
db.SaveChanges();
}
}
public static async Task Seed(BaleaDbContext db)
{
if (!db.Roles.Any())
{
var alice = new SubjectEntity("Alice", "818727");
var bob = new SubjectEntity("Bob", "88421113");
db.Add(alice);
db.Add(bob);
await db.SaveChangesAsync();
var application = new ApplicationEntity(BaleaConstants.DefaultApplicationName, "Default application");
var viewGradesPermission = new PermissionEntity(Permissions.GradesRead);
var editGradesPermission = new PermissionEntity(Permissions.GradesEdit);
application.Permissions.Add(viewGradesPermission);
application.Permissions.Add(editGradesPermission);
var teacherRole = new RoleEntity(nameof(Roles.Teacher), "Teacher role");
teacherRole.Subjects.Add(new RoleSubjectEntity {
SubjectId = alice.Id
});
teacherRole.Permissions.Add(new RolePermissionEntity {
Permission = viewGradesPermission
});
teacherRole.Permissions.Add(new RolePermissionEntity {
Permission = editGradesPermission
});
application.Roles.Add(teacherRole);
var substituteRole = new RoleEntity(nameof(Roles.Substitute), "Substitute role");
substituteRole.Permissions.Add(new RolePermissionEntity {
Permission = viewGradesPermission
});
substituteRole.Permissions.Add(new RolePermissionEntity {
Permission = editGradesPermission
});
substituteRole.Subjects.Add(new RoleSubjectEntity {
SubjectId = bob.Id
});
application.Roles.Add(substituteRole);
application.Delegations.Add(new DelegationEntity(alice.Id, bob.Id, DateTime.UtcNow.AddDays(-1), DateTime.UtcNow.AddYears(1), false));
var studentRole = new RoleEntity(nameof(Roles.Student), "Student role");
var mapping = new MappingEntity("customer");
studentRole.Mappings.Add(new RoleMappingEntity {
Mapping = mapping
});
application.Roles.Add(studentRole);
var policy = new PolicyEntity("ValidateGrades",
@"policy substitute begin
rule A (DENY) begin
Subject.Role CONTAINS ""Substitute"" AND Resource.Controller = ""Grades"" AND Parameters.Value > 6
end
end");
application.Policies.Add(policy);
db.Applications.Add(application);
await db.SaveChangesAsync();
}
}
/// <summary>
/// Actualiza una asignatura
/// </summary>
/// <param name="subject">
/// Un objeto Subject que contiene los nuevos datos de la asignatura
/// </param>
/// <exception cref="SubjectNameDuplicateEntryException">
/// Lanza SubjectNameDuplicateEntryException
/// </exception>
/// <returns>
/// El objeto Subject actualizado
/// </returns>
public async Task <Subject> Update(Subject subject)
{
SubjectEntity subjectEntity = SubjectMapper.Map(subject);
subjectEntity = await _subjectRepository.Update(subjectEntity);
subject = SubjectMapper.Map(subjectEntity);
return(subject);
}
public int AddSubjectEntity(SubjectEntity subjectEntity)
{
using (var db = new PlutoContext())
{
db.Subjects.Add(subjectEntity);
db.SaveChanges();
}
return(subjectEntity.Id);
}
/// <summary>
/// Crea una nueva asignatura
/// </summary>
/// <param name="subject">
/// Un objeto Subject que contiene los datos de la asignatura
/// </param>
/// <exception cref="SubjectNameDuplicateEntryException">
/// Lanza SubjectNameDuplicateEntryException
/// </exception>
/// <returns>
/// El objeto Subject creado con el id generado
/// </returns>
public async Task <Subject> Save(Subject subject)//throw SubjectNameDuplicateEntryException
{
SubjectEntity subjectEntity = SubjectMapper.Map(subject);
subjectEntity = await _subjectRepository.Save(subjectEntity);
subject = SubjectMapper.Map(subjectEntity);
return(subject);
}
public ActionResult Subject()
{
UserEntity objUserEntity = UserEntity.GetInstance();
SubjectEntity subjectEntity = new SubjectEntity();
subjectEntity.flag = 'G';
subjectEntity.reportId = "5";
TempData["SubjectData"] = new Master().AddSubject(subjectEntity);
return(PartialView());
}
public ActionResult Edit(SubjectEntity subject)
{
if (!ModelState.IsValid)
{
return(Edit(subject.Id));
}
_dbContext.Entry(subject).State = EntityState.Modified;
_dbContext.SaveChanges();
return(RedirectToAction("Index"));
}
public async Task Initialize()
{
_context.Database.EnsureCreated();
// Look for any students.
if (_context.Subjects.Any())
{
return; // DB has been seeded
}
var students = new StudentEntity[]
{
new StudentEntity {
Forename = "Petru", Surname = "Ritivoiu"
},
new StudentEntity {
Forename = "Horia", Surname = "Popescu"
}
};
var subjects = new SubjectEntity[]
{
new SubjectEntity {
Name = "PAW"
},
};
var homeworkDescriptions = new HomeworkDescriptionEntity[]
{
new HomeworkDescriptionEntity {
Subject = subjects[0], Name = "Proiect PAW 2018", ShortDescription = "Proiect PAW 2018",
FullDescription = "Cerinta proiectului poate fi gasita la adresa http://acs.ase.ro/paw",
ReflectionFile = "MockReflectionFile.xml",
UnitTestsFile = "MockUnitTestingFile.cs"
}
};
var studentSubjectRelationship = new StudentSubjectRelationship[]
{
new StudentSubjectRelationship {
Student = students[0], Subject = subjects[0]
},
new StudentSubjectRelationship {
Student = students[1], Subject = subjects[0]
}
};
_context.Students.AddRange(students);
_context.Subjects.AddRange(subjects);
_context.HomeworkDescriptions.AddRange(homeworkDescriptions);
_context.StudentSubjects.AddRange(studentSubjectRelationship);
await _context.SaveChangesAsync();
}
