private void InsertData(Employee_Activities activities) { using var context = new TimeCardEntityModel(); var act = context.Set <Employee_Activities>(); act.Add(activities); context.SaveChanges(); }
async Task <List <Employee_Activities> > getEmployeeActivities(DateTime dateTime) { using var context = new TimeCardEntityModel(); try { return(await context.Employee_Activities .Where(x => (x.Employee.FirstName + " " + x.Employee.LastName) == comboBoxText && x.ActivityDate.Day == dateTime.Day).ToListAsync()); } catch (NullReferenceException e) { Console.WriteLine(e); throw; } }
async Task <List <Employee> > getEmployees() { using var context = new TimeCardEntityModel(); return(await context.Employees.ToListAsync()); }
async Task <List <string> > getEmployees() { using var context = new TimeCardEntityModel(); return(await context.Employees.Select(x => x.FirstName + " " + x.LastName).ToListAsync()); }