//=======================================================================================
public IActionResult Index()
{
using (var client = new DisciplineRepository())
{
return(View(client.TakeAllView()));
}
}
public HrUnitOfWork(IContextFactory <DbContext> contextFactory) // , int companyId, string culture
: base(contextFactory)
{
// Initialize
CompanyRepository = new CompanyRepository(Context); // , companyId, culture
PagesRepository = new PagesRepository(Context);
MenuRepository = new MenuRepository(Context);
PageEditorRepository = new PageEditorRepository(Context);
LookUpRepository = new LookUpRepoitory(Context);
CompanyStructureRepository = new CompanyStructureRepository(Context);
JobRepository = new JobRepository(Context);
PeopleRepository = new PeopleRepository(Context);
PositionRepository = new PositionRepository(Context);
BudgetRepository = new BudgetRepository(Context);
QualificationRepository = new QualificationRepository(Context);
LeaveRepository = new LeaveRepository(Context);
EmployeeRepository = new EmployeeRepository(Context);
CustodyRepository = new CustodyRepository(Context);
TrainingRepository = new TrainingRepository(Context);
BenefitsRepository = new BenefitsRepository(Context);
AudiTrialRepository = new AudiTrialRepository(Context);
TerminationRepository = new TerminationRepository(Context);
DisciplineRepository = new DisciplineRepository(Context);
CheckListRepository = new CheckListRepository(Context);
ComplaintRepository = new ComplaintRepository(Context);
MessageRepository = new MessageRepository(Context);
MedicalRepository = new MedicalRepository(Context);
HrLettersRepository = new HRLettersRepository(Context);
PayrollRepository = new PayrollRepository(Context);
SalaryDesignRepository = new SalaryDesignRepository(Context);
NotificationRepository = new NotificationRepository(Context);
MissionRepository = new MissionRepository(Context);
MeetingRepository = new MeetingRepository(Context);
}
public JsonResult Discipline(int?draw, int?start, int?length, List <Dictionary <string, string> > order, List <Dictionary <string, string> > columns)
{
var search = Request["search[value]"];
var dir = order[0]["dir"].ToLower();
var column = columns[int.Parse(order[0]["column"])]["data"];
var dataTableData = new DisciplineRepository().GetPage(search, draw, start, length, dir, column);
return(Json(dataTableData, JsonRequestBehavior.AllowGet));
}
public ActionResult DisciplineDetail(int?id)
{
DisciplineViewModel model = new DisciplineViewModel();
if (id.HasValue)
{
model = new DisciplineRepository().GetByID((int)id);
}
return(PartialView("_Discipline", model));
}
public void TestGetAll()
{
var repo = new DisciplineRepository();
var d = repo.GetAll();
Assert.IsTrue(d.Count > 0);
var x = repo.GetFromTop(1);
Assert.IsTrue(x.Count > 0);
}
public UnitOfWork(ScheduleContext context)
{
this.context = context;
Disciplines = new DisciplineRepository(context); //new Repository<Discipline>(context);
Groups = new Repository <Group>(context);
Teachers = new Repository <Teacher>(context);
Rooms = new Repository <Room>(context);
Schedules = new ScheduleRepository(context); // new Repository<Schedule>(context);
ScheduleEntries = new Repository <ScheduleEntry>(context);
TeacherDisciplines = new Repository <TeacherDiscipline>(context);
}
private void getData()
{
var repository = new DisciplineRepository(); //po odkomentowaniu nastepnej linijki sie wysypuje
var disciplines = repository.GetAll();
foreach (Discipline discipline in disciplines)
{
DisciplineItem tmp = new DisciplineItem(discipline);
tmp.MouseUp += new MouseEventHandler(Discipline_Click);
this.disciplinesPanel.Controls.Add(tmp);
}
}
public void Init()
{
conection = new MSSQLDB(new DBConfiguration());
_DREP = new DisciplineRepository(conection);
_PREPProfessorContext = new Infra.ProfessorContext.ProfessorRepository(conection);
_PREPCourseContext = new Infra.CourseContext.ProfessorRepository(conection);
_encryptor = new Encryptor();
handler = new DisciplineCommandHandler(_DREP, _PREPCourseContext);
var db = conection.GetCon();
var cpf = "357.034.413-40";
string password = cpf.Replace("-", "").Replace(".", "");
password = _encryptor.Encrypt(password, out string salt);
professor = new Entities.ProfessorContext.Entities.Professor("Lívia", "Emanuelly Elisa", cpf, "*****@*****.**", "(21) 2682-8370", EDegree.Master, password, salt);
_PREPProfessorContext.Create(professor);
// Create Course
course = new Course(Guid.NewGuid());
var sql = "INSERT INTO [Course] ([Id], [Name]) VALUES (@Id, 'LTP6')";
db.Execute(sql, param: new { Id = course.Id });
commandRegister = new DisciplineInputRegister()
{
Name = "Filosofia",
CourseId = course.Id,
ProfessorId = professor.Id,
WeeklyWorkload = 1,
Period = 1
};
discipline = new Discipline("Filosofia", course, new Professor(professor.Id), 1, 1, 0);
_DREP.Create(discipline);
commandUpdate = new DisciplineInputUpdate()
{
DisciplineId = discipline.Id,
Name = "Matematica",
CourseId = course.Id,
ProfessorId = professor.Id,
WeeklyWorkload = 2,
Period = 2
};
commandDelete = new DisciplineInputDelete()
{
DisciplineId = discipline.Id
};
}
public IEnumerable <League> GetLeaguesByDiscipline(int id)
{
DisciplineRepository _rep = new DisciplineRepository();
Discipline _discipline = _rep.GetById(id);
if (_discipline != null)
{
var qresult = _repository.GetByDiscipline(_discipline);
return(qresult.Select(o => new APILeague(o)).ToList());
}
return(null);
}
public JsonResult SaveDiscipline(DisciplineViewModel model)
{
ResponseData result = new ResponseData();
if (model.DisID != 0)
{
result = new DisciplineRepository().UpdateByEntity(model);
}
else
{
result = new DisciplineRepository().AddByEntity(model);
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public void TestDbAccess()
{
using (var session = HibernateConfiguration.GetSession())
{
var d = new Discipline();
var repo = new DisciplineRepository();
d.Name = "Football";
if (!repo.ContainsName(d.Name))
{
repo.SaveOrUpdate(d);
}
var result = repo.GetAll();
Assert.IsTrue(result.Count > 0);
}
}
public void SetUp()
{
_transactionScope = new TransactionScope();
_disciplineRepository = new DisciplineRepository();
_discipline = new DisciplineItem()
{
Id = 1,
FullName = "full_name",
ShortName = "short_name",
Mem = "Описание"
};
_disciplineNew = new DisciplineItem()
{
Id = 2,
FullName = "full_name_test",
ShortName = "short_name_test",
Mem = "Описание2"
};
}
private void saveButton_Click(object sender, EventArgs e)
{
if (validate())
{
discipline.Description = descriptionInput.Text;
discipline.Name = nameInput.Text;
var repo = new DisciplineRepository();
repo.SaveOrUpdate(discipline);
DialogResult result = MetroMessageBox.Show(this, "Discipline updated!", "Success!", MessageBoxButtons.OK,
MessageBoxIcon.Information);
if (result == DialogResult.OK)
{
VisualStyleElement.ToolTip.Close();
}
}
else
{
MetroMessageBox.Show(this, "Sorry, data is not valid.", "Validation error", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
private void removeMenuItem_Click(object sender, EventArgs e)
{
DialogResult result = MetroMessageBox.Show(this, "Are you sure you want to remove element?", "Remove", MessageBoxButtons.YesNo,
MessageBoxIcon.Error);
if (result == DialogResult.Yes)
{
var repo = new DisciplineRepository();
try
{
repo.Delete(handle);
disciplinesPanel.Controls.Remove(item);
}
catch (Exception)
{
MetroMessageBox.Show(this,
"We are sorry but you can't delete element which other elements depend on. Please remove all elements depending on this one and then try again.",
"Whoops!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
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 IActionResult Index()
{
using (var client = new ApplicationDbContext())
{
using (var disciplineRepository = new DisciplineRepository(client))
{
using (var threadRepository = new ThreadRepository(client))
{
using (var questionRepository = new QuestionRepository(client))
{
return(View(new RepositoryView
{
QuestionViews = questionRepository.TakeAllView(),
ThreadViews = threadRepository.TakeAllView(),
DisciplineViews = disciplineRepository.TakeAllView(),
/*TestViews = client.T.Take(10).ToList().Select(q => new QuestionView()).ToList(),*/
}));
}
}
}
}
}
private void saveButton_Click(object sender, EventArgs e)
{
if (validate())
{
discipline.Description = descriptionInput.Text;
discipline.Name = nameInput.Text;
var repo = new DisciplineRepository();
repo.SaveOrUpdate(discipline);
DialogResult result = MetroMessageBox.Show(this, "Discipline updated!", "Success!", MessageBoxButtons.OK,
MessageBoxIcon.Information);
if (result == DialogResult.OK)
{
VisualStyleElement.ToolTip.Close();
}
}
else
{
MetroMessageBox.Show(this, "Sorry, data is not valid.", "Validation error", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
private void saveButton_Click(object sender, EventArgs e)
{
if (validate())
{
Discipline newDiscipline = new Discipline();
newDiscipline.Description = descriptionInput.Text;
newDiscipline.Name = nameInput.Text;
newDiscipline.Teams = new List <Team>();
newDiscipline.Leagues = new List <League>();
var repo = new DisciplineRepository();
repo.SaveOrUpdate(newDiscipline);
DialogResult result = MetroMessageBox.Show(this, "Discipline created!", "Success!", MessageBoxButtons.OK,
MessageBoxIcon.Information);
if (result == DialogResult.OK)
{
}
}
else
{
MetroMessageBox.Show(this, "Sorry, data is not valid.", "Validation error", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
private void saveButton_Click(object sender, EventArgs e)
{
if (validate())
{
Discipline newDiscipline = new Discipline();
newDiscipline.Description = descriptionInput.Text;
newDiscipline.Name = nameInput.Text;
newDiscipline.Teams = new List<Team>();
newDiscipline.Leagues = new List<League>();
var repo = new DisciplineRepository();
repo.SaveOrUpdate(newDiscipline);
DialogResult result = MetroMessageBox.Show(this, "Discipline created!", "Success!", MessageBoxButtons.OK,
MessageBoxIcon.Information);
if (result == DialogResult.OK)
{
}
}
else
{
MetroMessageBox.Show(this, "Sorry, data is not valid.", "Validation error", MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
}
public void TestGetAll()
{
var repo = new DisciplineRepository();
var d = repo.GetAll();
Assert.IsTrue(d.Count > 0);
var x = repo.GetFromTop(1);
Assert.IsTrue(x.Count > 0);
}
public void TestDbAccess()
{
using (var session = HibernateConfiguration.GetSession())
{
var d = new Discipline();
var repo = new DisciplineRepository();
d.Name = "Football";
if(!repo.ContainsName(d.Name))
repo.SaveOrUpdate(d);
var result = repo.GetAll();
Assert.IsTrue(result.Count > 0);
}
}
public void Contains()
{
var repo = new DisciplineRepository();
Assert.IsFalse(repo.ContainsName("kappa"));
}
public void SelectDropdown()
{
Descipline obj = new Descipline();
DisciplineRepository _objNationality = new DisciplineRepository();
DataSet ds = _objNationality.Select_decipline("1");
List <Descipline> _Descipline = new List <Descipline>();
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
Descipline _objDescipline = new Descipline();
_objDescipline.Discipline_ID = (row["Discipline_ID"].ToString());
_objDescipline.Discipline = row["Discipline"].ToString();
_Descipline.Add(_objDescipline);
}
}
}
ProgramLevels objpro = new ProgramLevels();
ProgramLevelsRepository _objpro = new ProgramLevelsRepository();
DataSet ds1 = _objpro.Select_ProgramLevel("1");
List <ProgramLevels> _ProgramLevels = new List <ProgramLevels>();
if (ds1 != null)
{
if (ds1.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds1.Tables[0].Rows)
{
ProgramLevels _objProgramLevels = new ProgramLevels();
_objProgramLevels.ProgramLevel_Id = (row["ProgramLevel_Id"].ToString());
_objProgramLevels.ProgramLevel = row["ProgramLevel"].ToString();
_ProgramLevels.Add(_objProgramLevels);
}
}
}
CurrencyRepository _objRepo = new CurrencyRepository();
DataSet dsContry = _objRepo.select_Currency();
List <Currency> _ListCurrency = new List <Currency>();
if (dsContry != null)
{
if (dsContry.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in dsContry.Tables[0].Rows)
{
Currency _objcont = new Currency();
_objcont.Currency_Id = row["Currency_Id"].ToString();
_objcont.CurrencyCode = row["CurrencyCode"].ToString();
_objcont.CurrencyName = row["CurrencyName"].ToString();
_ListCurrency.Add(_objcont);
}
}
}
ViewBag.Currency = _ListCurrency;
ViewBag.Descipline = _Descipline;
ViewBag.ProgramLevels = _ProgramLevels;
}
public static IEnumerable <Discipline> Get(string calendarYear, IEnumerable <int> courseId, IEnumerable <string> coursePeriodId)
{
var repository = new DisciplineRepository();
return(repository.Get(calendarYear, courseId, coursePeriodId));
}
private void getData()
{
var repository = new DisciplineRepository(); //po odkomentowaniu nastepnej linijki sie wysypuje
var disciplines = repository.GetAll();
foreach (Discipline discipline in disciplines)
{
DisciplineItem tmp = new DisciplineItem(discipline);
tmp.MouseUp += new MouseEventHandler(Discipline_Click);
this.disciplinesPanel.Controls.Add(tmp);
}
}
private void removeMenuItem_Click(object sender, EventArgs e)
{
DialogResult result = MetroMessageBox.Show(this, "Are you sure you want to remove element?","Remove",MessageBoxButtons.YesNo,
MessageBoxIcon.Error);
if (result == DialogResult.Yes)
{
var repo = new DisciplineRepository();
try
{
repo.Delete(handle);
disciplinesPanel.Controls.Remove(item);
}
catch (Exception)
{
MetroMessageBox.Show(this,
"We are sorry but you can't delete element which other elements depend on. Please remove all elements depending on this one and then try again.",
"Whoops!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
public void Contains()
{
var repo = new DisciplineRepository();
Assert.IsFalse(repo.ContainsName("kappa"));
}
public JsonResult DeleteDiscipline(int id)
{
var result = new DisciplineRepository().RemoveByID(id);
return(Json(result, JsonRequestBehavior.AllowGet));
}
public DisciplineController()
{
_repository = new DisciplineRepository();
}
