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