public static void storeEmployee(string employeeName, String employeeEmail) { using (var db = new PhoneLog.Models.PhoneLogContext()) { var employee = new PhoneLog.Models.Employee { EmployeeName = employeeName, EmployeeEmail = employeeEmail }; db.Employees.Add(employee); try { int result = db.SaveChanges(); Console.WriteLine(result); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } } } }
public static void storeCallType(string callType) { using (var db = new PhoneLog.Models.PhoneLogContext()) { var call = new PhoneLog.Models.CallType { CallType1 = callType }; db.CallTypes.Add(call); try { int result = db.SaveChanges(); Console.WriteLine(result); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } } } }
public static void deleteEmployee(int id) { using (var db = new PhoneLog.Models.PhoneLogContext()) { var employee = db.Employees.Where(item => item.Id == id).Single(); db.Employees.Remove(employee); db.SaveChanges(); } }
public static void deleteCallType(int id) { using (var db = new PhoneLog.Models.PhoneLogContext()) { var callType = db.CallTypes.Where(item => item.Id == id).Single(); db.CallTypes.Remove(callType); db.SaveChanges(); } }
public static Models.CallType getCallTypeById(int id) { using (var db = new PhoneLog.Models.PhoneLogContext()) { var callType = db.CallTypes.Where(item => item.Id == id).Single(); return new Models.CallType { Id = callType.Id, CallType1 = callType.CallType1 }; } }
public static Models.Employee getEmployeeById(int id) { using (var db = new PhoneLog.Models.PhoneLogContext()) { var employee = db.Employees.Where(item => item.Id == id).Single(); return new Models.Employee { Id = employee.Id, EmployeeName = employee.EmployeeName, EmployeeEmail = employee.EmployeeEmail }; } }
public static List<PhoneLog.Models.CallType> getAllCallTypes() { List<Models.CallType> allCallTypes = new List<Models.CallType>(); using (var db = new PhoneLog.Models.PhoneLogContext()) { var query = from l in db.CallTypes orderby l.CallType1 select l; Console.WriteLine("All calltypes in the database:"); foreach (var item in query) { allCallTypes.Add(new Models.CallType { Id = item.Id, CallType1 = item.CallType1 }); } } return allCallTypes; }
public static List<PhoneLog.Models.Employee> getAllEmployees() { List<Models.Employee> allEmployees = new List<Models.Employee>(); using (var db = new PhoneLog.Models.PhoneLogContext()) { var query = from l in db.Employees orderby l.EmployeeName select l; Console.WriteLine("All employees in the database:"); foreach (var item in query) { allEmployees.Add(new Models.Employee { Id = item.Id, EmployeeName = item.EmployeeName, EmployeeEmail = item.EmployeeEmail }); } } return allEmployees; }