/// <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(); }