void AddNewValet(string path)
{
Valet val = new Valet();
var auto = FindViewById <EditText>(Resource.Id.vpeditText1);
var date = FindViewById <TimePicker>(Resource.Id.vptimePicker1);
val.costo = 45;
val.date = date.ToString();
val.vehiculo = auto.Text;
val.nombre = "Valet Parking";
val.idemp = 1;
var db = new SQLiteAsyncConnection(path);
string comm = "SELECT id FROM Usuario WHERE correo= '" + loadData() + "';";
val.idcte = db.ExecuteScalarAsync <int>(comm).Result;
comm = "UPDATE Usuario SET saldo = saldo + " + val.costo + " WHERE correo = '" + loadData() + "';";
db.ExecuteAsync(comm);
if (db.InsertAsync(val).Result != 0)
{
db.UpdateAsync(val);
}
}
public Valet GetByUserId(int user_id)
{
Valet v = null;
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT valet_id, user_id, " +
"first_name, last_name " +
"FROM valets " +
"WHERE user_id = @user_id", conn);
cmd.Parameters.AddWithValue("@user_id", user_id);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows && reader.Read())
{
v = GetValetFromReader(reader);
}
}
}
catch (SqlException)
{
throw;
}
return(v);
}
private Valet GetValetFromReader(SqlDataReader reader)
{
Valet v = new Valet()
{
ValetId = Convert.ToInt32(reader["valet_id"]),
UserId = Convert.ToInt32(reader["user_id"]),
FirstName = Convert.ToString(reader["first_name"]),
LastName = Convert.ToString(reader["last_name"])
};
return(v);
}
public static void Main()
{
Valet valet = new Valet();
Input input = new Input();
log.Info("------Parking Management System------");
int choice;
bool exit = false;
do
{
log.Info("Enter your choice");
log.Info("1. Park Bike");
log.Info("2. Park Car");
log.Info("3. Take Bike");
log.Info("4. Take Car");
log.Info("5. Exit");
choice = input.TakeChoice();
switch (choice)
{
case 1:
input.parkBikeInput();
break;
case 2:
input.parkCarInput();
break;
case 3:
input.RemoveBikeInput();
break;
case 4:
input.RemoveCarInput();
break;
case 5:
exit = true;
break;
default:
log.Info("Please Enter a valid choice");
break;
}
} while (exit == false);
valet.displayBikeList();
log.Info("Aane k Liye Dhanyawaad");
Console.ReadKey();
}
public IActionResult Create(NewVehicle vehicleToCreate)
{
Valet currentValet = valetDAO.GetByUserId((int)GetCurrentUserId());
Vehicle createdVehicle = vehicleDAO.Create(vehicleToCreate, currentValet.ValetId);
if (createdVehicle == null)
{
return(BadRequest());
}
else
{
return(Created("", createdVehicle));
}
}
