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); }