public static int InsertIncident(model.Incident incident) { int result = 0; result = domain.Driver.InsertIncident(incident); return(result); }
public static int InsertIncident(model.Incident incident) { int result = 0; List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >(); parameters.Add(new KeyValuePair <string, object>("@Latitude", incident.Latitude)); parameters.Add(new KeyValuePair <string, object>("@Longitude", incident.Longitude)); parameters.Add(new KeyValuePair <string, object>("@UserId", incident.UserId)); parameters.Add(new KeyValuePair <string, object>("@DriverId", incident.DriverId)); try { result = (int)utils.DatabaseHelper.ExecuteNonQuery( parameters, "procIncident_create", new KeyValuePair <string, object>("@id", result)); } catch (Exception ex) { throw ex; } if (incident.Photos.Count > 0) { foreach (var photo in incident.Photos) { parameters.Clear(); parameters.Add(new KeyValuePair <string, object>("@Name", photo.Name)); parameters.Add(new KeyValuePair <string, object>("@Url", photo.Url)); parameters.Add(new KeyValuePair <string, object>("@IncidentId", result)); try { utils.DatabaseHelper.ExecuteNonQuery(parameters, "procPhoto_Create", new KeyValuePair <string, object>("@Id", photo.Id)); } catch (Exception) { throw; } } } return(result); }
private static void testDriverFeatures() { // Create Driver model.Driver driverToBeCreated = new model.Driver() { Color = "Black", Label = "FOH5698", Model = "Sentra", Supplier = "Nissan" }; driverToBeCreated = service.Driver.CreateDriver(driverToBeCreated); // Get Driver model.Driver driverToBeGot = service.Driver.GetDriverById(1); // Update Driver model.Driver driverToBeUpdated = driverToBeGot; bool driverUpdated = false; Console.WriteLine("Driver Getted / To Be Updated Color [BEFORE CHANGE COLOR]: {0}", driverToBeUpdated.Color); driverToBeUpdated.Color = (driverToBeGot.Color == "Black") ? "White" : "Black"; Console.WriteLine("Driver Getted / To Be Updated Color [AFTER CHANGE COLOR]: {0}", driverToBeUpdated.Color); driverUpdated = service.Driver.UpdateDriver(driverToBeUpdated); Console.WriteLine("Driver Updated: {0}", driverUpdated); driverToBeUpdated = service.Driver.GetDriverById(driverToBeUpdated.Id); Console.WriteLine("Driver new color: {0}", driverToBeUpdated.Color); // Insert incident for Driver model.Incident incident = new model.Incident() { Latitude = "-23.6152779", Longitude = "-46.7043542", UserId = id, DriverId = driverToBeUpdated.Id, Photos = new List <model.Photo>() }; incident.Photos.Add( new badDriverModel.Photo() { Name = "badDriverSample01.jpg", Url = @"\badDriverSample01.jpg", }); incident.Photos.Add( new badDriverModel.Photo() { Name = "badDriverSample02.jpg", Url = @"\badDriverSample02.jpg", }); int incidentInserted = service.Driver.InsertIncident(incident); Console.WriteLine("Incident inserted id: {0}", incidentInserted); // Insert more than 1 incident for Driver Console.WriteLine("######################################"); Console.WriteLine("Insert more than 1 incident for Driver"); Random random = new Random(); int randomNext = random.Next(3, 10); model.Driver newDriver = randomicDriver(); newDriver = service.Driver.CreateDriver(newDriver); for (int i = 1; i <= randomNext; i++) { model.Incident inc = new model.Incident() { Latitude = "-23.6152779", Longitude = "-46.7043542", UserId = id, Photos = new List <model.Photo>(), DriverId = newDriver.Id }; inc.Photos.Add( new badDriverModel.Photo() { Name = "badDriverSample01.jpg", Url = @"\badDriverSample01.jpg", }); inc.Photos.Add( new badDriverModel.Photo() { Name = "badDriverSample02.jpg", Url = @"\badDriverSample02.jpg", }); incidentInserted = service.Driver.InsertIncident(inc); incident.Id = incidentInserted; Console.WriteLine("{0} from {1} Incident(s) inserted(s) to driver id {2}, incident id: {3}", i, randomNext, newDriver.Id, incidentInserted); newDriver.Incidents.Add(incident); } // List Driver List <model.Driver> drivers = new List <model.Driver>(); drivers = service.Driver.ListDrivers(); // Path for photos List <model.Photo> photos = new List <model.Photo>(); Console.WriteLine(AppDomain.CurrentDomain.BaseDirectory.Replace(@"bin\Debug", string.Empty)); // List Driver Photos List <model.Photo> driverPhotos = new List <model.Photo>(); foreach (var i in newDriver.Incidents) { Console.WriteLine("For Driver ID {0} we have {1} Incidents", driverToBeGot.Id, driverToBeGot.Incidents.Count()); foreach (var p in i.Photos) { Console.WriteLine("----- Photo ID {0}, URL {1} and Name {2}", p.Id, p.Url, p.Name); } } // List total Drivers Console.WriteLine("List total Drivers : {0}", service.Driver.ListDriversCount()); // Listing worst drivers foreach (var d in service.Driver.ListWorstDrivers()) { Console.WriteLine("Listing worst Drivers {0} - {1} {2}", d.Id, d.Label, d.Model); } Console.ReadKey(); }