public ActionResult DeleteVehicle(VehicleDetails vehicle)
{
var toDelete = _carDealer.GetVehicleById(vehicle.VehicleId);
_carDealer.Deletevehicle(toDelete.VehicleId);
return(RedirectToAction("Vehicles"));
}
public Response UpdateVehicleDetails(VehicleDetails obj)
{
List <VehicleDetails> vehicleList = new List <VehicleDetails>();
var IsExist = entities.vehicles.Where(x => x.vehicleId == obj.vehicleId).ToList();
if (IsExist.Count != 0)
{
var vehicleObj = entities.vehicles.Where(x => x.vehicleId == obj.vehicleId).FirstOrDefault();
vehicleObj.vehicleId = obj.vehicleId;
vehicleObj.partyId = obj.partyId;
vehicleObj.vehicleType = obj.vehicleType;
vehicleObj.vehicleNo = obj.vehicleNo;
vehicleObj.tareWeight = obj.tareWeight;
vehicleObj.updatedBy = "Admin";
vehicleObj.updatedOn = DateTime.Now;
entities.SaveChanges();
return(new Response {
IsSuccess = true, Message = "Data Successfully Updated "
});
}
else
{
return new Response {
IsSuccess = false, Message = "Updation Error. Contact Administrator"
}
};
}
/// <summary>
/// Inherit Add Vehicle To Park Method.
/// </summary>
/// <param name="parking"></param>
/// <returns></returns>
public VehicleDetails AddVehicleToParking(Parking parking)
{
try
{
VehicleDetails vehicleDetails = new VehicleDetails();
using (this.connection)
{
SqlCommand command = new SqlCommand("spParkVehicle", this.connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@VehicleNumber", parking.VehicleNumber);
command.Parameters.AddWithValue("@ParkingType", parking.ParkingType);
command.Parameters.AddWithValue("@DriverType", parking.DriverType);
command.Parameters.AddWithValue("@VehicleType", parking.VehicleType);
command.Parameters.AddWithValue("@SlotNumber", parking.SlotNumber);
this.connection.Open();
int result = command.ExecuteNonQuery();
this.connection.Close();
if (result != 0)
{
vehicleDetails = this.GetVehicleByVehicleNumber(parking.VehicleNumber);
return(vehicleDetails);
}
return(null);
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public void DeleteVehiclePositionTest()
{
VehicleDetails vehicleDetails = new VehicleDetails()
{
Temperature = 1,
Humidity = 1
};
Vehicle vehicle = Services.AddVehicle(vehicleDetails);
Assert.IsNotNull(vehicle);
VehiclePosDetails vehiclePosDetails = new VehiclePosDetails()
{
VehicleId = vehicle.Id,
Longitude = 50,
Latitude = 100
};
VehiclePos vehiclePosAdded = PosServices.AddVehiclePosition(vehiclePosDetails);
Assert.IsNotNull(vehiclePosAdded);
int deletedVehiclePosId = PosServices.DeleteVehiclePosition(vehiclePosAdded.Id);
Assert.AreEqual(deletedVehiclePosId, vehiclePosAdded.Id);
VehiclePos vehiclePos = PosServices.GetVehiclePosition(vehiclePosAdded.Id);
Assert.IsNull(vehiclePos);
}
public void UpdateVehiclePositionTest()
{
VehicleDetails vehicleDetails = new VehicleDetails()
{
Temperature = 1,
Humidity = 1
};
Vehicle vehicle = Services.AddVehicle(vehicleDetails);
Assert.IsNotNull(vehicle);
VehiclePosDetails vehiclePosDetails = new VehiclePosDetails()
{
VehicleId = vehicle.Id,
Longitude = 50,
Latitude = 100
};
VehiclePos vehiclePosAdded = PosServices.AddVehiclePosition(vehiclePosDetails);
Assert.IsNotNull(vehiclePosAdded);
vehiclePosDetails = new VehiclePosDetails()
{
VehicleId = vehicle.Id,
Longitude = 500,
Latitude = 1000
};
VehiclePos vehiclePosUpdated = PosServices.AddVehiclePosition(vehiclePosDetails);
Assert.IsNotNull(vehiclePosUpdated);
Assert.AreEqual(vehiclePosUpdated.Id, vehicle.Id);
Assert.AreEqual(vehiclePosUpdated.Longitude, 500);
Assert.AreEqual(vehiclePosUpdated.Latitude, 1000);
}
private void printVehicleDetails()
{
Console.Clear();
bool isValidInput = false;
do
{
try
{
getLicensePlate(out string licensePlate);
Validation.IsNumbersString(licensePlate);
if (m_garage.VehicleExist(licensePlate) == true)
{
VehicleDetails vehicleToPrint = m_garage.GetVehicleDetails(licensePlate);
Console.WriteLine(vehicleToPrint.ToString());
Console.WriteLine("Press enter to continue");
Console.ReadLine();
}
else
{
Console.WriteLine("There is no vehicle with that license plate");
}
isValidInput = true;
}
catch (FormatException fe)
{
Console.WriteLine(fe.Message);
}
}while(isValidInput == false);
}
public void GetVehiclePositionsTest()
{
VehicleDetails vehicleDetails = new VehicleDetails()
{
Temperature = 1,
Humidity = 1
};
Vehicle vehicle = Services.AddVehicle(vehicleDetails);
Assert.IsNotNull(vehicle);
VehiclePosDetails vehiclePosDetails = new VehiclePosDetails()
{
VehicleId = vehicle.Id,
Longitude = 50,
Latitude = 100
};
VehiclePos vehiclePos1 = PosServices.AddVehiclePosition(vehiclePosDetails);
Assert.IsNotNull(vehiclePos1);
vehiclePosDetails = new VehiclePosDetails()
{
VehicleId = vehicle.Id,
Longitude = 500,
Latitude = 1000
};
VehiclePos vehiclePos2 = PosServices.AddVehiclePosition(vehiclePosDetails);
Assert.IsNotNull(vehiclePos2);
List <VehiclePos> vehiclePositions = PosServices.GetVehiclePositions(vehicle.Id);
Assert.IsNotNull(vehiclePositions);
Assert.IsTrue(vehiclePositions.Contains(vehiclePos1));
Assert.IsTrue(vehiclePositions.Contains(vehiclePos2));
}
public ActionResult AddVehicle(VehicleDetails VehicleDetail, FormCollection collection)
{
try
{
VehicleDetail.SchoolID = _OrgnisationID;
VehicleDetail.FinancialYearID = _Financialyearid;
VehicleDetail.CreatedBy = WebSecurity.CurrentUserName;
if (collection["btntype"].ToUpper() == "Save".ToUpper())
{
VehicleDetail.Action = "INS";
}
else if (collection["btntype"].ToUpper() == "Update".ToUpper())
{
VehicleDetail.Action = "UPD";
}
int res = BALObj.InsertUpdateVehicleDetails(VehicleDetail);
if (res < 0)
{
TempData[Constants.MessageInfo.WARNING] = "Vehicle is already exists.";
}
else if (res == 0)
{
TempData[Constants.MessageInfo.WARNING] = "Unable to " + collection["btntype"].ToLower();
}
else
{
TempData[Constants.MessageInfo.SUCCESS] = res + ((res == 1) ? " record " : " records ") + collection["btntype"].ToLower() + " successfully.";
}
}
catch (Exception ex)
{
ExecptionLogger.FileHandling("Transport(AddVehicle_Post)", "Error_014", ex, "Transport");
}
return(RedirectToAction("VehicleMaster"));
}
private VehicleDetails makeNewVehicle(string i_LicensePlate)
{
bool newVehicleWasMade = false;
VehicleDetails newVehicle = new VehicleDetails();
do
{
try
{
chooseVehicleType(out string vehicleType);
newVehicle.Vehicle = VehicleMaker.MakeNewVehicle(i_LicensePlate, vehicleType);
newVehicleWasMade = true;
}
catch (FormatException fe)
{
Console.WriteLine(fe.Message);
}
catch (ValueOutOfRangeException ve)
{
Console.WriteLine(string.Format("{0}, Please insert value between {1} - {2}", ve.ToString(), ve.MinValue, ve.MaxValue));
}
}while(newVehicleWasMade == false);
return(newVehicle);
}
public void ShouldHavePartitionKey()
{
var vehicleDetails = new VehicleDetails();
var condition = vehicleDetails.PartitionKey == "VehicleDetail";
Assert.True(condition);
}
public ActionResult SaveVehicles(string vehicleId, string partyId, string vehicleType, string vehicleNo, string tareWeight)
{
if (vehicleId == "" || vehicleId == null)
{
vehicleId = "0";
}
Response res = new Response();
List <object> resultList = new List <object>();
var vehicleFlag = Int32.Parse(vehicleId);
VehicleDetails vehicle = new VehicleDetails();
vehicle.vehicleId = Int32.Parse(vehicleId);
vehicle.partyId = Int32.Parse(partyId);
vehicle.vehicleType = vehicleType;
vehicle.vehicleNo = vehicleNo;
vehicle.tareWeight = float.Parse(tareWeight);
if (vehicleFlag == 0)
{
res = masterDal.SaveVehicleDetails(vehicle);
}
else
{
res = masterDal.UpdateVehicleDetails(vehicle);
}
resultList.Add(res);
resultList.Add(GetAllVehicles());
return(Json(resultList, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// To Add vehicle to Parking.
/// </summary>
/// <param name="vehicleDetails"></param>
/// <returns></returns>
public Parking AddVehicleToParking(VehicleDetails vehicleDetails)
{
try
{
using (this.con)
{
SqlCommand cmd = new SqlCommand("spPark", this.con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@VehicleNumber", vehicleDetails.VehicleNumber);
cmd.Parameters.AddWithValue("@ParkingType", vehicleDetails.ParkingType);
cmd.Parameters.AddWithValue("@DriverType", vehicleDetails.DriverType);
cmd.Parameters.AddWithValue("@VehicleType", vehicleDetails.VehicleType);
cmd.Parameters.AddWithValue("@SlotNumber", vehicleDetails.SlotNumber);
this.con.Open();
var result = cmd.ExecuteNonQuery();
this.con.Close();
return(this.FindVehicleByVehicleNumber(vehicleDetails.VehicleNumber));
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
/// <summary>
/// Retourne la liste filtrée des véhicules.
/// Photos optionnelles.
/// </summary>
/// <param name="vehicleFilters"></param>
/// <param name="withPics"></param>
/// <returns></returns>
public static List <VehicleDetails> GetVehicleByFilter(SlctdFilters vehicleFilters, bool withPics = true)
{
List <VehicleDetails> _vehicleToReturn = new List <VehicleDetails>();
try
{
DalVehicle.VehicleFilters _vehicleFilters = new DalVehicle.VehicleFilters();
_vehicleFilters.StartDate = vehicleFilters.StartDate;
_vehicleFilters.EndDate = vehicleFilters.EndDate;
_vehicleFilters.OfficeName = vehicleFilters.OfficeName;
_vehicleFilters.MakeName = vehicleFilters.MakeName;
_vehicleFilters.FuelName = vehicleFilters.FuelName;
_vehicleFilters.DoorsCount = vehicleFilters.DoorsCount;
DataTable _table = DalVehicle.GetVehiclesByFilter(_vehicleFilters);
if (_table != null)
{
if (_table.Rows.Count != 0)
{
foreach (DataRowView row in _table.DefaultView)
{
VehicleDetails temp = new VehicleDetails();
VehicleType vehicleType = new VehicleType();
// temp.VehicleId = (int)row["Id"];
temp.OfficeName = row["Office_name"].ToString();
temp.DailyPrice = (decimal)row["DailyPrice"];
// Ajout des caracteristiques "type"
vehicleType.Id = (int)row["VehicleType_Id"];
vehicleType.MakeName = row["Make_name"].ToString();
vehicleType.ModelName = row["Model_Name"].ToString();
vehicleType.FuelName = row["Fuel_Name"].ToString();
vehicleType.CCName = row["CC_Name"].ToString();
vehicleType.DoorsCount = (byte)row["Doors_Count"];
temp.VehicleType = vehicleType;
// récup des images.
if (withPics == true)
{
List <Picture> pics = Getpics(vehicleType.Id);
if (pics != null)
{
temp.Pictures = pics;
}
}
_vehicleToReturn.Add(temp);
}
}
}
return(_vehicleToReturn);
}
#region Catch
catch (CstmEx cstmEx)
{
throw new CstmEx(ExType.dtaRead, cstmEx);
}
catch (Exception ex)
{
throw new CstmEx(ExType.srvrError, ex);
}
#endregion Catch
}
public Response SaveVehicleDetails(VehicleDetails obj)
{
List <VehicleDetails> vehicleList = new List <VehicleDetails>();
var IsExist = entities.vehicles.Where(x => x.vehicleNo == obj.vehicleNo).ToList();
if (IsExist.Count == 0)
{
vehicle vehicleObj = new vehicle();
vehicleObj.vehicleId = obj.vehicleId;
vehicleObj.partyId = obj.partyId;
vehicleObj.vehicleType = obj.vehicleType;
vehicleObj.vehicleNo = obj.vehicleNo;
vehicleObj.tareWeight = obj.tareWeight;
vehicleObj.createdBy = "Admin";
vehicleObj.createdOn = DateTime.Now;
vehicleObj.updatedBy = "Admin";
vehicleObj.updatedOn = DateTime.Now;
entities.vehicles.Add(vehicleObj);
entities.SaveChanges();
return(new Response {
IsSuccess = true, Message = "Data Successfully Inserted "
});
}
else
{
return new Response {
IsSuccess = false, Message = "Data already exists"
}
};
}
public VehicleDetails UnParkVehicle(int slotNumber)
{
try
{
VehicleDetails vehicleDetails = new VehicleDetails();
using (this.connection)
{
SqlCommand command = new SqlCommand("spUnParkVehicle", this.connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@SlotNumber", slotNumber);
this.connection.Open();
int result = command.ExecuteNonQuery();
this.connection.Close();
if (result != 0)
{
vehicleDetails = this.GetVehicleData(slotNumber);
return(vehicleDetails);
}
return(null);
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public ActionResult DeleteConfirmed(int id)
{
VehicleDetails vehicleDetails = db.VehicleDetails.Find(id);
db.VehicleDetails.Remove(vehicleDetails);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void Create_Vehicle_Success()
{
var vehicle = new Vehicle(VehicleDescription.Create(VehicleType.Car, "Volvo", new DateTime(1991, 1, 12)
, "White", "1.6", "X60", "Germany"),
VehicleDetails.Create(Fuel.Petrol, null, Body.Hatchback, 5, 5, false));
Assert.NotNull(vehicle);
}
public void OnResult(ZXing.Result result)
{
var barcode = result.Text;
//Mvx.Resolve<IToast>().Show(string.Format("Bar code = {0}", barcode));
var vehicleDetails = new VehicleDetails();
vehicleDetails.ParseQRCode(barcode);
ShowViewModel <VehicleDetailsViewModel>(vehicleDetails);
}
public MitchellClaim GetClaimType(string ClaimNumber)
{
MitchellClaim mitchclaim = new MitchellClaim();
using (MitchellClaimsDbEntities _db = new MitchellClaimsDbEntities())
{
var claimval = (from claim in _db.mitchellClaims
where claim.ClaimNumber == ClaimNumber
select claim).FirstOrDefault();
if (claimval != null)
{
LossInfo _info = null;
if (claimval.lossInfo != null)
{
_info = new LossInfo()
{
CauseOfLoss = (CauseOfLossCode)claimval.lossInfo.CauseOfLossId,
ReportedDate = (DateTime)claimval.lossInfo.ReportedDate,
LossDescription = claimval.lossInfo.LossDescription
};
}
List <VehicleDetails> _vehicles = new List <VehicleDetails>();
foreach (var item in claimval.vehicleInfoes)
{
VehicleDetails vehicle = new VehicleDetails()
{
Vin = item.Vin,
ModelYear = (int)item.ModelYear,
MakeDescription = item.MakeDescription,
ModelDescription = item.ModelDescription,
EngineDescription = item.EngineDescription,
ExteriorColor = item.ExteriorColor,
LicPlate = item.LicPlate,
LicPlateState = item.LicPlateState,
LicPlateExpDate = (DateTime)item.LicPlateExpDate,
DamageDescription = item.DamageDescription,
Mileage = (int)item.Mileage
};
_vehicles.Add(vehicle);
}
mitchclaim.ClaimNumber = claimval.ClaimNumber;
mitchclaim.ClaimantFirstName = claimval.ClaimantFirstName;
mitchclaim.ClaimantLastName = claimval.ClaimantLastName;
mitchclaim.Status = (StatusCode)claimval.Status;
mitchclaim.LossDate = (DateTime)claimval.LossDate;
mitchclaim.LossInfo = _info;
mitchclaim.AssignedAdjusterID = (int)claimval.AssignedAdjusterID;
mitchclaim.Vehicles = _vehicles;
}
return(mitchclaim);
}
}
public ActionResult Edit([Bind(Include = "vehicleDetailsID,make,model,year,vehicleID,sellerID")] VehicleDetails vehicleDetails)
{
if (ModelState.IsValid)
{
db.Entry(vehicleDetails).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.sellerID = new SelectList(db.Sellers, "sellerId", "sellerName", vehicleDetails.sellerID);
return(View(vehicleDetails));
}
public AddVehicleViewModel()
{
Vehicle = new VehicleDetails();
MakeType = new List <SelectListItem>();
ModelType = new List <SelectListItem>();
VehicleType = new List <SelectListItem>();
BodyType = new List <SelectListItem>();
TransmissionType = new List <SelectListItem>();
ColorOption = new List <SelectListItem>();
InteriorType = new List <SelectListItem>();
}
public void Init(VehicleDetails details)
{
if (details != null)
{
vehicleDetails = details;
}
else
{
vehicleDetails = new VehicleDetails();
}
}
public IHttpActionResult Get(int id)
{
VehicleDetails found = repo.GetVehicleById(id);
if (found == null)
{
return(NotFound());
}
return(Ok(found));
}
public void createVehicleDetailsTest()
{
VehicleDetails vehicleDetails = new VehicleDetails()
{
Temperature = 15,
Humidity = 5
};
Assert.AreEqual(vehicleDetails.Temperature, 15);
Assert.AreEqual(vehicleDetails.Humidity, 5);
}
public void UpdateVehicleTest2()
{
VehicleDetails vehicleDetails = new VehicleDetails()
{
Temperature = 10,
Humidity = 20
};
Vehicle vehicle = Services.UpdateVehicle(vehicleDetails, -1);
Assert.IsNull(vehicle);
}
/// <summary>
/// Implements Method.
/// </summary>
/// <param name="vehicle"></param>
/// <returns></returns>
public VehicleDetails ParkVehicle(Parking vehicle)
{
VehicleDetails parking = this.parkingRepository.AddVehicleToParking(vehicle);
if (parking != null)
{
this.mSMQService.AddToQueue(parking.RoleType + " Parked Vehicle Having Number: " + parking.VehicleNumber + " At Time : " + parking.EntryTime);
}
return(parking);
}
/// <summary>
/// Check whether the vehicle is insured as per the insurance system.
/// </summary>
/// <param name="veh"></param>
/// <returns></returns>
public static bool IsVehicleInsured(Vehicle veh)
{
if (veh.Exists())
{
Traffic_Policer.EVehicleDetailsStatus insurancestatus = VehicleDetails.GetInsuranceStatusForVehicle(veh);
return(insurancestatus == EVehicleDetailsStatus.Valid);
}
else
{
return(true);
}
}
//some fields....
public object Clone()
{
return(new Foo()
{
Zipcode = Zipcode,
StateCode = StateCode,
SalesData = SalesData == null ? null : SalesData.Copy(),
OtherDataTable = OtherDataTable == null ? null : OtherDataTable.Copy(),
VehicleDetails = VehicleDetails.Clone() as VehicleDetails,
VehicleCondition = VehicleCondition.Clone() as VehicleCondition,
});
}
public void DBCreateVehicles(VehicleDetails newVehicle, int vehicleListID)
{
try
{
using (NpgsqlConnection connection = new NpgsqlConnection(connectionString))
{
connection.Open();
string query =
" INSERT INTO VehicleInfo (ListID, ModelYear, MakeDescription, ModelDescription, EngineDescription, ExteriorColor, Vin, LicPlate, LicPlateState, LicPlateExpDate, DamageDescription, Mileage) " +
" VALUES (:ListID, :ModelYear, :MakeDescription, :ModelDescription, :EngineDescription, :ExteriorColor, :Vin, :LicPlate, :LicPlateState, :LicPlateExpDate, :DamageDescription, :Mileage); ";
using (NpgsqlCommand command = new NpgsqlCommand(query, connection))
{
command.Parameters.Add(new NpgsqlParameter("ListID", NpgsqlDbType.Integer));
command.Parameters.Add(new NpgsqlParameter("ModelYear", NpgsqlDbType.Integer));
command.Parameters.Add(new NpgsqlParameter("MakeDescription", NpgsqlDbType.Varchar));
command.Parameters.Add(new NpgsqlParameter("ModelDescription", NpgsqlDbType.Varchar));
command.Parameters.Add(new NpgsqlParameter("EngineDescription", NpgsqlDbType.Varchar));
command.Parameters.Add(new NpgsqlParameter("ExteriorColor", NpgsqlDbType.Varchar));
command.Parameters.Add(new NpgsqlParameter("Vin", NpgsqlDbType.Varchar));
command.Parameters.Add(new NpgsqlParameter("LicPlate", NpgsqlDbType.Varchar));
command.Parameters.Add(new NpgsqlParameter("LicPlateState", NpgsqlDbType.Varchar));
command.Parameters.Add(new NpgsqlParameter("LicPlateExpDate", NpgsqlDbType.Date));
command.Parameters.Add(new NpgsqlParameter("DamageDescription", NpgsqlDbType.Varchar));
command.Parameters.Add(new NpgsqlParameter("Mileage", NpgsqlDbType.Integer));
command.Parameters[0].Value = vehicleListID;
command.Parameters[1].Value = newVehicle.ModelYear;
command.Parameters[2].Value = newVehicle.MakeDescription;
command.Parameters[3].Value = newVehicle.ModelDescription;
command.Parameters[4].Value = newVehicle.EngineDescription;
command.Parameters[5].Value = newVehicle.ExteriorColor;
command.Parameters[6].Value = newVehicle.Vin;
command.Parameters[7].Value = newVehicle.LicPlate;
command.Parameters[8].Value = newVehicle.LicPlateState;
command.Parameters[9].Value = newVehicle.LicPlateExpDate;
command.Parameters[10].Value = newVehicle.DamageDescription;
command.Parameters[11].Value = newVehicle.Mileage;
command.ExecuteNonQuery();
}
}
}
catch (Exception ex)
{
// Error handling
Console.WriteLine("Error in DBCreateVehicles: " + ex.Message);
}
finally
{
}
}
public VehicleDetails UnParkVehicle(int slotNumber)
{
VehicleDetails vehicleDetails = this.parkingRepository.UnParkVehicle(slotNumber);
if (vehicleDetails != null)
{
TimeSpan timeDifference = vehicleDetails.ExitTime.Subtract(vehicleDetails.EntryTime);
this.mSMQService.AddToQueue(vehicleDetails.RoleType + " UnParked Vehicle Having Number: " + vehicleDetails.VehicleNumber + " At Exit Time : " + vehicleDetails.ExitTime + " Total Parking Time : " + (int)timeDifference.TotalMinutes + " Minute " + " And Parking Charge : Rs. " + vehicleDetails.ParkingCharge);
}
return(vehicleDetails);
}
