private void AddVehicleRandom()
{
for (int i = 0; i < 4; ++i)
{
if (RandomSpawnNow())
{
Driver driver = WorldDrivers.GetRandomDriver();
VehicleSpecs vehicleSpecs = VehicleModels.GetRandomCar();
foreach (Junction junction in Junctions)
{
junction.Simulation.Roads[i].LeftLane.AddVehicleManual(driver, vehicleSpecs);
}
}
if (RandomSpawnNow())
{
Driver driver = WorldDrivers.GetRandomDriver();
VehicleSpecs vehicleSpecs = VehicleModels.GetRandomCar();
foreach (Junction junction in Junctions)
{
junction.Simulation.Roads[i].RightLane.AddVehicleManual(driver, vehicleSpecs);
}
}
}
}
public VehicleModels ReadByModelId(int makeId)
{
VehicleModels Model = new VehicleModels();
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("ReadByModelId", cn);
cmd.CommandType = CommandType.StoredProcedure;
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
VehicleModels currentModel = new VehicleModels();
currentModel.ModelId = (int)dr["ModelId"];
currentModel.Model = dr["Model"].ToString();
currentModel.DateAdded = (DateTime)dr["DateAdded"];
currentModel.EmployeeId = (int)dr["EmployeeId"];
Model = currentModel;
}
}
cn.Close();
}
return(Model);
}
/// <summary>
/// Service para inserir e atualizar
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public async Task <VehicleModels> PartialUpdate(VehicleModels entity)
{
try
{
IEnumerable <VehicleModels> vehicleList = await GetVehicle(entity.id);
VehicleModels vehicle = vehicleList.Where(v => v.id == entity.id).FirstOrDefault();
vehicle.marca = entity.marca;
vehicle.modelo = entity.modelo;
vehicle.ano = entity.ano;
vehicle.UpdateDate = DateTime.UtcNow;
using (var context = new Context())
{
context.Entry(vehicle).State = EntityState.Modified;
await context.SaveChangesAsync();
return(entity);
}
}
catch (Exception ex)
{
throw new CustomErrorException("Error insert", ex);
}
}
public IVehicle Create(VehicleModels iModelId, CVector3 vecPosition, CVector3 vecRotation, int color1, int color2, int color3, int color4, int respawn_delay)
{
ushort id = (ushort)Imports.Vehicles.Vehicles_Create((int)iModelId, vecPosition, vecRotation, color1, color2, color3, color4, respawn_delay);
return new Vehicle() {
VehicleId = id
};
}
public IEnumerable <VehicleModels> GetAll()
{
List <VehicleModels> models = new List <VehicleModels>();
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("ModelsGetAll", cn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Connection = cn;
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
VehicleModels currentRow = new VehicleModels();
currentRow.ModelID = (int)dr["ModelID"];
currentRow.Model = dr["Model"].ToString();
currentRow.MakeID = (int)dr["MakeID"];
currentRow.CreateDate = (DateTime)dr["CreateDate"];
currentRow.UserName = dr["UserName"].ToString();
models.Add(currentRow);
}
}
return(models);
}
}
public IEnumerable <VehicleModels> GetSelected(int makeID)
{
List <VehicleModels> models = new List <VehicleModels>();
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("ModelsGetSelected", cn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MakeID", makeID);
cmd.Connection = cn;
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
VehicleModels currentRow = new VehicleModels();
currentRow.ModelID = (int)dr["ModelID"];
currentRow.Model = dr["Model"].ToString();
models.Add(currentRow);
}
}
return(models);
}
}
public static int CreateModel(string name, string abrv)
{
var makeID = 1009;
List <VehicleMake> model = new List <VehicleMake>();
var dataId = LoadCarIdWithAbrv(abrv);
foreach (var row in dataId)
{
model.Add(new VehicleMake
{
Id = row.Id
});
makeID = row.Id;
}
VehicleModels data = new VehicleModels
{
MakeId = makeID,
Name = name,
Abrv = abrv
};
string sql = @"insert into dbo.VehicleModelT (MakeId, Name, Abrv) values (@MakeId, @Name, @Abrv);";
return(SqlDataAccess.SaveData(sql, data));
}
public async Task <IHttpActionResult> UpdateVehicle([FromBody] VehicleFrontModel model)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (model.id <= 0)
{
return(Ok("Para inserir o registro, utilize o protocolo POST"));
}
try
{
var entity = model.VehicleFront2Entity();
VehicleModels vehicle = null;
VehicleService vehicleService = new VehicleService();
vehicle = await vehicleService.InsertOrUpdate(entity);
return(Ok("ok"));
}
catch (CustomErrorException ex)
{
return(BadRequest(ex.Message));
}
catch (Exception ex)
{
return(InternalServerError(ex));
}
}
/// <summary>
/// Formato de saída do back para o front
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static GetOutModelFrontModel ModelEntity2Front(this VehicleModels model)
{
return(new GetOutModelFrontModel()
{
id = model.id,
name = model.modelo
});
}
/// <summary>
/// Formato de saída do back para o front
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static GetOutBrandFrontModel BrandEntity2Front(this VehicleModels model)
{
return(new GetOutBrandFrontModel()
{
id = model.id,
name = model.marca
});
}
/// <summary>
/// Formato de saída do back para o front
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static GetOutVersionFrontModel VersionEntity2Front(this VehicleModels model)
{
return(new GetOutVersionFrontModel()
{
id = model.id,
name = model.versao
});
}
private void addVehicleWESTRToolStripMenuItem_Click(object sender, EventArgs e)
{
Driver driver = WorldDrivers.GetRandomDriver();
VehicleSpecs vehicleSpecs = VehicleModels.GetRandomCar();
foreach (Junction junction in Junctions)
{
junction.Simulation.Roads[3].RightLane.AddVehicleManual(driver, vehicleSpecs);
}
}
private void mstrip_addWest_Click(object sender, EventArgs e)
{
Driver driver = WorldDrivers.GetRandomDriver();
VehicleSpecs vehicleSpecs = VehicleModels.GetRandomCar();
foreach (Junction junction in Junctions)
{
junction.Simulation.Roads[3].LeftLane.AddVehicleManual(driver, vehicleSpecs);
}
}
/// <summary>
/// Formato de saída do back para o front
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static VehicleFrontModel VehicleEntity2Front(this VehicleModels model)
{
return(new VehicleFrontModel()
{
id = model.id,
marca = model.marca,
modelo = model.modelo,
versao = model.versao,
ano = model.ano,
quilometragem = model.quilometragem,
observacao = model.observacao
});
}
public void CanAddModel()
{
var repo = new ModelRepositoryADO();
VehicleModels newModel = new VehicleModels()
{
Model = "Citation",
MakeID = 3,
UserName = "******"
};
repo.Add(newModel);
var models = repo.GetAll();
Assert.AreEqual(models.Count(), 6);
}
/// <summary>
/// Service para inserir e atualizar
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public async Task <VehicleModels> InsertOrUpdate(VehicleModels entity)
{
try
{
using (var context = new Context())
{
context.Entry(entity).State = entity.id == 0 ? EntityState.Added : EntityState.Modified;
await context.SaveChangesAsync();
return(entity);
}
}
catch (Exception ex)
{
throw new CustomErrorException("Error insert", ex);
}
}
public VehicleModels GetVehicleModel(int VehicleModelId)
{
VehicleModels result = new VehicleModels();
try
{
using (IDbConnection conn = GetConnection())
{
result = conn.Get <VehicleModels>(VehicleModelId);
}
}
catch (Exception ex)
{
logger.Error(ex);
}
return(result);
}
/// <summary>
/// Service para excluir
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public async Task <int> DeleteVehicle(int id)
{
try
{
using (var context = new Context())
{
VehicleModels vehicle = await context.Vehicle.Where(a => a.id == id).FirstOrDefaultAsync();
context.Entry(vehicle).State = EntityState.Deleted;
await context.SaveChangesAsync();
return(id);
}
}
catch (Exception ex)
{
throw new CustomErrorException("Error delete", ex);
}
}
public void UpdateModel(VehicleModels model)
{
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("UpdateModel", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@modelId", model.ModelId);
cmd.Parameters.AddWithValue("@model", model.Model);
//cmd.Parameters.AddWithValue("@dateAdded", model.DateAdded);
cmd.Parameters.AddWithValue("@employeeId", model.EmployeeId);
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
}
}
public static void Spawn(SharpBridge.Player player, object[] param)
{
string name = ((string)param[0]).ToUpper();
int vehModel = VehicleModels.getModelByName(name);
if (vehModel == -1)
{
player.sendMsg($"'{name}' is an invalid model", ChatColor.ERROR);
return;
}
int color = new Random().Next(0, 140);
Vector3 pos = player.getPos();
pos.z += 1.0f;
Vehicle veh = Entities.createVehicle(vehModel, pos, new Vector3(0.0f, 0.0f, player.getHeading()),
color, color, color, color, player.getWorld());
player.sendMsg($"{name} spawned: {veh.getId()}", ChatColor.SUCCESS);
}
private bool itemIsFiltered(ShortItemEntry item, bool withFirstMatching)
{
return((withFirstMatching || (string.IsNullOrEmpty(_filterString) || item.Description.ToLower().Contains(_filterString.ToLower()) || item.commentAs.ToLower().Contains(_filterString.ToLower()))) &&
(string.IsNullOrEmpty(_selectedBrand) || item.ManufacturerCode == _selectedBrand) &&
(string.IsNullOrEmpty(_selectedManufacture) ||
VehicleModels.Any(i => i.ItemNo_ == item.No_ && i.ManufacturerCode == _selectedManufacture)) &&
(string.IsNullOrEmpty(_selectedModelNo) ||
VehicleModels.Any(i => i.ItemNo_ == item.No_ && i.ModelNo_ == _selectedModelNo)) &&
//(string.IsNullOrEmpty(_selectedCabType) ||
// VehicleModels.Any(i => i.ItemNo_ == item.No_ && i.CabType == _selectedCabType)) &&
(!_selectedYearFrom.HasValue ||
VehicleModels.Any(i => i.ItemNo_ == item.No_ && i.ManufacturingStartDate.Year == _selectedYearFrom.Value)) &&
(string.IsNullOrEmpty(_selectedOeNumber) || (item.OeNumbers != null && item.OeNumbers.Any(i => i.ToUpper() == _selectedOeNumber.ToUpper()))) &&
(_selectedVehicleGroup == null || (item.VehicleGroups != null && item.VehicleGroups.Any(i => i.ToUpper() == _selectedVehicleGroup.No.ToUpper()))) &&
(!_selectedYearTo.HasValue ||
VehicleModels.Any(i => i.ItemNo_ == item.No_ && (i.ManufacturingEndDate.HasValue && i.ManufacturingEndDate.Value.Year == _selectedYearTo.Value))) &&
//(string.IsNullOrEmpty(_selectedEngline) ||
// VehicleModels.Any(i => i.ItemNo_ == item.No_ && i.Engine == _selectedEngline)) &&
(!WithBalance || (WithBalance && item.Quantity > 0)));
}
public void Add(VehicleModels model)
{
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand("AddModel", cn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter param = new SqlParameter("@ModelID", SqlDbType.Int);
param.Direction = ParameterDirection.Output;
cmd.Parameters.Add(param);
cmd.Parameters.AddWithValue("@Model", model.Model);
cmd.Parameters.AddWithValue("@MakeID", model.MakeID);
cmd.Parameters.AddWithValue("@UserName", model.UserName);
cn.Open();
cmd.ExecuteNonQuery();
model.ModelID = (int)param.Value;
}
}
public Response UpdateVehicleModel(VehicleModels vehicleModel)
{
Response response = new Response();
try
{
using (IDbConnection conn = GetConnection())
{
conn.Update <VehicleModels>(vehicleModel);
response.Description = "Record successfully updated";
response.Status = true;
}
}
catch (Exception ex)
{
response.Description = "System malfunction";
response.Status = false;
logger.Error(ex);
}
return(response);
}
public ActionResult AddModel(SalesIndexModelsCM form)
{
if (ModelState.IsValid)
{
VehicleModels model = new VehicleModels();
var repo = new VehicleModelRepositoryADO();
model.Model = form.Model;
model.Make = form.Make;
model.DateAdded = form.DateAdded;
model.EmployeeId = form.EmployeeId;
repo.CreateModel(model);
return(RedirectToAction("Index"));
}
else
{
SalesIndexModelsVM VM = new SalesIndexModelsVM();
var models = new VehicleModelRepositoryADO();
VM.Models = models.ReadAllModel();
VM.Form = form;
return(View(VM));
}
}
public Response UpdateVehicleModel([FromBody] VehicleModels vehicleModel)
{
return(repo.UpdateVehicleModel(vehicleModel));
}
public void UpdateModel(VehicleModels model)
{
throw new NotImplementedException();
}
public AddRecordResponse AddVehicleModel([FromBody] VehicleModels vehicleModel)
{
return(repo.AddVehicleModel(vehicleModel.VehicleModel));
}
public string GetVehicleName(VehicleModels iModelId)
{
return System.Runtime.InteropServices.Marshal.PtrToStringAnsi(Server.Server_GetVehicleName((int)iModelId));
}
