public ResponseMessageWrap <int> DeleteById(long id)
{
return(new ResponseMessageWrap <int>
{
Body = CollegeService.DeleteById(id)
});
}
public ResponseMessageWrap <int> Update([FromBody] College college)
{
return(new ResponseMessageWrap <int>
{
Body = CollegeService.Update(college)
});
}
public ResponseMessageWrap <int> Insert([FromBody] College college)
{
return(new ResponseMessageWrap <int>
{
Body = CollegeService.Insert(college)
});
}
void searchErKaj()
{
if (konta == 1)
{
CandidateService cs = new CandidateService();
List <Candidate> cndList = cs.getAllByName(textBox1.Text);
cndGridView.DataSource = cndList;
}
if (konta == 2)
{
CandidateService cs = new CandidateService();
List <Candidate> cndList = cs.getAllByName(textBox1.Text);
cndGridView2.DataSource = cndList;
}
if (konta == 3)
{
CollegeService cs = new CollegeService();
List <College> clgList = cs.getAllByName(textBox1.Text);
clgGridView.DataSource = clgList;
}
if (konta == 4)
{
List <stuClg> filteredStuClgList = new List <stuClg>();
foreach (stuClg can in stuClgList)
{
if (can.StudentName.ToLower().Contains(textBox1.Text.ToLower()))
{
filteredStuClgList.Add(can);
}
}
finGridView.DataSource = filteredStuClgList;
}
}
public ActionResult ViewColleges()
{
CollegeService collegeService = new CollegeService();
List <CollegeDetailsModel> lstColleges = new List <CollegeDetailsModel>();
lstColleges = collegeService.GetColleges();
return(View(lstColleges));
}
public ActionResult UpdateCollege(Guid id)
{
CollegeService collegeService = new CollegeService();
CollegeDetailsModel modelToDisplay = new CollegeDetailsModel();
modelToDisplay = collegeService.GetCollege(id);
return(View(modelToDisplay));
}
public ActionResult ViewCollege(Guid id)
{
CollegeService collegeService = new CollegeService();
CollegeDetailsModel modelToView = new CollegeDetailsModel();
modelToView = collegeService.GetCollege(id);
return(View(modelToView));
}
/// <summary>
/// Apresenta a tela para edição de uma escola
/// </summary>
/// <param name="id">Código de identificação da escola</param>
/// <returns></returns>
public ActionResult Edit(int id)
{
using (ctx)
{
var srvCollege = new CollegeService(ctx);
var oCollege = srvCollege.Sigle(id);
return PartialView("_ModalForm", oCollege);
}
}
public ActionResult Create(CollegeService collegeService)
{
try
{
CollegeService cs = db.CollegeServices.FirstOrDefault(c => c.CollegeServiceName == collegeService.CollegeServiceName);
if (cs == null)
{
collegeService.CreatedBy = Convert.ToInt32(Session["emp_id"]);
collegeService.CreatedOn = DateTime.Now;
db.CollegeServices.Add(collegeService);
try
{
db.SaveChanges();
ViewBag.MessageType = "success";
ViewBag.Message = "Data has been saved successfully.";
}
catch (DbUpdateException ex)
{
ViewBag.MessageType = "error";
ViewBag.Message = ex.Message;
ModelState.AddModelError(string.Empty, ex.Message);
}
}
else
{
ModelState.AddModelError(string.Empty, "Service Name is already exists.");
ViewBag.MessageType = "error";
ViewBag.Message = "Service Name is already exists.";
}
}
catch (DbEntityValidationException ex)
{
string ErrorMessage = "";
int count = 0;
foreach (DbEntityValidationResult validationResult in ex.EntityValidationErrors)
{
string entityName = validationResult.Entry.Entity.GetType().Name;
foreach (DbValidationError error in validationResult.ValidationErrors)
{
ModelState.AddModelError(string.Empty, error.ErrorMessage);
count++;
ErrorMessage += count + "-" + string.Concat(error.PropertyName, " is required.") + "<br />";
}
}
ViewBag.MessageType = "error";
ViewBag.Message = ErrorMessage;
}
model.CollegeServices = db.CollegeServices.OrderByDescending(a => a.CollegeServiceID).ToList();
model.SelectedCollegeService = null;
model.DisplayMode = "WriteOnly";
ViewBag.IsActive = new SelectList(db.Options, "OptionDesc", "OptionDesc", collegeService.IsActive);
ViewBag.IsEffectProgramFee = new SelectList(db.Options, "OptionDesc", "OptionDesc", collegeService.CollegeServiceID);
return(View("Index", model));
}
private void clgButton_Click(object sender, EventArgs e)
{
konta = 3;
hideAll();
clgGridView.Show();
CollegeService cs = new CollegeService();
List <College> clgList = cs.getAll();
clgGridView.DataSource = clgList;
}
/// <summary>
/// Apresenta a tela para inclusão de uma nova turma
/// </summary>
/// <returns></returns>
public ActionResult Create()
{
using (ctx)
{
// Cria uma lista de escolas para preencher o dropdownlist
var srvCollege = new CollegeService(ctx);
var lstColleges = srvCollege.GetAll();
ViewBag.Colleges = new SelectList(lstColleges, "ID", "Name");
}
return PartialView("_ModalForm", new Classroom());
}
public ActionResult DeleteCollege(Guid id)
{
CollegeService collegeService = new CollegeService();
if (collegeService.DeleteCollege(id))
{
TempData["toast"] = "College Deleted successfully";
return(RedirectToAction("ViewColleges"));
}
else
{
ModelState.AddModelError("DeleteCollegeFailedError", "Unable to delete college");
return(this.View());
}
}
protected void Application_BeginRequest(object sender, EventArgs e)
{
Response.Headers.Remove("Server");
Response.Headers.Remove("X-Powered-By");
Response.Headers.Remove("X-AspNet-Version");
Response.Headers.Remove("X-AspNetMvc-Version");
HttpContextBase currentContext = new HttpContextWrapper(HttpContext.Current);
if (currentContext.Request.Params.AllKeys.Contains("ReturnUrl"))
{
Response.Redirect("~/Pages/Login");
}
if (HttpContext.Current.Cache["ScheduleItem_1"] == null)//(HttpContext.Current.Request.Url.ToString() == WebConfigurationManager.AppSettings["BaseURL"] + "/Pages/SystemManagement/StartService")
{
RegisterCacheEntry();
}
if (HttpContext.Current.Cache["IsRun"] == null)
{
var _scheduleService = new ScheduleService(new ScheduleRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _termService = new TermService(new TermRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _mappingService = new MappingService(new MappingRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _collegeService = new CollegeService(new CollegeRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _educationalGroupService = new EducationalGroupService(new EducationalGroupRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _professorService = new ProfessorService(new ProfessorRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _educationalClassService = new EducationalClassService(new EducationalClassRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _studentEducationalClassService = new StudentEducationalClassService(new StudentEducationalClassRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _professorScoreService = new ProfessorScoreService(new ProfessorScoreRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _indicatorService = new IndicatorService(new IndicatorRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _mappingTypeService = new MappingTypeService(new MappingTypeRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _universityLevelMappingService = new UniversityLevelMappingService(new UniversityLevelMappingRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _educationalGroupScoreService = new EducationalGroupScoreService(new EducationalGroupScoreRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _logService = new LogService(new LogRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _logTypeService = new LogTypeService(new LogTypeRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _userService = new UserService(new UserRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var schedule = new ScheduleController(_scheduleService, _termService, _mappingService, _collegeService, _educationalGroupService
, _professorService, _educationalClassService, _studentEducationalClassService, _professorScoreService, _indicatorService, _mappingTypeService
, _universityLevelMappingService, _educationalGroupScoreService, _logService, _logTypeService, _userService);
var schedules = schedule.ListAllSchedules();
foreach (var scheduleItem in schedules)
{
CheckScheduleTimeLapse("ScheduleItem_" + scheduleItem.Id);
}
}
}
public ActionResult Edit(CollegeService collegeService)
{
try
{
db.Entry(collegeService).State = EntityState.Modified;
collegeService.ModifiedBy = Convert.ToInt32(Session["emp_id"]);
collegeService.ModifiedOn = DateTime.Now;
try
{
db.SaveChanges();
ViewBag.MessageType = "success";
ViewBag.Message = "Data has been saved successfully.";
}
catch (DbUpdateException ex)
{
ViewBag.MessageType = "error";
ViewBag.Message = ex.Message;
ModelState.AddModelError(string.Empty, ex.Message);
}
}
catch (DbEntityValidationException ex)
{
string ErrorMessage = "";
int count = 0;
foreach (DbEntityValidationResult validationResult in ex.EntityValidationErrors)
{
string entityName = validationResult.Entry.Entity.GetType().Name;
foreach (DbValidationError error in validationResult.ValidationErrors)
{
ModelState.AddModelError(string.Empty, error.ErrorMessage);
count++;
ErrorMessage += string.Concat(count, "-", error.ErrorMessage, "\n");
}
}
ViewBag.MessageType = "error";
ViewBag.Message = ErrorMessage;
}
model.CollegeServices = db.CollegeServices.OrderByDescending(a => a.CollegeServiceID).ToList();
model.SelectedCollegeService = null;
model.DisplayMode = "WriteOnly";
ViewBag.IsActive = new SelectList(db.Options, "OptionDesc", "OptionDesc", collegeService.IsActive);
ViewBag.IsEffectProgramFee = new SelectList(db.Options, "OptionDesc", "OptionDesc", collegeService.CollegeServiceID);
return(View("Index", model));
}
private bool RegisterCacheEntry()
{
var _scheduleService = new ScheduleService(new ScheduleRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _termService = new TermService(new TermRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _mappingService = new MappingService(new MappingRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _collegeService = new CollegeService(new CollegeRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _educationalGroupService = new EducationalGroupService(new EducationalGroupRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _professorService = new ProfessorService(new ProfessorRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _educationalClassService = new EducationalClassService(new EducationalClassRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _studentEducationalClassService = new StudentEducationalClassService(new StudentEducationalClassRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _professorScoreService = new ProfessorScoreService(new ProfessorScoreRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _indicatorService = new IndicatorService(new IndicatorRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _mappingTypeService = new MappingTypeService(new MappingTypeRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _universityLevelMappingService = new UniversityLevelMappingService(new UniversityLevelMappingRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _educationalGroupScoreService = new EducationalGroupScoreService(new EducationalGroupScoreRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _logService = new LogService(new LogRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _logTypeService = new LogTypeService(new LogTypeRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _userService = new UserService(new UserRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var schedule = new ScheduleController(_scheduleService, _termService, _mappingService, _collegeService, _educationalGroupService
, _professorService, _educationalClassService, _studentEducationalClassService, _professorScoreService, _indicatorService, _mappingTypeService
, _universityLevelMappingService, _educationalGroupScoreService, _logService, _logTypeService, _userService);
if (HttpContext.Current.Cache["IsRun"] == null)
{
HttpContext.Current.Cache.Add("IsRun", "True", null, DateTime.MaxValue, Cache.NoSlidingExpiration, CacheItemPriority.Normal, null);
}
var schedules = schedule.ListAllSchedules();
foreach (var scheduleItem in schedules)
{
if (null != HttpContext.Current.Cache["ScheduleItem_" + scheduleItem.Id])
{
return(false);
}
HttpContext.Current.Cache.Add("ScheduleItem_" + scheduleItem.Id, "Test", null,
DateTime.MaxValue, TimeSpan.FromMinutes(2),
CacheItemPriority.Normal,
new CacheItemRemovedCallback(CacheItemRemovedCallback));
}
return(true);
}
public ActionResult UpdateCollege(CollegeDetailsModel modelToUpdate)
{
if (!ModelState.IsValid)
{
return(View());
}
CollegeService collegeService = new CollegeService();
if (collegeService.UpdateCollege(modelToUpdate))
{
TempData["toast"] = "College Updated successfully";
return(RedirectToAction("ViewColleges"));
}
else
{
ModelState.AddModelError("UpdateCollegeFailedError", "Error in updating the college. The College code should be unique");
return(this.View());
}
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CollegeService collegeService = db.CollegeServices.Find(id);
if (collegeService == null)
{
return(HttpNotFound());
}
model.CollegeServices = db.CollegeServices.OrderByDescending(a => a.CollegeServiceID).ToList();
model.SelectedCollegeService = collegeService;
model.DisplayMode = "Delete";
ViewBag.MessageType = "";
ViewBag.Message = "";
return(View("Index", model));
}
public async Task CheckScheduleTimeLapse(string key)
{
var log = new List <string>();
log.Add("Test Action 1 at: " + DateTime.Now);
//System.IO.File.AppendAllLines(System.AppDomain.CurrentDomain.BaseDirectory + "log.txt", log);
var _scheduleService = new ScheduleService(new ScheduleRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _termService = new TermService(new TermRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _mappingService = new MappingService(new MappingRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _collegeService = new CollegeService(new CollegeRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _educationalGroupService = new EducationalGroupService(new EducationalGroupRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _professorService = new ProfessorService(new ProfessorRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _educationalClassService = new EducationalClassService(new EducationalClassRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _studentEducationalClassService = new StudentEducationalClassService(new StudentEducationalClassRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _professorScoreService = new ProfessorScoreService(new ProfessorScoreRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _indicatorService = new IndicatorService(new IndicatorRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _mappingTypeService = new MappingTypeService(new MappingTypeRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _universityLevelMappingService = new UniversityLevelMappingService(new UniversityLevelMappingRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _educationalGroupScoreService = new EducationalGroupScoreService(new EducationalGroupScoreRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _logService = new LogService(new LogRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _logTypeService = new LogTypeService(new LogTypeRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var _userService = new UserService(new UserRepository(new DatabaseFactory()), new UnitOfWork(new DatabaseFactory()));
var schedule = new ScheduleController(_scheduleService, _termService, _mappingService, _collegeService, _educationalGroupService
, _professorService, _educationalClassService, _studentEducationalClassService, _professorScoreService, _indicatorService, _mappingTypeService
, _universityLevelMappingService, _educationalGroupScoreService, _logService, _logTypeService, _userService);
var sid = Convert.ToDecimal(key.Remove(0, 13));
log.Add("Test Action 2 at: " + DateTime.Now);
var sch = schedule.GetSchedule(sid);
log.Add("Test Action 3 at: " + DateTime.Now);
if (!string.IsNullOrEmpty(sch.ActionMethod) && sch.ActionMethod.LastIndexOf('.') > 0)
{
await Task.Run(() => { schedule.RunSchedule(sch); });
}
log.Add("Test Action 4 at: " + DateTime.Now);
}
public ActionResult Update(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CollegeService collegeService = db.CollegeServices.Find(id);
if (collegeService == null)
{
return(HttpNotFound());
}
model.CollegeServices = db.CollegeServices.OrderByDescending(a => a.CollegeServiceID).ToList();
model.SelectedCollegeService = collegeService;
model.DisplayMode = "ReadWrite";
ViewBag.IsActive = new SelectList(db.Options, "OptionDesc", "OptionDesc", collegeService.IsActive);
ViewBag.IsEffectProgramFee = new SelectList(db.Options, "OptionDesc", "OptionDesc", collegeService.CollegeServiceID);
ViewBag.MessageType = "";
ViewBag.Message = "";
return(View("Index", model));
}
public ActionResult Delete(int id)
{
var vSuccess = true;
var vErro = string.Empty;
try
{
using (ctx)
{
var srvCollege = new CollegeService(ctx);
var oCollege = srvCollege.Sigle(id);
vSuccess = srvCollege.DeleteAndSave(oCollege);
}
}
catch (Exception ex)
{
vSuccess = false;
vErro = "Ocorreu um erro durante a exclusão! " + ex.Message;
}
return Json(new { success = vSuccess, message = vErro });
}
public ActionResult DeleteConfirmed(int id)
{
try
{
CollegeService collegeService = db.CollegeServices.Find(id);
db.CollegeServices.Remove(collegeService);
db.SaveChanges();
ViewBag.MessageType = "success";
ViewBag.Message = "Record has been removed successfully.";
}
catch (DbUpdateException ex)
{
ViewBag.MessageType = "error";
ViewBag.Message = ex.Message;
ModelState.AddModelError(string.Empty, ex.Message);
}
model.CollegeServices = db.CollegeServices.OrderByDescending(a => a.CollegeServiceID).ToList();
model.SelectedCollegeService = null;
model.DisplayMode = "WriteOnly";
ViewBag.IsActive = new SelectList(db.Options, "OptionDesc", "OptionDesc");
ViewBag.IsEffectProgramFee = new SelectList(db.Options, "OptionDesc", "OptionDesc");
return(View("Index", model));
}
public CollegeController(AppDbContext context)
{
_context = context;
collegeService = new CollegeService(_context);
}
public ActionResult Save(Classroom oClassroom)
{
using (ctx)
{
if (ModelState.IsValid)
{
try
{
var srvClassroom = new ClassroomService(ctx);
if (oClassroom.ID == 0)
srvClassroom.InsertAndSave(oClassroom);
else
srvClassroom.UpdateAndSave(oClassroom);
}
catch (Exception ex)
{
ModelState.AddModelError("", "Ocorreu um erro: " + ex.Message);
}
}
// Cria uma lista de escolas para preencher o dropdownlist
var srvCollege = new CollegeService(ctx);
var lstColleges = srvCollege.GetAll();
ViewBag.Colleges = new SelectList(lstColleges, "ID", "Name");
}
return PartialView("_ModalForm", oClassroom);
}
/// <summary>
/// Apresenta a tela para edição de uma turma
/// </summary>
/// <param name="id">Código de identificação da turma</param>
/// <returns></returns>
public ActionResult Edit(int id)
{
using (ctx)
{
var srvClassroom = new ClassroomService(ctx);
var oClassroom = srvClassroom.Sigle(id);
// Cria uma lista de escolas para preencher o dropdownlist
var srvCollege = new CollegeService(ctx);
var lstColleges = srvCollege.GetAll();
ViewBag.Colleges = new SelectList(lstColleges, "ID", "Name");
return PartialView("_ModalForm", oClassroom);
}
}
/// <summary>
/// Lista todas as escolas cadastradas
/// </summary>
/// <returns></returns>
public ActionResult Index()
{
using (ctx)
{
var srvCollege = new CollegeService(ctx);
var lstColleges = srvCollege.GetAll();
return View(lstColleges);
}
}
public CollegeController(CollegeService collegeService, ICollegeRepository collegeRepository)
{
CollegeService = collegeService;
CollegeRepository = collegeRepository;
}
public ActionResult Save(College oCollege)
{
if (ModelState.IsValid)
{
try
{
using (ctx)
{
var srvCollege = new CollegeService(ctx);
if (oCollege.ID == 0)
srvCollege.InsertAndSave(oCollege);
else
srvCollege.UpdateAndSave(oCollege);
}
}
catch (Exception ex)
{
ModelState.AddModelError("", "Ocorreu um erro: " + ex.Message);
}
}
return PartialView("_ModalForm", oCollege);
}
