public static List <VEHICLE> GetAllUnsoldVehiclesForDealer(string DealershipName)
{
List <VEHICLE> retval = null;
using (Mongo mongo = new Mongo(config.BuildConfiguration()))
{
mongo.Connect();
var db = mongo.GetDatabase(VehicleRecords.VEHICLE_DB.DataBaseName);
IMongoCollection <Document> collVehicles = db.GetCollection <Document>(VEHICLE.TableName);
Document qDealer = new Document();
qDealer["DEALERSHIP_NAME"] = DealershipName;
qDealer["STILL_FOR_SALE"] = "YES";
VEHICLE[] foundvehicles = VEHICLE.GetVEHICLEsFromQueryDocument(collVehicles, qDealer);
if (foundvehicles != null && foundvehicles.Count <VEHICLE>() > 0)
{
retval = foundvehicles.ToList <VEHICLE>();
}
mongo.Disconnect();
}
return(retval);
}
public static List <string> GetModelsForMake(string Make)
{
List <string> retval = new List <string>();
using (Mongo mongo = new Mongo(config.BuildConfiguration()))
{
mongo.Connect();
var db = mongo.GetDatabase(VehicleRecords.VEHICLE_DB.DataBaseName);
IMongoCollection <Document> collVehicles = db.GetCollection <Document>(VEHICLE.TableName);
Document qVehicles = new Document();
qVehicles["MAKE"] = Make;
qVehicles["STILL_FOR_SALE"] = "YES";
VEHICLE[] foundvehicles = VEHICLE.GetVEHICLEsFromQueryDocument(collVehicles, qVehicles);
if (foundvehicles != null && foundvehicles.Count <VEHICLE>() > 0)
{
var result = foundvehicles.GroupBy(vehicles => vehicles.MODEL.ToUpper())
.Select(grp => grp.First())
.ToList();
foreach (VEHICLE ModelExample in result.OrderBy(c => c.MODEL))
{
retval.Add(ModelExample.MODEL);
}
}
mongo.Disconnect();
}
return(retval);
}
public IHttpActionResult PutVEHICLE(string id, VEHICLE vEHICLE)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != vEHICLE.VEHICLE_REG)
{
return(BadRequest());
}
db.Entry(vEHICLE).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!VEHICLEExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
protected void btnSave_Click(object sender, EventArgs e)
{
var obj = new VEHICLE();
obj.VEHICLE_REGNO = popTxtReg.Text;
obj.VEHICLE_CODE = popTxtCode.Text;
obj.VEHICLE_TYPENO = popTxtTypNO.Text;
var cmd = new VehicleService(obj);
if (flag.Text.Equals("Add"))
{
obj.Action = ActionEnum.Create;
obj.CREATE_DATE = DateTime.Now;
obj.CREATE_EMPLOYEE_ID = 0;
obj.UPDATE_DATE = DateTime.Now;
obj.UPDATE_EMPLOYEE_ID = 0;
obj.SYE_DEL = true;
cmd.Add();
}
else
{
obj.Action = ActionEnum.Update;
obj.VEHICLE_ID = Convert.ToInt32(ViewState["VehicleID"].ToString());
obj.UPDATE_DATE = DateTime.Now;
obj.UPDATE_EMPLOYEE_ID = 0;
obj.SYE_DEL = true;
cmd.Edit();
}
ViewState["VehicleID"] = null;
Response.Redirect("SearchVehicle.aspx");
}
public VehicleModel UpdateVehicle(VehicleModel vehicleModel)
{
var resultSP = DB.UpdateVehicle(vehicleModel.vehicleNumber, vehicleModel.vehicleManufacturer, vehicleModel.vehicleColor, vehicleModel.vehicleOwnerId).Select(v => new VehicleModel
{
vehicleNumber = v.vehicleNumber,
vehicleManufacturer = v.vehicleManufacturer,
vehicleColor = v.vehicleColor,
vehicleOwnerId = v.vehicleOwnerId,
vehicleOwnerName = v.personFirstName + " " + v.personLastName
});
if (GlobalVariable.queryType == 0)
{
VEHICLE vehicle = DB.VEHICLES.Where(v => v.vehicleNumber.Equals(vehicleModel.vehicleNumber) || v.vehicleOwnerId.Equals(vehicleModel.vehicleOwnerId)).SingleOrDefault();
if (vehicle == null)
{
return(null);
}
vehicle.vehicleNumber = vehicleModel.vehicleNumber;
vehicle.vehicleManufacturer = vehicleModel.vehicleManufacturer;
vehicle.vehicleColor = vehicleModel.vehicleColor;
vehicle.vehicleOwnerId = vehicleModel.vehicleOwnerId;
DB.SaveChanges();
return(GetOneVehicleByNumber(vehicle.vehicleNumber));
}
else
{
return(resultSP.SingleOrDefault());
}
}
public VehicleModel AddVehicle(VehicleModel vehicleModel)
{
var resultSP = DB.AddVehicle(vehicleModel.vehicleNumber, vehicleModel.vehicleManufacturer, vehicleModel.vehicleColor, vehicleModel.vehicleOwnerId).Select(v => new VehicleModel
{
vehicleNumber = v.vehicleNumber,
vehicleManufacturer = v.vehicleManufacturer,
vehicleColor = v.vehicleColor,
vehicleOwnerId = v.vehicleOwnerId,
vehicleOwnerName = v.personFirstName + " " + v.personLastName
});
if (GlobalVariable.queryType == 0)
{
VEHICLE vehicle = new VEHICLE
{
vehicleNumber = vehicleModel.vehicleNumber,
vehicleManufacturer = vehicleModel.vehicleManufacturer,
vehicleColor = vehicleModel.vehicleColor,
vehicleOwnerId = vehicleModel.vehicleOwnerId
};
DB.VEHICLES.Add(vehicle);
DB.SaveChanges();
return(GetOneVehicleByNumber(vehicle.vehicleNumber));
}
else
{
return(resultSP.SingleOrDefault());
}
}
public ActionResult DeleteConfirmed(string id)
{
VEHICLE vEHICLE = db.VEHICLES.Find(id);
db.VEHICLES.Remove(vEHICLE);
db.SaveChanges();
return RedirectToAction("Index");
}
public IHttpActionResult PostVEHICLE(VEHICLE vEHICLE)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.VEHICLEs.Add(vEHICLE);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (VEHICLEExists(vEHICLE.VEHICLE_REG))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = vEHICLE.VEHICLE_REG }, vEHICLE));
}
public ActionResult DeleteConfirmed(double id)
{
VEHICLE vEHICLE = db.VEHICLEs.Find(id);
db.VEHICLEs.Remove(vEHICLE);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public static VEHICLE GetVehicleByVIN(string VIN)
{
VEHICLE retval = null;
using ()
return(retval);
}
public static void NoDamage(int entity)
{
ENTITY.SET_ENTITY_PROOFS(entity, true, true, true, true, true, true, true, true);
ENTITY.SET_ENTITY_INVINCIBLE(entity, true);
ENTITY.SET_ENTITY_CAN_BE_DAMAGED(entity, false);
VEHICLE.SET_VEHICLE_STRONG(entity, true);
VEHICLE.SET_VEHICLE_TYRES_CAN_BURST(entity, true);
VEHICLE.SET_VEHICLE_WHEELS_CAN_BREAK(entity, true);
}
public ActionResult Edit([Bind(Include = "vehicleid,transporterid,regno,vehicleno,vehicletypecode,bpid,dtmanufacture,active,kmlimit,createdon,modon,modby,effdt,loccode,isgpsinstalled,gps_install_date,remarks")] VEHICLE vEHICLE)
{
if (ModelState.IsValid)
{
db.Entry(vEHICLE).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(vEHICLE));
}
public ActionResult Edit([Bind(Include = "LICENSE_NUMBER,USER_ID,MAKE,MODEL,YEAR")] VEHICLE vEHICLE)
{
if (ModelState.IsValid)
{
db.Entry(vEHICLE).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
ViewBag.USER_ID = new SelectList(db.site_users, "user_id", "role_code", vEHICLE.USER_ID);
return View(vEHICLE);
}
public IHttpActionResult GetVEHICLE(string id)
{
VEHICLE vEHICLE = db.VEHICLEs.Find(id);
if (vEHICLE == null)
{
return(NotFound());
}
return(Ok(vEHICLE));
}
protected override EntityBase CreateAndBuildEntity(DataHelper.Framework.SafeDataReader dr)
{
VEHICLE theEntity = new VEHICLE();
theEntity.PK_ID = !dr.IsDBNull(0) ? dr.GetValue(0).ToString() : string.Empty;
theEntity.CHASIS_NUMBER = !dr.IsDBNull(1) ? dr.GetValue(1).ToString() : string.Empty;
theEntity.REGISTRATION_NUMBER_ENG = !dr.IsDBNull(2) ? dr.GetValue(2).ToString() : string.Empty;
theEntity.REGISTRATION_NUMBER_NEP = !dr.IsDBNull(3) ? dr.GetValue(3).ToString() : string.Empty;
theEntity.ENGINE_NUMBER = !dr.IsDBNull(4) ? dr.GetValue(4).ToString() : string.Empty;
theEntity.REGISTRATION_DAY = !dr.IsDBNull(5) ? dr.GetValue(5).ToString() : string.Empty;
theEntity.REGISTRATION_MONTH = !dr.IsDBNull(6) ? dr.GetValue(6).ToString() : string.Empty;
theEntity.REGISTRATION_YEAR = !dr.IsDBNull(7) ? dr.GetValue(7).ToString() : string.Empty;
theEntity.REGISTRATION_DATE = !dr.IsDBNull(8) ? dr.GetValue(8).ToString() : string.Empty;
theEntity.MANUFACTURE = !dr.IsDBNull(9) ? dr.GetValue(9).ToString() : string.Empty;
theEntity.VECHICLE_MODEL = !dr.IsDBNull(10) ? dr.GetValue(10).ToString() : string.Empty;
theEntity.MODEL_YEAR = !dr.IsDBNull(11) ? dr.GetValue(11).ToString() : string.Empty;
theEntity.VEHICLE_CATEGORY = !dr.IsDBNull(12) ? dr.GetValue(12).ToString() : string.Empty;
theEntity.VEHICLE_TYPE = !dr.IsDBNull(13) ? dr.GetValue(13).ToString() : string.Empty;
theEntity.VEHICLE_TYPE_DESCRIPTION = !dr.IsDBNull(14) ? dr.GetValue(14).ToString() : string.Empty;
theEntity.MAX_CARGO_CAPACITY = !dr.IsDBNull(15) ? dr.GetValue(15).ToString() : string.Empty;
theEntity.MAX_PASSENGER_CAPACITY = !dr.IsDBNull(16) ? dr.GetValue(16).ToString() : string.Empty;
theEntity.FUEL_TYPE = !dr.IsDBNull(17) ? dr.GetValue(17).ToString() : string.Empty;
theEntity.MAINTENANCE_INTERVAL_MONTH = !dr.IsDBNull(18) ? dr.GetValue(18).ToString() : string.Empty;
theEntity.MAINTENANCE_INTERVAL_KM = !dr.IsDBNull(19) ? dr.GetValue(19).ToString() : string.Empty;
theEntity.VECHICLE_USER = !dr.IsDBNull(20) ? dr.GetValue(20).ToString() : string.Empty;
theEntity.BASE_STATION = !dr.IsDBNull(21) ? dr.GetValue(21).ToString() : string.Empty;
theEntity.VEHICLE_STATUS = !dr.IsDBNull(22) ? dr.GetValue(22).ToString() : string.Empty;
return(theEntity);
}
public ActionResult Create([Bind(Include = "vehicleid,transporterid,regno,vehicleno,vehicletypecode,bpid,dtmanufacture,active,kmlimit,createdon,modon,modby,effdt,loccode,isgpsinstalled,gps_install_date,remarks")] VEHICLE vEHICLE)
{
if (ModelState.IsValid)
{
string strDDLValue = Request.Form["ddlVendors"].ToString();
vEHICLE.transporterid = Convert.ToInt16(strDDLValue);
db.VEHICLEs.Add(vEHICLE);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(vEHICLE));
}
public static void InsertVehicle(VEHICLE veh)
{
using (Mongo mongo = new Mongo(config.BuildConfiguration()))
{
mongo.Connect();
var db = mongo.GetDatabase(VehicleRecords.VEHICLE_DB.DataBaseName);
IMongoCollection <Document> collVehicle;
collVehicle = db.GetCollection <Document>(VEHICLE.TableName);
VEHICLE.InsertDocumentFromMEMBER(collVehicle, veh);
mongo.Disconnect();
}
}
// GET: Vehicles/Delete/5
public ActionResult Delete(string id)
{
if (id == null)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
VEHICLE vEHICLE = db.VEHICLES.Find(id);
if (vEHICLE == null)
{
return HttpNotFound();
}
return View(vEHICLE);
}
// GET: Vehicles/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
VEHICLE vEHICLE = db.VEHICLES.Find(id);
if (vEHICLE == null)
{
return HttpNotFound();
}
ViewBag.USER_ID = new SelectList(db.site_users, "user_id", "role_code", vEHICLE.USER_ID);
return View(vEHICLE);
}
// GET: Masters/VEHICLEs/Edit/5
public ActionResult Edit(double?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
VEHICLE vEHICLE = db.VEHICLEs.Find(id);
if (vEHICLE == null)
{
return(HttpNotFound());
}
return(View(vEHICLE));
}
public IHttpActionResult DeleteVEHICLE(string id)
{
VEHICLE vEHICLE = db.VEHICLEs.Find(id);
if (vEHICLE == null)
{
return(NotFound());
}
db.VEHICLEs.Remove(vEHICLE);
db.SaveChanges();
return(Ok(vEHICLE));
}
private void InitialDataPopup()
{
if (ViewState["VehicleID"] != null)
{
var cmd = new VehicleService();
_item = cmd.Select(Convert.ToInt32(ViewState["VehicleID"].ToString()));
if (_item != null)
{
popTxtCode.Text = _item.VEHICLE_CODE;
popTxtReg.Text = _item.VEHICLE_REGNO;
popTxtTypNO.Text = _item.VEHICLE_TYPENO;
flag.Text = "Edit";
}
}
}
public Vehicle VehicleToObject(VEHICLE item)
{
Vehicle newVehicle = new Vehicle()
{
IdVehicle = item.IdVehicle,
type = TypeVehicleToObject(item.TYPEVEHICLE),
capable = item.Capacity,
zone = ZoneToObject(item.ZONE),
Status = item.Status,
Mileage = item.Mileage,
Available = item.Available
};
return(newVehicle);
}
public static List <VEHICLE> GetVehiclesByMarketMakeModel(string market, string make, string model, string pricerange)
{
List <VEHICLE> retval = null;
using (Mongo mongo = new Mongo(config.BuildConfiguration()))
{
mongo.Connect();
var db = mongo.GetDatabase(VehicleRecords.VEHICLE_DB.DataBaseName);
IMongoCollection <Document> collPriceRange = db.GetCollection <Document>(PRICERANGE.TableName);
Document qPriceRange = new Document();
qPriceRange["VALUENAME"] = pricerange;
Document docPriceRange = collPriceRange.FindOne(qPriceRange);
PRICERANGE pr = PRICERANGE.GetPRICERANGEFromDocument(docPriceRange);
IMongoCollection <Document> collVehicles = db.GetCollection <Document>(VEHICLE.TableName);
Document qVehicles = new Document();
qVehicles["MARKET"] = market;
if (make.Length > 0 && make != "All")
{
qVehicles["MAKE"] = make;
}
if (model.Length > 0 && model != "All")
{
qVehicles["MODEL"] = model;
}
qVehicles["STILL_FOR_SALE"] = "YES";
string where = $"(this.CURRENT_PRICE >= {pr.LOWBOUND} && this.CURRENT_PRICE <= {pr.HIGHBOUND})";
qVehicles.Add("$where", new Code(where));
VEHICLE[] foundvehicles = VEHICLE.GetVEHICLEsFromQueryDocument(collVehicles, qVehicles);
if (foundvehicles != null && foundvehicles.Count <VEHICLE>() > 0)
{
retval = foundvehicles.ToList <VEHICLE>();
}
mongo.Disconnect();
}
return(retval);
}
public static void UpdateVehicleRecord(VEHICLE veh)
{
using (Mongo mongo = new Mongo(config.BuildConfiguration()))
{
mongo.Connect();
var db = mongo.GetDatabase(VehicleRecords.VEHICLE_DB.DataBaseName);
IMongoCollection <Document> collVehicles;
collVehicles = db.GetCollection <Document>(VEHICLE.TableName);
Document qVeh = new Document();
qVeh["VIN"] = veh.VIN;
collVehicles.Remove(qVeh);
VEHICLE.InsertDocumentFromMEMBER(collVehicles, veh);
mongo.Disconnect();
}
}
public int DeleteVehicleByOwnerId(string ownerId)
{
var resultSP = DB.DeleteVehicleByOwnerId(ownerId);
if (GlobalVariable.queryType == 0)
{
VEHICLE vehicle = DB.VEHICLES.Where(v => v.vehicleOwnerId.Equals(ownerId)).SingleOrDefault();
DB.VEHICLES.Attach(vehicle);
if (vehicle == null)
{
return(0);
}
DB.VEHICLES.Remove(vehicle);
DB.SaveChanges();
return(1);
}
else
{
return(resultSP);
}
}
public static VEHICLE GetVehicleByVIN(string VIN)
{
VEHICLE retval = null;
using (Mongo mongo = new Mongo(config.BuildConfiguration()))
{
mongo.Connect();
var db = mongo.GetDatabase(VehicleRecords.VEHICLE_DB.DataBaseName);
IMongoCollection <Document> collVehicles = db.GetCollection <Document>(VEHICLE.TableName);
var qVeh = new Document();
qVeh["VIN"] = VIN;
Document resultsdoc = collVehicles.FindOne(qVeh);
if (resultsdoc != null)
{
retval = VEHICLE.GetVEHICLEFromDocument(resultsdoc);
}
}
return(retval);
}
public static int SpawnVehicle(string vehName, bool intoVehicle = true)
{
int vehHash = GAMEPLAY.GET_HASH_KEY(vehName);
int newVec = 0;
STREAMING.REQUEST_MODEL(vehHash);
for (int i = 0; i < 100; i++)
{
if (STREAMING.HAS_MODEL_LOADED(vehHash))
{
int playerPed = PLAYER.PLAYER_PED_ID();
Vector3 myCoords = GetPosition();
newVec = VEHICLE.CREATE_VEHICLE(vehHash, myCoords.X, myCoords.Y, myCoords.Z, ENTITY.GET_ENTITY_HEADING(playerPed), true, true);
if (intoVehicle)
{
PED.SET_PED_INTO_VEHICLE(playerPed, newVec, -1);
}
STREAMING.SET_MODEL_AS_NO_LONGER_NEEDED(vehHash);
break;
}
}
return(newVec);
}
public static void Boost(float bst)
{
VEHICLE.SET_VEHICLE_FORWARD_SPEED(VEHICLE.GET_LAST_DRIVEN_VEHICLE(), bst);
}
public static void Fix()
{
VEHICLE.SET_VEHICLE_FIXED(VEHICLE.GET_LAST_DRIVEN_VEHICLE());
}
