public JsonResult SaveDataInDatabase(FacultyListViewModel f)
{
var result = false;
try
{
if (f.faculty.facId > 0)
{
Faculty f1 = db.Faculties.SingleOrDefault(x => x.facId == f.faculty.facId);
f1.facNum = f.faculty.facNum;
f1.name = f.faculty.name;
f1.department = f.faculty.department;
f1.rank = f.faculty.rank;
db.SaveChanges();
result = true;
}
else
{
Faculty f1 = new Faculty();
f1.facNum = f.faculty.facNum;
f1.name = f.faculty.name;
f1.department = f.faculty.department;
f1.rank = f.faculty.rank;
db.Faculties.Add(f1);
db.SaveChanges();
result = true;
}
}
catch (Exception e)
{
throw e;
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult List()
{
var facultiesInDb = _facultyService.GetFaculties();
var facultyDtos = new List <FacultyDto>();
foreach (var faculty in facultiesInDb)
{
var facultyDto = Mapper.Map <Faculty, FacultyDto>(faculty);
facultyDtos.Add(facultyDto);
}
var viewModel = new FacultyListViewModel
{
FacultyDtos = facultyDtos,
};
return(View(viewModel));
}
public ActionResult Index(string searchBy, string search, int?page, int?pagesize)
{
List <FacultyViewModel> l = db.Faculties.Select(x => new FacultyViewModel
{
facId = x.facId,
facNum = x.facNum,
name = x.name,
department = x.department,
rank = x.rank
}).ToList();
int defaultpagesize = 2;
if (pagesize != null)
{
defaultpagesize = (int)pagesize;
}
FacultyListViewModel f = new FacultyListViewModel();
if (search != null)
{
if (searchBy == "Department")
{
f.ipage = l.Where(x => x.department.ToLower().StartsWith(search.ToLower()) || search == null).ToList().ToPagedList(page ?? 1, defaultpagesize);
return(View(f));
}
else if (searchBy == "Rank")
{
f.ipage = l.Where(x => x.rank.ToLower().StartsWith(search.ToLower()) || search == null).ToList().ToPagedList(page ?? 1, defaultpagesize);
return(View(f));
}
else if (searchBy == "Name")
{
f.ipage = l.Where(x => x.name.ToLower().StartsWith(search.ToLower()) || search == null).ToList().ToPagedList(page ?? 1, defaultpagesize);
return(View(f));
}
}
f.ipage = l.ToList().ToPagedList(page ?? 1, defaultpagesize);
return(View(f));
}
