public IActionResult EditWorkIn(int id)
{
Work_in work = _dbQueries.GetWorkIn(ProfId, id);
workDep_Id = work.Dep_Id.Value;
IEnumerable <Department> list = _dbQueries.returnAllDepartment();
ViewBag.DepartmentList = new SelectList(list, "Id", "Name", work.Dep_Id);
ViewBag.ProfName = ProfName;
return(View());
}
public IActionResult AddProfessor(Professor model)
{
if (model.Id > 0 && model.Name != null)
{
var result = _dbQueries.isProf(model.Id);
var result2 = _dbQueries.isStudent(model.Id);
var result3 = _dbQueries.isAdmin(model.Id);
if (result || result2 || result3)
{
TempData["Message"] = "This Professor Id is alredy exist";
}
if (!result && !result2 && !result)
{
Professor professor = new Professor();
professor.Id = model.Id;
professor.Name = model.Name;
if (model.Password == null)
{
professor.Password = "******";
}
else
{
professor.Password = model.Password;
}
professor.Admin_Id = ID;
_dbQueries.SaveProfessor(professor);
Work_in work = new Work_in();
work.Prof_Id = model.Id;
work.Dep_Id = 0;
_dbQueries.SaveWorkin(work);
return(RedirectToAction("SearchProfessor", "Admin"));
}
}
else
{
if (model.Id <= 0)
{
TempData["Message"] = "Id field cannot be empty";
}
if (model.Name == null)
{
TempData["Message2"] = "Name field cannot be empty";
}
}
return(View());
}
public IActionResult AddWorkIn(Work_in model)
{
if (model.Dep_Id >= 0)
{
var result = _dbQueries.CheckWorkIn(ProfId, model.Dep_Id.Value);
if (!result)
{
Work_in work = new Work_in();
work.Prof_Id = ProfId;
work.Dep_Id = model.Dep_Id;
_dbQueries.SaveWorkin(work);
return(RedirectToAction("EditProfessor", "Admin", new { id = ProfId }));
}
TempData["Message"] = "Already worked in this department";
}
IEnumerable <Department> list = _dbQueries.returnAllDepartment();
ViewBag.DepartmentList = new SelectList(list, "Id", "Name");
return(View());
}
public IActionResult EditWorkIn(Work_in model, string button)
{
if (button == "delete")
{
_dbQueries.WorkInDelete2(ProfId, workDep_Id);
_dbQueries.ReSignTaProf_Id(ProfId);
return(RedirectToAction("EditProfessor", "Admin", new { id = ProfId }));
}
var result = _dbQueries.CheckWorkIn(ProfId, model.Dep_Id.Value);
if (!result)
{
_dbQueries.WorkInUpdate(ProfId, workDep_Id, model.Dep_Id.Value);
return(RedirectToAction("EditProfessor", "Admin", new { id = ProfId }));
}
IEnumerable <Department> list = _dbQueries.returnAllDepartment();
ViewBag.DepartmentList = new SelectList(list, "Id", "Name", model.Dep_Id);
TempData["Message"] = "Already worked in this department";
return(View());
}
public void SaveWorkin(Work_in model)
{
_dbContext.Add(model);
_dbContext.SaveChanges();
}
