public AppsResult GetEmployeeById(int id)
{
var result = new AppsResult();
try
{
//using (var db = new LiteDatabase(dbPath))
//{
// var objs = db.GetCollection<Employee>("Employees");
// result.Data = objs.FindAll().Where(e => e.ID == id).ToList();
// result.Success = true;
//}
using (var db = new Data())
{
result.Data = db.Employees.Where(e => e.ID == id).ToList();
result.Success = true;
}
}
catch (Exception ex)
{
result.FailMessages.Add("Exception getting employee by ID.");
AppsLog.LogStep <Business.Flows.Employee.Exception>(ex.ToString());
}
return(result);
}
public AppsResult UpsertEmployee([FromBody] Employee employee)
{
var result = new AppsResult();
try
{
//using (var dblocal = new LiteDatabase(dbPath))
//{
// var objs = dblocal.GetCollection<Employee>("Employees");
// objs.Upsert(employee);
// result.Data = objs.FindAll().ToList();
// result.Success = true;
//}
using (var db = new Data())
{
db.Employees.Add(employee);
db.SaveChanges();
result.Success = true;
}
}
catch (Exception ex)
{
result.FailMessages.Add("Exception saving employee.");
AppsLog.LogStep <Business.Flows.Employee.Exception>(ex.ToString());
}
return(result);
}
public AppsResult UnitTests()
{
var result = new AppsResult();
try
{
using (var db = new LiteDatabase(dbPath))
{
//get model
result = GetEmployeeModel();
//bind model
//get employees
//get single employee
//create employee
}
}
catch (Exception ex)
{
result.FailMessages.Add("Exception getting employee by ID.");
AppsLog.LogStep <Business.Flows.Employee.Exception>(ex.ToString());
}
return(result);
}