public ActionResult Add(Employee toAdd)
{
using (collabcontext db = new collabcontext()) {
//getting a new employee model -dummy
EmployeeModel vm = new EmployeeModel()
{
Result = new List <Employee>()
};
if (toAdd != null)
{
bool isAlready = db.Employees
.Where(x => x.Id == toAdd.Id)
.Count() != 0;
if (!isAlready)
{
if (!String.IsNullOrEmpty(toAdd.Email) && !String.IsNullOrEmpty(toAdd.Alias))
{
db.Employees.Add(toAdd);
try {
db.SaveChanges();
vm.Result = db.Employees.ToList <Employee>();
return(View("Index", vm));
}
catch (Exception x) {
return(View());
}
}
}
return(View("Index", vm));
}
return(View("Index", vm));
}
}
public ActionResult Search(int SearchPhrase)
{
using (collabcontext db = new collabcontext()) {
var result = db.Employees.Where(x => x.Id == SearchPhrase).Select(x => x);
EmployeeModel vm = new EmployeeModel()
{
Result = result.ToList <Employee>()
};
return(View("Index", vm));
}
}
public ActionResult Index()
{
using (collabcontext db = new collabcontext())
{
var employees = db.Employees.Select(x => x);
EmployeeModel vm = new EmployeeModel()
{
Result = employees.ToList <Employee>()
};
return(View("Index", vm));
}
}