private static model.Driver randomicDriver()
{
model.Driver d = new model.Driver();
string chars = "ABCDEFGHIJKLMNOPQRSTUVWXYZ";
for (int i = 0; i < 3; i++)
{
d.Label += new string(Enumerable.Repeat(chars, 1).Select(s => s[new Random().Next(26)]).ToArray());
}
Random label = new Random();
d.Label += label.Next(1000, 9999).ToString();
Random randomColor = new Random();
KnownColor[] names = (KnownColor[])Enum.GetValues(typeof(KnownColor));
KnownColor randomColorName = names[randomColor.Next(names.Length)];
d.Color = Color.FromKnownColor(randomColorName).Name;
d.Supplier = "Ford";
d.Model = "Fiesta";
return(d);
}
public static model.Driver CreateDriver(model.Driver driver)
{
model.Driver result = new model.Driver();
result = GetDriver(driver);
if (result.Id == 0)
{
List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >();
parameters.Add(new KeyValuePair <string, object>("@Color", driver.Color));
parameters.Add(new KeyValuePair <string, object>("@Label", driver.Label));
parameters.Add(new KeyValuePair <string, object>("@Model", driver.Model));
parameters.Add(new KeyValuePair <string, object>("@Supplier", driver.Supplier));
try
{
result.Id = (Int32)utils.DatabaseHelper.ExecuteNonQuery(
parameters,
"procDriver_Create",
new KeyValuePair <string, object>("@Id", driver.Id));
driver.Id = result.Id;
result = driver;
}
catch (Exception ex)
{
throw ex;
}
}
return(result);
}
public List <model.Driver> ListWorstDrivers()
{
List <model.Driver> result = new List <model.Driver>();
try
{
IDataReader reader = utils.DatabaseHelper.ExecuteReader(new List <KeyValuePair <string, object> >(), "procDriverTop10Worst_Read");
while (reader.Read())
{
badDriverModel.Driver d = new badDriverModel.Driver()
{
Color = reader["Color"].ToString(),
Id = (int)reader["Id"],
Incidents = new List <model.Incident>(),
Label = reader["Label"].ToString(),
Model = reader["Model"].ToString(),
Supplier = reader["Supplier"].ToString(),
IncidentQuantity = (int)reader["quantity"]
};
result.Add(d);
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
public static bool UpdateDriver(model.Driver driverToBeUpdated)
{
bool result = false;
List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >();
parameters.Add(new KeyValuePair <string, object>("@Id", driverToBeUpdated.Id));
parameters.Add(new KeyValuePair <string, object>("@Color", driverToBeUpdated.Color));
parameters.Add(new KeyValuePair <string, object>("@Label", driverToBeUpdated.Label));
parameters.Add(new KeyValuePair <string, object>("@Model", driverToBeUpdated.Model));
parameters.Add(new KeyValuePair <string, object>("@Supplier", driverToBeUpdated.Supplier));
try
{
utils.DatabaseHelper.ExecuteNonQuery(parameters, "procDriver_Update", null);
result = true;
}
catch (Exception ex)
{
throw ex;
}
finally { }
return(result);
}
public static List <model.Driver> ListWorstDrivers()
{
List <model.Driver> result = new List <model.Driver>();
foreach (var i in _apiService.ListWorstDrivers())
{
model.Driver d = new model.Driver();
d.Id = i.Id;
d.Color = i.Color;
d.Label = i.Label;
d.Model = i.Model;
d.Supplier = i.Supplier;
d.IncidentQuantity = i.IncidentQuantity;
result.Add(d);
}
return(result);
}
private static model.Driver GetDriver(model.Driver driver)
{
model.Driver result = new model.Driver();
List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >();
parameters.Add(new KeyValuePair <string, object>("@Color", driver.Color));
parameters.Add(new KeyValuePair <string, object>("@Label", driver.Label));
parameters.Add(new KeyValuePair <string, object>("@Model", driver.Model));
parameters.Add(new KeyValuePair <string, object>("@Supplier", driver.Supplier));
IDataReader reader = null;
try
{
using (reader = utils.DatabaseHelper.ExecuteReader(parameters, "procDriver_Read"))
{
if (reader.Read())
{
result.Id = (int)reader["Id"];
result.Color = reader["Color"].ToString();
result.Label = reader["Label"].ToString();
result.Model = reader["Model"].ToString();
result.Supplier = reader["Supplier"].ToString();
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (reader.IsClosed == false)
{
reader.Close();
reader.Dispose();
}
}
return(result);
}
public static model.Driver GetDriverById(int id)
{
model.Driver result = new model.Driver();
List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >();
parameters.Add(new KeyValuePair <string, object>("@id", id));
IDataReader reader = null;
try
{
using (reader = utils.DatabaseHelper.ExecuteReader(parameters, "procDriverId_read"))
{
if (reader.Read())
{
result.Id = (int)reader["Id"];
result.Color = reader["color"].ToString();
result.Label = reader["label"].ToString();
result.Model = reader["model"].ToString();
result.Supplier = reader["supplier"].ToString();
}
}
}
catch (Exception)
{
throw;
}
finally
{
if (reader.IsClosed == false)
{
reader.Close();
reader.Dispose();
}
}
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();
}
public static bool UpdateDriver(model.Driver driverToBeUpdated)
{
return(domain.Driver.UpdateDriver(driverToBeUpdated));
}
public static model.Driver CreateDriver(model.Driver driver)
{
return(domain.Driver.CreateDriver(driver));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!this.Page.User.Identity.IsAuthenticated)
{
FormsAuthentication.RedirectToLoginPage();
}
HtmlForm form = (HtmlForm)Master.FindControl("form1");
form.Attributes.Add("class", "dropzone");
if (IsPostBack)
{
model.Driver driver = new model.Driver();
if (driver.Id == 0)
{
driver.Color = ColorDropdownlist.Text;
driver.Label = LabelTextbox.Text;
driver.Model = Request["ModelSelect"];
driver.Supplier = Request["SupplierSelect"];
driver.Incidents.Add(new model.Incident()
{
Latitude = Request.Form["latitudeTextBox"].ToString(),
Longitude = Request.Form["longitudeTextBox"].ToString(),
DriverId = driver.Id,
UserId = (int)Session["UserId"]
});
}
int i = 0;
string savePath = string.Empty;
string saveFile = string.Empty;
model.Photo p = new model.Photo();
foreach (var s in Request.Files.AllKeys)
{
i++;
savePath = string.Empty;
saveFile = string.Empty;
HttpPostedFile file = Request.Files[s];
int fileSizeInBytes = file.ContentLength;
string fileName = file.FileName;
string fileExtension = string.Empty;
if (string.IsNullOrEmpty(fileName) == false)
{
fileExtension = Path.GetExtension(fileName);
}
savePath = Path.Combine(Request.PhysicalApplicationPath, dir, driver.Id.ToString());
saveFile = Path.Combine(savePath, i.ToString(), fileExtension);
file.SaveAs(saveFile);
p = new model.Photo()
{
IncidentId = driver.Incidents[0].Id,
Name = fileName,
Url = saveFile
};
}
driver.Incidents[0].Photos.Add(p);
//driver = domain.Driver.CreateDriver(driver);
}
}