public DataTable Discipline_Save(string pWorkingTag, DisciplineEntity _entity, string pLoginId)
{
DataTable dtData = new DataTable();
string spName = "PKHR_HRINFO.sp_Discipline_Save";
OracleParameter[] param = new OracleParameter[12];
param[0] = new OracleParameter("pWorkingTag", pWorkingTag);
param[1] = new OracleParameter("pEmpId", _entity.EMPID);
param[2] = new OracleParameter("pSerialNo", _entity.DSERIAL);
param[3] = new OracleParameter("pDisciplineKind", _entity.DISCIPLINEKIND ?? "");
param[4] = new OracleParameter("pDISCIPLINECLSS", _entity.DISCIPLINECLSS ?? "");
param[5] = new OracleParameter("pReasonKind", _entity.REASONKIND ?? "");
param[6] = new OracleParameter("pFromDate", _entity.FROMDATE ?? "");
param[7] = new OracleParameter("pToDate", _entity.UNTILDATE ?? "");
param[8] = new OracleParameter("pMonthCount", _entity.MONTHSCOUNT);
param[9] = new OracleParameter("pRemark", OracleDbType.NVarchar2)
{
Value = _entity.REMARKS ?? ""
};
param[10] = new OracleParameter("pLoginID", pLoginId ?? "");
param[11] = new OracleParameter("T_TABLE", OracleDbType.RefCursor)
{
Direction = ParameterDirection.Output
};
dtData = DBHelper.getDataTable_SP(spName, param);
return(dtData);
}
private void Init([NotNull] DisciplineEntity discipline)
{
_isCreationMode = discipline.Id == default;
_detachedEntity = _isCreationMode ? discipline : discipline.Clone();
this.DisciplineName = _detachedEntity.Name;
this.DisciplineDescription = _detachedEntity.Description;
}
public IActionResult Create(DisciplineCreateView view)
{
using (var client = new ApplicationDbContext())
{
client.DisciplineEntities.Add(DisciplineEntity.Factory(view));
client.SaveChanges();
return(View());
}
}
public IActionResult Detail(Guid?id)
{
using (var client = new DisciplineRepository())
{
DisciplineEntity entity = client.FindById(id);
if (entity == null)
{
return(View("NotFoundPageView", new NotFoundPageView
{
Action = "Detail",
Controller = "Discipline",
Title = "Выберите одну из дисциплин",
Message = "Не удалось найти выбранную дисциплину",
EntitySelectList = new SelectList(client.TakeAll(), "DisciplineId", "DisciplineName"),
ReturnUrl = "Question/Index"
}));
}
return(View(entity.AsDetailView()));
}
}
public IQueryable <StudentLessonEntity> GetAdditionalLessonsByDiscipline([NotNull] StudentEntity student, [NotNull] DisciplineEntity discipline)
{
if (student.Id == default)
{
return(new List <StudentLessonEntity>().AsQueryable());
}
var studentGroupsIds = student.Groups?.Select(group => group.Id).ToList() ?? new List <long>();
return(StudentLessons
.Where(studentLesson => studentLesson.Student.Id == student.Id)
.Where(studentLesson => studentLesson.Lesson.Stream.Discipline.Id == discipline.Id)
.Where(studentLesson => studentLesson.Lesson._GroupId != default
? studentGroupsIds.All(studentGroupId => studentGroupId != studentLesson.Lesson.Group.Id)
: studentLesson.Lesson.Stream.Groups.All(
group => studentGroupsIds.All(studentGroupId => studentGroupId != group.Id)
)));
}
public DisciplineFormToken(string title, DisciplineEntity discipline = null) : base(title)
{
this.Discipline = discipline ?? new DisciplineEntity();
}
