public StatisticsViewController(IStatisticsView view) { _view = view; _view.SetController(this); OptikItDbContext db = new OptikItDbContext(); }
/// <summary> /// Gets all the employees from the db /// </summary> /// <returns></returns> public List <USERS> GetEmployees() { using (_db = new OptikItDbContext()) { return(_db.USERS.ToList()); } }
/// <summary> /// edits the specified appoint in the db /// </summary> /// <param name="appointment"></param> public void PutAppointment(APTDETAILS appointment) { using (db = new OptikItDbContext()) { var appointmentToEditQuery = from a in db.APTDETAILS where a.APD_STAMP == appointment.APD_STAMP select a; foreach (var a in appointmentToEditQuery) { a.APD_DATE = appointment.APD_DATE; a.APD_TIMEFROM = appointment.APD_TIMEFROM; a.APD_TIMETO = appointment.APD_TIMETO; a.APD_USER = appointment.APD_USER; a.APD_DESCRIPTION = appointment.APD_DESCRIPTION; a.APD_TYPE = appointment.APD_TYPE; a.APD_ROOM = appointment.APD_ROOM; a.APD_MOBILE = appointment.APD_MOBILE; a.APD_EMAIL = appointment.APD_EMAIL; } try { db.SaveChanges(); } catch (Exception) { } } }
/// <summary> /// Gets all apointments in the specified parametre timeslot /// </summary> /// <param name="monthNr"></param> /// <param name="year"></param> /// <returns></returns> public List <APTDETAILS> GetAppointments(int monthNr, int year) { try { List <APTDETAILS> roomsInTimeSpan = new List <APTDETAILS>(); using (_db = new OptikItDbContext()) { foreach (var a in _db.APTDETAILS) { if (a.APD_DATE.Value.Month == monthNr && a.APD_DATE.Value.Year == year) { roomsInTimeSpan.Add(a); } } } return(roomsInTimeSpan); } catch (DbException ex) { Debug.WriteLine("Problem retrieving appointments from the database: '" + ex.Message + "'"); return(new List <APTDETAILS>()); } }
/// <summary> /// Gets all rooms from the db /// </summary> /// <returns></returns> public List <EYEEXAMROOMS> GetRooms() { using (db = new OptikItDbContext()) { var rooms = from r in db.EYEEXAMROOMS select r; return(rooms.ToList()); } }
/// <summary> /// Gets all the appointments in the db /// </summary> /// <returns></returns> public List <APTDETAILS> GetAppointments() { using (db = new OptikItDbContext()) { var appointments = from a in db.APTDETAILS select a; return(appointments.ToList()); } }
/// <summary> /// Gets all customers from db /// </summary> /// <returns></returns> public List <CUSTOMERS> GetCustomers() { using (db = new OptikItDbContext()) { var customers = from c in db.CUSTOMERS select c; return(customers.ToList()); } }
/// <summary> /// Gets all users / employees from db /// </summary> /// <returns></returns> public List <USERS> GetUser() { using (db = new OptikItDbContext()) { var users = from u in db.USERS select u; return(users.ToList()); } }
/// <summary> /// Gets all the appointments from db /// </summary> /// <returns></returns> public List <APTDETAILS> GetAppointments() { try { using (_db = new OptikItDbContext()) { return(_db.APTDETAILS.ToList()); } } catch (DbException ex) { Debug.WriteLine("Problem retrieving appointments from the database: '" + ex.Message + "'"); return(new List <APTDETAILS>()); } }
/// <summary> /// Gets all the users / employees from the db /// </summary> /// <returns></returns> public List <USERS> GetUsers() { try { using (_db = new OptikItDbContext()) { return(_db.USERS.ToList()); } } catch (DbException ex) { Debug.WriteLine("Problem retrieving users from the database: '" + ex.Message + "'"); return(new List <USERS>()); } }
/// <summary> /// Gets all the rooms from db /// </summary> /// <returns></returns> public List <EYEEXAMROOMS> GetRooms() { try { using (_db = new OptikItDbContext()) { return(_db.EYEEXAMROOMS.ToList()); } } catch (DbException ex) { Debug.WriteLine("Problem retrieving rooms from the database: '" + ex.Message + "'"); return(new List <EYEEXAMROOMS>()); } }
/// <summary> /// cancels / deletes the specified appointment from db /// </summary> /// <param name="appointment"></param> public void DeleteAppointment(APTDETAILS appointment) { using (_db = new OptikItDbContext()) { var removeQuery = from a in _db.APTDETAILS where a.APD_STAMP == appointment.APD_STAMP select a; foreach (var a in removeQuery) { _db.APTDETAILS.Remove(a); } try { _db.SaveChanges(); } catch (Exception) { } } }
/// <summary> /// Gets the next customer from db by ID /// </summary> /// <returns></returns> public int GetNextCustomerId() { using (db = new OptikItDbContext()) { List <CUSTOMERS> customers; try { customers = GetCustomers(); int currentId = customers.Last().CS_STAMP; return(currentId + 1); } catch (DbException ex) { return(0); } } }
/// <summary> /// Deletes specified custoemr from db /// </summary> /// <param name="customer"></param> public void DeleteCustomer(CUSTOMERS customer) { using (db = new OptikItDbContext()) { var removeQuery = from a in db.CUSTOMERS where a.CS_STAMP == customer.CS_STAMP select a; foreach (var a in removeQuery) { db.CUSTOMERS.Remove(a); } try { db.SaveChanges(); } catch (Exception) { } } }
/// <summary> /// post new appointment to the db /// </summary> /// <param name="appointment"></param> public void PostAppointment(APTDETAILS appointment) { using (db = new OptikItDbContext()) { try { db.APTDETAILS.Add(appointment); db.SaveChanges(); } 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); } } } } }
/// <summary> /// creates new specified customer in db /// </summary> /// <param name="customer"></param> public void PostCustomer(CUSTOMERS customer) { using (db = new OptikItDbContext()) { try { db.CUSTOMERS.Add(customer); db.SaveChanges(); } 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); } } } } }
/// <summary> /// edits specified customer in db /// </summary> /// <param name="customer"></param> public void PutCustomer(CUSTOMERS customer) { using (db = new OptikItDbContext()) { var appointmentToEditQuery = from a in db.CUSTOMERS where a.CS_CPRNO == customer.CS_CPRNO select a; foreach (var a in appointmentToEditQuery) { a.CS_CPRNO = customer.CS_CPRNO; a.CS_FIRSTNAME = customer.CS_FIRSTNAME; a.CS_LASTNAME = customer.CS_LASTNAME; a.CS_ADRESS1 = customer.CS_ADRESS1; a.CS_PHONEMOBILE = customer.CS_PHONEMOBILE; a.CS_EMAIL = customer.CS_EMAIL; } try { db.SaveChanges(); } catch (Exception) { } } }