/// <summary>
/// ����һ������
/// </summary>
public int Add(Vehicle model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("if not exists(select * from Vehicle where frameNO = @FrameNO) insert into Vehicle(");
strSql.Append("VehicleID,FrameNO,VehicleType,VehiclePrice,StartUseDate,KeepPerson,BackupKeyPerson,PlanScrapDate,OrganID,ChargePerson,SuperChargePerson,Photo,ObjectGroup,InputBy,IsPrivate)");
strSql.Append(" values (");
strSql.Append("@VehicleID,@FrameNO,@VehicleType,@VehiclePrice,@StartUseDate,@KeepPerson,@BackupKeyPerson,@PlanScrapDate,@OrganID,@ChargePerson,@SuperChargePerson,@Photo,@ObjectGroup,@InputBy,@IsPrivate)");
SqlParameter[] parameters = {
new SqlParameter("@VehicleID", model.VehicleID==null?"":model.VehicleID),
new SqlParameter("@FrameNO", model.FrameNO),
new SqlParameter("@VehicleType", model.VehicleType==null?0:model.VehicleType),
new SqlParameter("@VehiclePrice", model.VehiclePrice==null?0:model.VehiclePrice),
new SqlParameter("@StartUseDate", model.StartUseDate==null?DateTime.Parse("1900-1-1"):model.StartUseDate),
new SqlParameter("@KeepPerson", model.KeepPerson==null?"":model.KeepPerson),
new SqlParameter("@BackupKeyPerson", model.BackupKeyPerson==null?"":model.BackupKeyPerson),
new SqlParameter("@PlanScrapDate", model.PlanScrapDate==null?DateTime.Parse("1900-1-1"):model.PlanScrapDate),
new SqlParameter("@OrganID", model.OrganID),
new SqlParameter("@ChargePerson", model.ChargePerson==null?"":model.ChargePerson),
new SqlParameter("@SuperChargePerson", model.SuperChargePerson==null?"":model.SuperChargePerson),
new SqlParameter("@Photo", model.Photo==null?"":model.Photo),
new SqlParameter("@InputBy", model.InputBy),
new SqlParameter("@ObjectGroup", model.ObjectGroup==null?"":model.ObjectGroup),
new SqlParameter("@IsPrivate", model.IsPrivate==null?false:model.IsPrivate)
};
int obj = DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
return obj;
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <Model.Vehicle> DataTableToList(DataTable dt)
{
List <Model.Vehicle> modelList = new List <Model.Vehicle>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
Model.Vehicle model;
for (int n = 0; n < rowsCount; n++)
{
model = new Model.Vehicle();
if (dt.Rows[n]["ID"].ToString() != "")
{
model.ID = int.Parse(dt.Rows[n]["ID"].ToString());
}
model.VehicleID = dt.Rows[n]["VehicleID"].ToString();
model.FrameNO = dt.Rows[n]["FrameNO"].ToString();
if (dt.Rows[n]["VehicleType"].ToString() != "")
{
model.VehicleType = int.Parse(dt.Rows[n]["VehicleType"].ToString());
}
if (dt.Rows[n]["VehiclePrice"].ToString() != "")
{
model.VehiclePrice = decimal.Parse(dt.Rows[n]["VehiclePrice"].ToString());
}
if (dt.Rows[n]["StartUseDate"].ToString() != "")
{
model.StartUseDate = DateTime.Parse(dt.Rows[n]["StartUseDate"].ToString());
}
model.KeepPerson = dt.Rows[n]["KeepPerson"].ToString();
model.BackupKeyPerson = dt.Rows[n]["BackupKeyPerson"].ToString();
if (dt.Rows[n]["PlanScrapDate"].ToString() != "")
{
model.PlanScrapDate = DateTime.Parse(dt.Rows[n]["PlanScrapDate"].ToString());
}
if (dt.Rows[n]["OrganID"].ToString() != "")
{
model.OrganID = int.Parse(dt.Rows[n]["OrganID"].ToString());
}
if (dt.Rows[n]["IsPrivate"].ToString() != "")
{
model.IsPrivate = bool.Parse(dt.Rows[n]["IsPrivate"].ToString());
}
model.ChargePerson = dt.Rows[n]["ChargePerson"].ToString();
model.SuperChargePerson = dt.Rows[n]["SuperChargePerson"].ToString();
model.Photo = dt.Rows[n]["Photo"].ToString();
model.ObjectGroup = dt.Rows[n]["ObjectGroup"].ToString();
modelList.Add(model);
}
}
return(modelList);
}
/// <summary>
/// ��������б�
/// </summary>
public List<Model.Vehicle> DataTableToList(DataTable dt)
{
List<Model.Vehicle> modelList = new List<Model.Vehicle>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
Model.Vehicle model;
for (int n = 0; n < rowsCount; n++)
{
model = new Model.Vehicle();
if(dt.Rows[n]["ID"].ToString()!="")
{
model.ID=int.Parse(dt.Rows[n]["ID"].ToString());
}
model.VehicleID=dt.Rows[n]["VehicleID"].ToString();
model.FrameNO=dt.Rows[n]["FrameNO"].ToString();
if(dt.Rows[n]["VehicleType"].ToString()!="")
{
model.VehicleType=int.Parse(dt.Rows[n]["VehicleType"].ToString());
}
if(dt.Rows[n]["VehiclePrice"].ToString()!="")
{
model.VehiclePrice=decimal.Parse(dt.Rows[n]["VehiclePrice"].ToString());
}
if(dt.Rows[n]["StartUseDate"].ToString()!="")
{
model.StartUseDate=DateTime.Parse(dt.Rows[n]["StartUseDate"].ToString());
}
model.KeepPerson=dt.Rows[n]["KeepPerson"].ToString();
model.BackupKeyPerson=dt.Rows[n]["BackupKeyPerson"].ToString();
if(dt.Rows[n]["PlanScrapDate"].ToString()!="")
{
model.PlanScrapDate=DateTime.Parse(dt.Rows[n]["PlanScrapDate"].ToString());
}
if(dt.Rows[n]["OrganID"].ToString()!="")
{
model.OrganID=int.Parse(dt.Rows[n]["OrganID"].ToString());
}
if (dt.Rows[n]["IsPrivate"].ToString() != "")
{
model.IsPrivate = bool.Parse(dt.Rows[n]["IsPrivate"].ToString());
}
model.ChargePerson=dt.Rows[n]["ChargePerson"].ToString();
model.SuperChargePerson=dt.Rows[n]["SuperChargePerson"].ToString();
model.Photo = dt.Rows[n]["Photo"].ToString();
model.ObjectGroup = dt.Rows[n]["ObjectGroup"].ToString();
modelList.Add(model);
}
}
return modelList;
}
private Driver BuildDriver(Driver driver, Vehicle vehicle, bool includePicture = true)
{
//the idea is remove reference for improve
//client work without $ref
var created = new Driver
{
DriverId = driver.DriverId,
CarrierId = driver.CarrierId,
Name = driver.Name,
Phone = driver.Phone,
Picture = includePicture ? driver.Picture : null,
VehicleId = driver.VehicleId,
RatingAvg = driver.RatingAvg,
TotalRides = driver.TotalRides,
Vehicle = vehicle == null ? null : new Vehicle()
{
LicensePlate = vehicle.LicensePlate,
Make = vehicle.Make,
Model = vehicle.Model
}
};
return created;
}
private Ride BuildRide(Ride ride, string driverName, Vehicle vehicle, Employee employee)
{
var created = new Ride
{
CarrierId = ride.CarrierId,
Id = ride.Id,
Comments = ride.Comments,
Cost = ride.Cost,
Distance = ride.Distance,
Duration = ride.Duration,
EndAddress = ride.EndAddress,
StartAddress = ride.StartAddress,
EndDateTime = ride.EndDateTime,
StartDateTime = ride.StartDateTime,
StartLatitude = 10,
EndLatitude = 10,
StartLongitude = 10,
EndLongitude = 10,
Rating = ride.Rating,
RideId = ride.RideId,
VehicleId = ride.VehicleId,
Vehicle = vehicle == null ? null : new Vehicle()
{
LicensePlate = vehicle.LicensePlate,
Model = vehicle.Model,
Picture = vehicle.Picture,
Make = vehicle.Make,
Rate = vehicle.Rate
},
DriverId = ride.DriverId,
Driver = new Driver()
{
DriverId = ride.DriverId,
Name = driverName
},
EmployeeId = ride.EmployeeId,
Employee = employee == null ? null : new Employee()
{
EmployeeId = employee.EmployeeId,
Picture = employee.Picture,
Name = employee.Name
}
};
return created;
}
private static void CreateVehicleAndDriver_15(int carrierId, MyShuttleContext context)
{
var driver = new Driver
{
Name = "Austin Lumbert",
Phone = "555-48970",
Picture = GetNoMsDriver(5),
CarrierId = carrierId,
RatingAvg = 2,
TotalRides = Randomize.Next(50, 100),
};
context.Drivers.Add(driver);
context.SaveChanges();
var vehicle = new Vehicle
{
LicensePlate = "OUJ-6182",
Model = "G5",
Make = "Pontiac",
Type = VehicleType.Luxury,
Seats = 7,
VehicleStatus = VehicleStatus.Occupied,
DriverId = driver.DriverId,
Picture = GetVehicle(15),
Latitude = 47.641950,
Longitude = -122.167222,
CarrierId = carrierId,
Rate = Randomize.Next(1, 5),
RatingAvg = Randomize.Next(0, 5),
TotalRides = Randomize.Next(50, 100),
DeviceId = string.Empty
};
context.Vehicles.Add(vehicle);
context.SaveChanges();
}
private static void CreateVehicleAndDriver_11(int carrierId, MyShuttleContext context)
{
var driver = new Driver
{
Name = "James Rodriguez",
Phone = "555-48970",
Picture = GetNoMsDriver(1),
CarrierId = carrierId,
RatingAvg = 2,
TotalRides = Randomize.Next(50, 100),
};
context.Drivers.Add(driver);
context.SaveChanges();
var vehicle = new Vehicle
{
LicensePlate = "WWW-1256",
Model = "Dart",
Make = "Dodge",
Type = VehicleType.Luxury,
Seats = 7,
VehicleStatus = VehicleStatus.Occupied,
DriverId = driver.DriverId,
Picture = GetVehicle(11),
Latitude = 47.642944,
Longitude = -122.128222,
CarrierId = carrierId,
Rate = Randomize.Next(1, 5),
RatingAvg = Randomize.Next(0, 5),
TotalRides = Randomize.Next(50, 100),
DeviceId = "deviceVehicleSIM"
};
context.Vehicles.Add(vehicle);
context.SaveChanges();
}
private static void CreateVehicleAndDriver_09(int carrierId, MyShuttleContext context)
{
var driver = new Driver
{
Name = "S. Somasegar",
Phone = "555-48970",
Picture = GetDriver(9),
CarrierId = carrierId,
RatingAvg = Randomize.Next(0, 3),
TotalRides = Randomize.Next(50, 100),
};
context.Drivers.Add(driver);
context.SaveChanges();
var vehicle = new Vehicle
{
LicensePlate = "VVV-4444",
Model = "AveoLT",
Make = "Chevrolet",
Type = VehicleType.Van,
Seats = 7,
VehicleStatus = VehicleStatus.Free,
DriverId = driver.DriverId,
Picture = GetVehicle(9),
Latitude = 47.641964,
Longitude = -122.127212,
CarrierId = carrierId,
Rate = Randomize.Next(1, 5),
RatingAvg = Randomize.Next(0, 5),
TotalRides = Randomize.Next(50, 100),
DeviceId = "VVV-4444",
};
context.Vehicles.Add(vehicle);
context.SaveChanges();
}
private static void CreateVehicleAndDriver_07(int carrierId, MyShuttleContext context)
{
var driver = new Driver
{
Name = "Mitra Azizirad",
Phone = "555-48970",
Picture = GetDriver(7),
CarrierId = carrierId,
RatingAvg = 4.6,
TotalRides = Randomize.Next(50, 100),
};
context.Drivers.Add(driver);
context.SaveChanges();
var vehicle = new Vehicle
{
LicensePlate = "JOP-9876",
Model = "BLS",
Make = "Cadillac",
Type = VehicleType.Van,
Seats = 7,
VehicleStatus = VehicleStatus.Occupied,
DriverId = driver.DriverId,
Picture = GetVehicle(7),
Latitude = 47.631915,
Longitude = -122.127221,
CarrierId = carrierId,
Rate = Randomize.Next(1, 5),
RatingAvg = Randomize.Next(0, 5),
TotalRides = Randomize.Next(50, 100),
DeviceId = "JOP-9876",
};
context.Vehicles.Add(vehicle);
context.SaveChanges();
}
private static void CreateVehicleAndDriver_05(int carrierId, MyShuttleContext context)
{
var driver = new Driver
{
Name = "Scott Hanselman",
Phone = "555-48970",
Picture = GetDriver(5),
CarrierId = carrierId,
RatingAvg = 4.8,
TotalRides = Randomize.Next(50, 100),
};
context.Drivers.Add(driver);
context.SaveChanges();
var vehicle = new Vehicle
{
LicensePlate = "FGH-9876",
Model = "Volt2",
Make = "Chevrolet",
Type = VehicleType.Van,
Seats = 7,
VehicleStatus = VehicleStatus.Free,
DriverId = driver.DriverId,
Picture = GetVehicle(5),
Latitude = 47.631925,
Longitude = -122.127220,
CarrierId = carrierId,
Rate = Randomize.Next(1, 5),
RatingAvg = Randomize.Next(0, 5),
TotalRides = Randomize.Next(50, 100),
DeviceId = "FGH-9876"
};
context.Vehicles.Add(vehicle);
context.SaveChanges();
}
private static void CreateVehicleAndDriver_04(int carrierId, MyShuttleContext context)
{
var driver = new Driver
{
Name = "Beth Massi",
Phone = "555-1212",
Picture = GetDriver(4),
CarrierId = carrierId,
RatingAvg = 5,
TotalRides = Randomize.Next(90, 100),
};
context.Drivers.Add(driver);
context.SaveChanges();
var vehicle = new Vehicle
{
LicensePlate = "JNV-9876",
Model = "300C",
Make = "Chrysler",
Type = VehicleType.Luxury,
Seats = 7,
VehicleStatus = VehicleStatus.Free,
DriverId = driver.DriverId,
Picture = GetVehicle(4),
Latitude = 41.901172,
Longitude = -87.714014,
CarrierId = carrierId,
Rate = Randomize.Next(1, 5),
RatingAvg = 5,
TotalRides = Randomize.Next(50, 100),
DeviceId = "JNV-9876"
};
context.Vehicles.Add(vehicle);
context.SaveChanges();
}
/// <summary>
/// Deprecated Method for adding a new object to the Vehicles EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToVehicles(Vehicle vehicle)
{
base.AddObject("Vehicles", vehicle);
}
/// <summary>
/// Create a new Vehicle object.
/// </summary>
/// <param name="vIN">Initial value of the VIN property.</param>
/// <param name="make">Initial value of the Make property.</param>
/// <param name="model">Initial value of the Model property.</param>
/// <param name="color">Initial value of the Color property.</param>
/// <param name="condition">Initial value of the Condition property.</param>
/// <param name="serviceType">Initial value of the ServiceType property.</param>
/// <param name="seatingCapacity">Initial value of the SeatingCapacity property.</param>
public static Vehicle CreateVehicle(global::System.String vIN, global::System.String make, global::System.String model, global::System.String color, global::System.String condition, global::System.String serviceType, global::System.Int32 seatingCapacity)
{
Vehicle vehicle = new Vehicle();
vehicle.VIN = vIN;
vehicle.Make = make;
vehicle.Model = model;
vehicle.Color = color;
vehicle.Condition = condition;
vehicle.ServiceType = serviceType;
vehicle.SeatingCapacity = seatingCapacity;
return vehicle;
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Model.Vehicle model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.Vehicle model)
{
return(dal.Add(model));
}
private Vehicle BuildVehicle(Vehicle vehicle, Driver driver, Carrier carrier, double distanceFromGivenPosition = 0,
bool includePicture = true)
{
//the idea is remove reference for improve
//client work without $ref
var created = new Vehicle
{
VehicleId = vehicle.VehicleId,
CarrierId = vehicle.CarrierId,
Picture = includePicture ? vehicle.Picture : null,
DriverId = vehicle.DriverId,
LicensePlate = vehicle.LicensePlate,
DistanceFromGivenPosition = distanceFromGivenPosition,
Make = vehicle.Make,
Latitude = vehicle.Latitude,
Longitude = vehicle.Longitude,
Model = vehicle.Model,
Seats = vehicle.Seats,
Type = vehicle.Type,
VehicleStatus = vehicle.VehicleStatus,
Rate = vehicle.Rate,
RatingAvg = vehicle.RatingAvg,
TotalRides = vehicle.TotalRides,
DeviceId = vehicle.DeviceId,
Driver = driver == null ? null : new Driver()
{
DriverId = driver.DriverId,
Name = driver.Name,
Phone = driver.Phone
},
Carrier = carrier == null ? null : new Carrier()
{
Picture = carrier.Picture
},
};
return created;
}
private void SaveItem(object sender, EventArgs e)
{
if (CustomValidation())
{
var item = new Vehicle();
item.Name = textName.Text;
item.LicensePlate = textLicensePlate.Text;
item.Type = Convert.ToString(drlType.SelectedItem);
if (itemId > 0)
{
item.Id = itemId;
item.Created = created;
item.CreatedByUserId = createdBy;
item.Modified = DateTime.Now;
item.ModifiedByUserId = currentUser;
var biz = new VehicleBiz();
biz.UpdateItem(item);
}
else
{
item.Created = DateTime.Now;
item.CreatedByUserId = currentUser;
item.Modified = DateTime.Now;
item.ModifiedByUserId = currentUser;
var biz = new VehicleBiz();
biz.SaveItem(item);
}
this.Close();
}
else
{
this.DialogResult = System.Windows.Forms.DialogResult.None;
}
}
private static void CreateVehicleAndDriver_05(int carrierId, MyShuttleContext context)
{
var driver = new Driver
{
Name = "Jay Schmelzer",
Phone = "555-1212",
Picture = GetDriver(6),
CarrierId = carrierId,
RatingAvg = 5,
TotalRides = Randomize.Next(80, 90),
};
context.Drivers.Add(driver);
context.SaveChanges();
var vehicle = new Vehicle
{
LicensePlate = "ZUA-1456",
Model = "Caprice PPV",
Make = "Chevrolet",
Type = VehicleType.Van,
Seats = 7,
VehicleStatus = VehicleStatus.Free,
DriverId = driver.DriverId,
Picture = GetVehicle(6),
Latitude = 41.721172,
Longitude = -87.604014,
CarrierId = carrierId,
Rate = Randomize.Next(1, 5),
RatingAvg = Randomize.Next(0, 5),
TotalRides = Randomize.Next(50, 100),
DeviceId = "CUA-1456",
};
context.Vehicles.Add(vehicle);
context.SaveChanges();
}
private static void CreateVehicleAndDriver_06(int carrierId, MyShuttleContext context)
{
var driver = new Driver
{
Name = "Erich Gamma",
Phone = "555-48970",
Picture = GetDriver(6),
CarrierId = carrierId,
RatingAvg = Randomize.Next(0, 3),
TotalRides = Randomize.Next(50, 100),
};
context.Drivers.Add(driver);
context.SaveChanges();
var vehicle = new Vehicle
{
LicensePlate = "ZUA-1456",
Model = "Caprice PPV",
Make = "Chevrolet",
Type = VehicleType.Van,
Seats = 7,
VehicleStatus = VehicleStatus.Free,
DriverId = driver.DriverId,
Picture = GetVehicle(6),
Latitude = 47.631935,
Longitude = -122.127222,
CarrierId = carrierId,
Rate = Randomize.Next(1, 5),
RatingAvg = Randomize.Next(0, 5),
TotalRides = Randomize.Next(50, 100),
DeviceId = "CUA-1456",
};
context.Vehicles.Add(vehicle);
context.SaveChanges();
}
private static void CreateVehicleAndDriver_14(int carrierId, MyShuttleContext context)
{
var driver = new Driver
{
Name = "Alan Anderson",
Phone = "555-48970",
Picture = GetNoMsDriver(4),
CarrierId = carrierId,
RatingAvg = 2,
TotalRides = Randomize.Next(50, 100),
};
context.Drivers.Add(driver);
context.SaveChanges();
var vehicle = new Vehicle
{
LicensePlate = "WTW-6182",
Model = "G6",
Make = "Pontiac",
Type = VehicleType.Luxury,
Seats = 7,
VehicleStatus = VehicleStatus.Occupied,
DriverId = driver.DriverId,
Picture = GetVehicle(14),
Latitude = 41.151172,
Longitude = -87.914014,
CarrierId = carrierId,
Rate = Randomize.Next(1, 5),
RatingAvg = Randomize.Next(0, 5),
TotalRides = Randomize.Next(50, 100),
DeviceId = string.Empty
};
context.Vehicles.Add(vehicle);
context.SaveChanges();
}
private static void CreateVehicleAndDriver_08(int carrierId, MyShuttleContext context)
{
var driver = new Driver
{
Name = "Rob Caron",
Phone = "555-48970",
Picture = GetDriver(8),
CarrierId = carrierId,
RatingAvg = Randomize.Next(0, 3),
TotalRides = Randomize.Next(50, 100),
};
context.Drivers.Add(driver);
context.SaveChanges();
var vehicle = new Vehicle
{
LicensePlate = "HTY-1243",
Model = "ELR",
Make = "Cadilac",
Type = VehicleType.Van,
Seats = 7,
VehicleStatus = VehicleStatus.Occupied,
DriverId = driver.DriverId,
Picture = GetVehicle(8),
Latitude = 47.621954,
Longitude = -122.127212,
CarrierId = carrierId,
Rate = Randomize.Next(1, 5),
RatingAvg = Randomize.Next(0, 5),
TotalRides = Randomize.Next(50, 100),
DeviceId = "HTY-1243",
};
context.Vehicles.Add(vehicle);
context.SaveChanges();
}
private static void CreateVehicleAndDriver_18(int carrierId, MyShuttleContext context)
{
var driver = new Driver
{
Name = "Ibon Campa",
Phone = "555-48970",
Picture = GetNoMsDriver(10),
CarrierId = carrierId,
RatingAvg = 2,
TotalRides = Randomize.Next(50, 100),
};
context.Drivers.Add(driver);
context.SaveChanges();
var vehicle = new Vehicle
{
LicensePlate = "RTY-2345",
Model = "Riviera",
Make = "Buick",
Type = VehicleType.Luxury,
Seats = 7,
VehicleStatus = VehicleStatus.Occupied,
DriverId = driver.DriverId,
Picture = GetVehicle(18),
Latitude = 47.641944,
Longitude = -122.187212,
CarrierId = carrierId,
Rate = Randomize.Next(1, 5),
RatingAvg = Randomize.Next(0, 5),
TotalRides = Randomize.Next(50, 100),
DeviceId = "deviceVehicleLED"
};
context.Vehicles.Add(vehicle);
context.SaveChanges();
}
private static void CreateVehicleAndDriver_10(int carrierId, MyShuttleContext context)
{
var driver = new Driver
{
Name = "Scott Guthrie",
Phone = "555-48970",
Picture = GetDriver(10),
CarrierId = carrierId,
RatingAvg = 5,
TotalRides = Randomize.Next(50, 100),
};
context.Drivers.Add(driver);
context.SaveChanges();
var vehicle = new Vehicle
{
LicensePlate = "ERT-1256",
Model = "Caliber",
Make = "Dodge",
Type = VehicleType.Van,
Seats = 7,
VehicleStatus = VehicleStatus.Occupied,
DriverId = driver.DriverId,
Picture = GetVehicle(10),
Latitude = 48.641924,
Longitude = -122.127212,
CarrierId = carrierId,
Rate = Randomize.Next(1, 5),
RatingAvg = Randomize.Next(0, 5),
TotalRides = Randomize.Next(50, 100),
DeviceId = "ERT-1256",
};
context.Vehicles.Add(vehicle);
context.SaveChanges();
}
private static void CreateVehicleAndDriver_19(int carrierId, MyShuttleContext context)
{
var driver = new Driver
{
Name = "Carlos Rodriguez",
Phone = "555-48970",
Picture = GetNoMsDriver(9),
CarrierId = carrierId,
RatingAvg = 2,
TotalRides = Randomize.Next(50, 100),
};
context.Drivers.Add(driver);
context.SaveChanges();
var vehicle = new Vehicle
{
LicensePlate = "ERT-2345",
Model = "Impala LTZ",
Make = "Chevrolet",
Type = VehicleType.Luxury,
Seats = 7,
VehicleStatus = VehicleStatus.Occupied,
DriverId = driver.DriverId,
Picture = GetVehicle(19),
Latitude = 47.641944,
Longitude = -122.197232,
CarrierId = carrierId,
Rate = Randomize.Next(1, 5),
RatingAvg = Randomize.Next(0, 5),
TotalRides = Randomize.Next(50, 100),
DeviceId = string.Empty
};
context.Vehicles.Add(vehicle);
context.SaveChanges();
}
private static void CreateVehicleAndDriver_13(int carrierId, MyShuttleContext context)
{
var driver = new Driver
{
Name = "Aaron McDonall",
Phone = "555-48970",
Picture = GetNoMsDriver(3),
CarrierId = carrierId,
RatingAvg = 2,
TotalRides = Randomize.Next(50, 100),
};
context.Drivers.Add(driver);
context.SaveChanges();
var vehicle = new Vehicle
{
LicensePlate = "HUL-5678",
Model = "Aura XR",
Make = "Saturn",
Type = VehicleType.Luxury,
Seats = 7,
VehicleStatus = VehicleStatus.Occupied,
DriverId = driver.DriverId,
Picture = GetVehicle(13),
Latitude = 47.644944,
Longitude = -122.125222,
CarrierId = carrierId,
Rate = Randomize.Next(1, 5),
RatingAvg = Randomize.Next(0, 5),
TotalRides = Randomize.Next(50, 100),
DeviceId = "deviceVehicleRC"
};
context.Vehicles.Add(vehicle);
context.SaveChanges();
}
private static void CreateVehicleAndDriver_21(int carrierId, MyShuttleContext context)
{
var driver = new Driver
{
Name = "Andry Jackson",
Phone = "555-48970",
Picture = GetNoMsDriver(11),
CarrierId = carrierId,
RatingAvg = 2,
TotalRides = Randomize.Next(50, 100),
};
context.Drivers.Add(driver);
context.SaveChanges();
var vehicle = new Vehicle
{
LicensePlate = "WIE-4545",
Model = "Grand Prix",
Make = "Pontiac",
Type = VehicleType.Luxury,
Seats = 7,
VehicleStatus = VehicleStatus.Occupied,
DriverId = driver.DriverId,
Picture = GetVehicle(21),
Latitude = 47.641944,
Longitude = -122.327252,
CarrierId = carrierId,
Rate = Randomize.Next(1, 5),
RatingAvg = Randomize.Next(0, 5),
TotalRides = Randomize.Next(50, 100),
DeviceId = string.Empty
};
context.Vehicles.Add(vehicle);
context.SaveChanges();
}
private static void CreateVehicleAndDriver_16(int carrierId, MyShuttleContext context)
{
var driver = new Driver
{
Name = "Wendy Torre",
Phone = "555-48970",
Picture = GetNoMsDriver(14),
CarrierId = carrierId,
RatingAvg = 2,
TotalRides = Randomize.Next(50, 100),
};
context.Drivers.Add(driver);
context.SaveChanges();
var vehicle = new Vehicle
{
LicensePlate = "ERT-1289",
Model = "Regal",
Make = "Buick",
Type = VehicleType.Luxury,
Seats = 7,
VehicleStatus = VehicleStatus.Occupied,
DriverId = driver.DriverId,
Picture = GetVehicle(16),
Latitude = 47.641951,
Longitude = -122.177222,
CarrierId = carrierId,
Rate = Randomize.Next(1, 5),
RatingAvg = Randomize.Next(0, 5),
TotalRides = Randomize.Next(50, 100),
DeviceId = string.Empty
};
context.Vehicles.Add(vehicle);
context.SaveChanges();
}
private static void CreateVehicleAndDriver_01(int carrierId, MyShuttleContext context)
{
var driver = new Driver
{
Name = "Cesar de la Torre",
Phone = "555-178895",
Picture = GetDriver(1),
CarrierId = carrierId,
RatingAvg = 4.5,
TotalRides = Randomize.Next(50, 100),
};
context.Drivers.Add(driver);
context.SaveChanges();
var vehicle = new Vehicle
{
LicensePlate = "SLV-4335",
Model = "Pacifica",
Make = "Chrysler",
Type = VehicleType.Compact,
Seats = 4,
VehicleStatus = VehicleStatus.Occupied,
DriverId = driver.DriverId,
CarrierId = carrierId,
Picture = GetVehicle(1),
Latitude = 47.621931,
Longitude = -122.127232,
Rate = Randomize.Next(1, 5),
RatingAvg = Randomize.Next(0, 5),
TotalRides = Randomize.Next(50, 100),
DeviceId = "SLV-4335",
};
context.Vehicles.Add(vehicle);
context.SaveChanges();
}
/// <summary>
/// Return a vehicle dto.
/// </summary>
/// <param name="code"></param>
/// <returns></returns>
public async Task <IVehicleData> LoadValueAsync(string code)
{
if (string.IsNullOrEmpty(code))
{
throw new ArgumentNullException("Vehicle code cannot be null");
}
var vehicle = new Model.Vehicle();
var queryStore = queryStoreFactory.GetQueryStore();
using (var connection = _executor.OpenNewDbConnection())
{
if (connection != null)
{
var store = queryStore.AddParam(QueryType.QueryVehicleById, code);
var resultQuery = await connection.QueryFirstOrDefaultAsync <VehicleDto>(store.BuildQuery()).ConfigureAwait(false);
if (resultQuery == null)
{
throw new DataLayerException("Vehicle to be triggered!");
}
/// here in value i pass directly the dto for performance reasons. 3 conversions are too much.
vehicle.Value = resultQuery;
// vehicle.Value = _mapper.Map<VehiclePoco, VehicleDto>(resultQuery);
// ok here we have a valid way to do the query now. I need a new query store.
var auxQueryStore = AddParams(queryStoreFactory.GetQueryStore(), resultQuery);
try
{
var query = auxQueryStore.BuildQuery();
if (string.IsNullOrEmpty(query))
{
vehicle.Valid = false;
return(vehicle);
}
var multipleResult = await connection.QueryMultipleAsync(query).ConfigureAwait(false);
// FIXME: this is due to the fact the querystore doesnt support well yet duplicated keys.
var auxDuplicate = queryStoreFactory.GetQueryStore();
auxDuplicate.AddParamCount(QueryType.QuerySupplierSummaryById, resultQuery.CIALEAS);
auxDuplicate.AddParamCount(QueryType.QuerySupplierSummaryById, resultQuery.CIAADA3);
auxDuplicate.AddParamCount(QueryType.QuerySupplierSummaryById, resultQuery.CIAADA);
auxDuplicate.AddParamCount(QueryType.QuerySupplierSummaryById, resultQuery.CIAADA2);
auxDuplicate.AddParamCount(QueryType.QuerySupplierSummaryById, resultQuery.CIASEGU);
// auxDuplicate.AddParamCount(QueryType.Query, resultQuery.AGENTE);
var secondQuery = auxDuplicate.BuildQuery();
SqlMapper.GridReader secondResult = null;
if (!string.IsNullOrEmpty(secondQuery))
{
secondResult = await connection.QueryMultipleAsync(secondQuery).ConfigureAwait(false);
}
// assuarance
vehicle.Valid = ParseResult(vehicle, multipleResult, secondResult);
}
catch (System.Exception ex)
{
vehicle.Valid = false;
}
}
}
return(vehicle);
}
private static void CreateVehicleAndDriver_02(int carrierId, MyShuttleContext context)
{
var driver = new Driver
{
Name = "David Carmona",
Phone = "555-48970",
Picture = GetDriver(2),
CarrierId = carrierId,
RatingAvg = 4.6,
TotalRides = Randomize.Next(50, 100),
};
context.Drivers.Add(driver);
context.SaveChanges();
var vehicle = new Vehicle
{
LicensePlate = "MAX-9876",
Model = "Town Car",
Make = "Lincoln",
Type = VehicleType.Van,
Seats = 7,
VehicleStatus = VehicleStatus.Free,
DriverId = driver.DriverId,
Picture = GetVehicle(2),
Latitude = 47.621934,
Longitude = 122.127222,
CarrierId = carrierId,
Rate = Randomize.Next(1, 5),
RatingAvg = Randomize.Next(0, 5),
TotalRides = Randomize.Next(50, 100),
DeviceId = "MAX-9876"
};
context.Vehicles.Add(vehicle);
context.SaveChanges();
}
public async Task UpdateAsync(Vehicle vehicle)
{
_context.Vehicles.Update(vehicle);
await _context.SaveChangesAsync();
}
private static void CreateVehicleAndDriver_03(int carrierId, MyShuttleContext context)
{
var driver = new Driver
{
Name = "David Salgado",
Phone = "555-48970",
Picture = GetDriver(3),
CarrierId = carrierId,
RatingAvg = 3,
TotalRides = Randomize.Next(50, 100),
};
context.Drivers.Add(driver);
context.SaveChanges();
var vehicle = new Vehicle
{
LicensePlate = "ZCC-1432",
Model = "Taurus",
Make = "Ford",
Type = VehicleType.Van,
Seats = 7,
VehicleStatus = VehicleStatus.Occupied,
DriverId = driver.DriverId,
Picture = GetVehicle(3),
Latitude = 47.741924,
Longitude = 122.127222,
CarrierId = carrierId,
Rate = Randomize.Next(1, 5),
RatingAvg = Randomize.Next(0, 5),
TotalRides = Randomize.Next(50, 100),
DeviceId = "CCC-1432"
};
context.Vehicles.Add(vehicle);
context.SaveChanges();
}
public async Task<int> AddAsync(Vehicle vehicle)
{
_context.Vehicles.Add(vehicle);
await _context.SaveChangesAsync();
return vehicle.VehicleId;
}
private static void CreateVehicleAndDriver_04(int carrierId, MyShuttleContext context)
{
var driver = new Driver
{
Name = "Dmitry Lyalin",
Phone = "555-48970",
Picture = GetDriver(4),
CarrierId = carrierId,
RatingAvg = Randomize.Next(0, 4),
TotalRides = Randomize.Next(50, 100),
};
context.Drivers.Add(driver);
context.SaveChanges();
var vehicle = new Vehicle
{
LicensePlate = "JNV-9876",
Model = "300C",
Make = "Chrysler",
Type = VehicleType.Van,
Seats = 7,
VehicleStatus = VehicleStatus.Occupied,
DriverId = driver.DriverId,
Picture = GetVehicle(4),
Latitude = 47.841914,
Longitude = -122.127222,
CarrierId = carrierId,
Rate = Randomize.Next(1, 5),
RatingAvg = Randomize.Next(0, 5),
TotalRides = Randomize.Next(50, 100),
DeviceId = "JNV-9876"
};
context.Vehicles.Add(vehicle);
context.SaveChanges();
}
