public bool InsertVechicleDetails(Vechicle ObjVechicle)
{
string ConnectionString = ConfigurationManager.ConnectionStrings["MVCDemo1"].ConnectionString.ToString();
using (SqlConnection con = new SqlConnection(ConnectionString))
{
try
{
con.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO [HEERA_TAXI]([DriverName],[vechicleNo],[vechicleModel],[Rating]) VALUES(@DriverName,@vechicleNo,@vechicleModel,@Rating)", con);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@DriverName", ObjVechicle.DriverName);
cmd.Parameters.AddWithValue("@vechicleNo", ObjVechicle.vechicleNo);
cmd.Parameters.AddWithValue("@vechicleModel", ObjVechicle.vechicleModel);
cmd.Parameters.AddWithValue("@Rating", ObjVechicle.Rating);
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
return(true);
}
finally
{
con.Close();
}
}
}
public EditVehicle(Vechicle vechicle)
{
InitializeComponent();
connection = DependencyService.Get <ISQLiteDb>().GetConnection();
_selectedVechicle = vechicle;
GetData(vechicle);
}
public bool HasSeats(Vechicle Car)
{
if (Car.LeftSeats == 0)
{
return(false);
}
return(true);
}
public bool ProvideASeat(Vechicle car)
{
if (car.LeftSeats > 0 && car.LeftSeats <= car.MaxOfferSeats)
{
car.LeftSeats--;
return(true);
}
return(false);
}
public bool DedeuctASeat(Vechicle Car)
{
if (Car.LeftSeats > 0)
{
Car.LeftSeats++;
return(true);
}
return(false);
}
private static void ExecuteAction(Vechicle vehicle, string commandToken, double parameter)
{
switch (commandToken)
{
case "Drive":
var result = vehicle.TryDrive(parameter);
Console.WriteLine(result);
break;
case "Refuel":
vehicle.Refuel(parameter);
break;
}
}
private async void Add(object sender, EventArgs e)
{
var vehicleNo = VehcileNo.Text;
var ownerName = OwnerName.Text;
var vehicle = new Vechicle
{
VechileNo = vehicleNo,
OwnerName = ownerName
};
await connection.InsertAsync(vehicle);
var mainPage = Application.Current.MainPage as MasterDetailPage;
mainPage.Detail = new NavigationPage(new VehicleList());
}
public ActionResult Index(FormCollection frmCollection)
{
VechicleDataLayer objData = new VechicleDataLayer();
Vechicle Objvech = new Vechicle
{
DriverName = frmCollection["DriverName"].ToString(),
Rating = frmCollection["Rating"].ToString(),
vechicleModel = frmCollection["vechicleModel"].ToString(),
vechicleNo = frmCollection["vechicleNo"].ToString()
};
bool Response = objData.InsertVechicleDetails(Objvech);
if (Response)
{
ViewBag.Message = "Vehicle details added succesfully";
}
else
{
ViewBag.Message = "Internal error occured";
}
return(View());
}
public SpecialOffer(Vechicle vehicle) : base(vehicle)
{
}
public VechicleDecorator(Vechicle vehicle)
{
this._vehicle = vehicle;
}
private async void GetData(Vechicle vechicle)
{
VehcileNo.Text = vechicle.VechileNo.ToString();
OwnerName.Text = vechicle.OwnerName.ToString();
}
private void VechicleSelector_SelectedIndexChanged(object sender, EventArgs e)
{
var picker = (Picker)sender;
_selectedVehicle = (Vechicle)picker.SelectedItem;
}
static void Main(string[] args)
{
List <Vechicle> cars = new List <Vechicle>();
List <Vechicle> trucks = new List <Vechicle>();
double averageCars = 0;
double averageTrucs = 0;
string cmd;
while ((cmd = Console.ReadLine()) != "End")
{
string[] cmdArgs = cmd.Split().ToArray();
string type = cmdArgs[0];
string model = cmdArgs[1];
string color = cmdArgs[2];
int hp = int.Parse(cmdArgs[3]);
Vechicle vechicle = new Vechicle(type, model, color, hp);
if (type == "car")
{
cars.Add(vechicle);
averageCars += hp;
}
else
{
trucks.Add(vechicle);
averageTrucs += hp;
}
}
while ((cmd = Console.ReadLine()) != "Close the Catalogue")
{
string model = cmd;
if (cars.Find(x => x.Model == model) != null)
{
int indexModel = cars.FindIndex(x => x.Model == model);
Console.WriteLine($"Type: Car");
Console.WriteLine($"Model: {cars[indexModel].Model}");
Console.WriteLine($"Color: {cars[indexModel].Color}");
Console.WriteLine($"Horsepower: {cars[indexModel].HorsePower}");
}
else
{
int indexModel = trucks.FindIndex(x => x.Model == model);
Console.WriteLine($"Type: Truck");
Console.WriteLine($"Model: {trucks[indexModel].Model}");
Console.WriteLine($"Color: {trucks[indexModel].Color}");
Console.WriteLine($"Horsepower: {trucks[indexModel].HorsePower}");
}
}
if (averageCars / cars.Count > 0 && averageTrucs / trucks.Count > 0)
{
Console.WriteLine($"Cars have average horsepower of: {averageCars / cars.Count:f2}.");
Console.WriteLine($"Trucks have average horsepower of: {averageTrucs / trucks.Count:f2}.");
}
else if (averageTrucs / trucks.Count > 0 && averageCars / cars.Count <= 0)
{
Console.WriteLine($"Trucks have average horsepower of: {averageTrucs / trucks.Count:f2}.");
}
else if (averageCars / cars.Count > 0 && averageTrucs / trucks.Count <= 0)
{
Console.WriteLine($"Cars have average horsepower of: {averageCars / cars.Count:f2}.");
}
}
public void RejectARequest(Booking booking, Vechicle car)
{
booking.BookingStatus = BookingStatus.REJECTED;
new VechicleService().DedeuctASeat(car);
}
