public IEnumerable <Setup> Get() { List <Setup> setups = new List <Setup>(); _Connector.Connect(); MySqlCommand execute = new MySqlCommand("SELECT * FROM Setup;", _Connector.database); using (MySqlDataReader DataReader = execute.ExecuteReader()) { do { while (DataReader.Read()) { Setup newSetup = new Setup(); for (int i = 0; i < DataReader.FieldCount; i++) { switch (DataReader.GetName(i)) { case "SetupID": newSetup.SetupID = int.Parse(DataReader.GetValue(i).ToString()); break; case "AddressID": newSetup.AddressID = int.Parse(DataReader.GetValue(i).ToString()); break; case "EquipmentID": newSetup.EquipmentID = int.Parse(DataReader.GetValue(i).ToString()); break; case "DoctorFirstName": newSetup.DoctorFirstName = (string)DataReader.GetValue(i); break; case "DoctroLastName": newSetup.DoctroLastName = (string)DataReader.GetValue(i); break; case "RoomNumber": newSetup.RoomNumber = ushort.Parse(DataReader.GetValue(i).ToString()); break; case "Image": newSetup.Image = (string)DataReader.GetValue(i); break; case "SetUpDescription": newSetup.SetUpDescription = (string)DataReader.GetValue(i); break; } } setups.Add(newSetup); } } while (DataReader.NextResult()); } execute.Dispose(); _Connector.Disconnect(); return(setups); } //connects to server, runs query Select * from Setup and returns a list of Setup objects
public IEnumerable <Address> Get() { List <Address> address = new List <Address>(); _Connector.Connect(); MySqlCommand execute = new MySqlCommand("SELECT * FROM Address;", _Connector.database); using (MySqlDataReader DataReader = execute.ExecuteReader()) { do { while (DataReader.Read()) { Address newAddress = new Address(); for (int i = 0; i < DataReader.FieldCount; i++) { switch (DataReader.GetName(i)) { case "AddressID": newAddress.AddressID = int.Parse(DataReader.GetValue(i).ToString()); break; case "BuildingName": newAddress.BuildingName = (string)DataReader.GetValue(i); break; case "AddressLine1": newAddress.AddressLine1 = (string)DataReader.GetValue(i); break; case "AddressLine2": newAddress.AddressLine2 = (string)DataReader.GetValue(i); break; case "City": newAddress.City = (string)DataReader.GetValue(i); break; case "State": newAddress.State = (string)DataReader.GetValue(i); break; case "Zipcode": newAddress.Zipcode = (string)DataReader.GetValue(i); break; } } address.Add(newAddress); } } while (DataReader.NextResult()); } execute.Dispose(); _Connector.Disconnect(); return(address); }
public IEnumerable <Tech> Get() { List <Tech> techs = new List <Tech>(); _Connector.Connect(); MySqlCommand execute = new MySqlCommand("SELECT * FROM Tech;", _Connector.database); using (MySqlDataReader DataReader = execute.ExecuteReader()) { do { while (DataReader.Read()) { Tech newtech = new Tech(); for (int i = 0; i < DataReader.FieldCount; i++) { switch (DataReader.GetName(i)) { case "TechID": newtech.TechID = int.Parse(DataReader.GetValue(i).ToString()); break; case "FirstName": newtech.FirstName = (string)DataReader.GetValue(i); break; case "LastName": newtech.LastName = (string)DataReader.GetValue(i); break; case "JobRole": newtech.JobRole = (string)DataReader.GetValue(i); break; case "Email": newtech.Email = (string)DataReader.GetValue(i); break; case "PhoneNumber": newtech.PhoneNumber = (string)DataReader.GetValue(i); break; case "IsWorking": newtech.IsWorking = (bool)DataReader.GetValue(i); break; } } techs.Add(newtech); } } while (DataReader.NextResult()); } execute.Dispose(); _Connector.Disconnect(); return(techs); } //connects to server, runs query Select * from Tech and returns a list of Tech objects
public IEnumerable <Equipment> Get() { List <Equipment> equipment = new List <Equipment>(); _Connector.Connect(); MySqlCommand execute = new MySqlCommand("SELECT * FROM Equipment;", _Connector.database); using (MySqlDataReader DataReader = execute.ExecuteReader()) { do { while (DataReader.Read()) { Equipment newEquipment = new Equipment(); for (int i = 0; i < DataReader.FieldCount; i++) { switch (DataReader.GetName(i)) { case "EquipmentID": newEquipment.EquipmentID = int.Parse(DataReader.GetValue(i).ToString()); break; case "LaserID": newEquipment.LaserID = int.Parse(DataReader.GetValue(i).ToString()); break; case "LensID": newEquipment.LensID = int.Parse(DataReader.GetValue(i).ToString()); break; case "PhacoID": newEquipment.PhacoID = int.Parse(DataReader.GetValue(i).ToString()); break; case "ScopeID": newEquipment.ScopeID = int.Parse(DataReader.GetValue(i).ToString()); break; case "VanID": newEquipment.VanID = int.Parse(DataReader.GetValue(i).ToString()); break; } } equipment.Add(newEquipment); } } while (DataReader.NextResult()); } execute.Dispose(); _Connector.Disconnect(); return(equipment); } //connects to server, runs query Select * from Equipment and returns a list of Equipment objects
public IEnumerable <Van> Get() { List <Van> vans = new List <Van>(); _Connector.Connect(); MySqlCommand execute = new MySqlCommand("SELECT * FROM Van;", _Connector.database); using (MySqlDataReader DataReader = execute.ExecuteReader()) { do { while (DataReader.Read()) { Van newVan = new Van(); for (int i = 0; i < DataReader.FieldCount; i++) { switch (DataReader.GetName(i)) { case "VanID": newVan.VanID = int.Parse(DataReader.GetValue(i).ToString()); break; case "Brand": newVan.Brand = (string)DataReader.GetValue(i); break; case "Model": newVan.Model = (string)DataReader.GetValue(i); break; case "Length": newVan.Length = (string)DataReader.GetValue(i); break; case "Height": newVan.Height = (string)DataReader.GetValue(i); break; case "InUse": newVan.InUse = (bool)DataReader.GetValue(i); break; } } vans.Add(newVan); } } while (DataReader.NextResult()); } execute.Dispose(); _Connector.Disconnect(); return(vans); } //connects to server, runs query Select * from Van and returns a list of Van objects
public IEnumerable <Appointment> Get() { List <Appointment> appointments = new List <Appointment>(); _Connector.Connect(); MySqlCommand execute = new MySqlCommand("SELECT * FROM Appointment;", _Connector.database); using (MySqlDataReader DataReader = execute.ExecuteReader()) { do { while (DataReader.Read()) { Appointment newAppointment = new Appointment(); for (int i = 0; i < DataReader.FieldCount; i++) { switch (DataReader.GetName(i)) { case "AppointmentID": newAppointment.AppointmentID = int.Parse(DataReader.GetValue(i).ToString()); break; case "CustomerID": newAppointment.CustomerID = int.Parse(DataReader.GetValue(i).ToString()); break; case "DateTimeStart": newAppointment.DateTimeStart = DateTime.Parse(DataReader.GetValue(i).ToString()); break; case "DateTimeEnd": newAppointment.DateTimeEnd = DateTime.Parse(DataReader.GetValue(i).ToString()); break; case "ShipDate": newAppointment.ShipDate = DateTime.Parse(DataReader.GetValue(i).ToString()); break; case "IsActive": newAppointment.IsActive = (bool)DataReader.GetValue(i); break; } } appointments.Add(newAppointment); } } while (DataReader.NextResult()); } execute.Dispose(); _Connector.Disconnect(); return(appointments); } //connects to server, runs query Select * from Customer and returns a list of Customer objects
public IEnumerable <Scope> Get() { List <Scope> scopes = new List <Scope>(); _Connector.Connect(); MySqlCommand execute = new MySqlCommand("SELECT * FROM Scope;", _Connector.database); using (MySqlDataReader DataReader = execute.ExecuteReader()) { do { while (DataReader.Read()) { Scope newScope = new Scope(); for (int i = 0; i < DataReader.FieldCount; i++) { switch (DataReader.GetName(i)) { case "ScopeID": newScope.ScopeID = int.Parse(DataReader.GetValue(i).ToString()); break; case "Brand": newScope.Brand = (string)DataReader.GetValue(i); break; case "Model": newScope.Model = (string)DataReader.GetValue(i); break; case "ScopeName": newScope.ScopeName = (string)DataReader.GetValue(i); break; case "IsActive": newScope.IsActive = (bool)DataReader.GetValue(i); break; } } scopes.Add(newScope); } } while (DataReader.NextResult()); } execute.Dispose(); _Connector.Disconnect(); return(scopes); } //connects to server, runs query Select * from Scope and returns a list of Scope objects
public IEnumerable <OnCallTechs> Get() { List <OnCallTechs> onCallTechs = new List <OnCallTechs>(); _Connector.Connect(); MySqlCommand execute = new MySqlCommand("SELECT * FROM OnCallTechs;", _Connector.database); using (MySqlDataReader DataReader = execute.ExecuteReader()) { do { while (DataReader.Read()) { OnCallTechs newOnCallTechs = new OnCallTechs(); for (int i = 0; i < DataReader.FieldCount; i++) { switch (DataReader.GetName(i)) { case "OnCallTechID": newOnCallTechs.OnCallTechID = int.Parse(DataReader.GetValue(i).ToString()); break; case "TechPrimaryID": newOnCallTechs.TechPrimaryID = int.Parse(DataReader.GetValue(i).ToString()); break; case "TechSecondaryID": newOnCallTechs.TechSecondaryID = int.Parse(DataReader.GetValue(i).ToString()); break; case "TechTertiaryID": newOnCallTechs.TechTertiaryID = int.Parse(DataReader.GetValue(i).ToString()); break; case "TechAvailable": newOnCallTechs.TechAvailable = byte.Parse(DataReader.GetValue(i).ToString()); break; } } onCallTechs.Add(newOnCallTechs); } } while (DataReader.NextResult()); } execute.Dispose(); _Connector.Disconnect(); return(onCallTechs); } //connects to server, runs query Select * from OnCallTechs and returns a list of OnCallTechs objects
public IEnumerable <Phaco> Get() { List <Phaco> phacos = new List <Phaco>(); _Connector.Connect(); MySqlCommand execute = new MySqlCommand("SELECT * FROM Scope;", _Connector.database); using (MySqlDataReader DataReader = execute.ExecuteReader()) { do { while (DataReader.Read()) { Phaco newPhaco = new Phaco(); for (int i = 0; i < DataReader.FieldCount; i++) { switch (DataReader.GetName(i)) { case "PhacoID": newPhaco.PhacoID = int.Parse(DataReader.GetValue(i).ToString()); break; case "Brand": newPhaco.Brand = (string)DataReader.GetValue(i); break; case "Model": newPhaco.Model = (string)DataReader.GetValue(i); break; case "PhacoName": newPhaco.PhacoName = (string)DataReader.GetValue(i); break; case "IsActive": newPhaco.IsActive = (bool)DataReader.GetValue(i); break; } } phacos.Add(newPhaco); } } while (DataReader.NextResult()); } execute.Dispose(); _Connector.Disconnect(); return(phacos); } //connects to server, runs query Select * from Phaco and returns a list of Phaco objects
public IEnumerable <Laser> Get() { List <Laser> lasers = new List <Laser>(); _Connector.Connect(); MySqlCommand execute = new MySqlCommand("SELECT * FROM Lens;", _Connector.database); using (MySqlDataReader DataReader = execute.ExecuteReader()) { do { while (DataReader.Read()) { Laser newLaser = new Laser(); for (int i = 0; i < DataReader.FieldCount; i++) { switch (DataReader.GetName(i)) { case "LenseID": newLaser.LaserID = int.Parse(DataReader.GetValue(i).ToString()); break; case "LenseName": newLaser.LaserName = (string)DataReader.GetValue(i); break; case "Brand": newLaser.Brand = (string)DataReader.GetValue(i); break; case "Model": newLaser.Model = (string)DataReader.GetValue(i); break; case "IsActive": newLaser.IsActive = (bool)DataReader.GetValue(i); break; } } lasers.Add(newLaser); } } while (DataReader.NextResult()); } execute.Dispose(); _Connector.Disconnect(); return(lasers); } //connects to server, runs query Select * from Laser and returns a list of Laser objects
public IEnumerable <Customer> Get() { List <Customer> customers = new List <Customer>(); _Connector.Connect(); MySqlCommand execute = new MySqlCommand("SELECT * FROM Customer;", _Connector.database); using (MySqlDataReader DataReader = execute.ExecuteReader()) { do { while (DataReader.Read()) { Customer newCustomer = new Customer(); for (int i = 0; i < DataReader.FieldCount; i++) { switch (DataReader.GetName(i)) { case "CustomerID": newCustomer.CustomerID = int.Parse(DataReader.GetValue(i).ToString()); break; case "SetupID": newCustomer.SetupID = int.Parse(DataReader.GetValue(i).ToString()); break; case "OnCallTechsID": newCustomer.OnCallTechsID = int.Parse(DataReader.GetValue(i).ToString()); break; } } customers.Add(newCustomer); } } while (DataReader.NextResult()); } execute.Dispose(); _Connector.Disconnect(); return(customers); } //connects to server, runs query Select * from Customer and returns a list of Customer objects