// BaseData class will be parent of VehicleData
public void InsertVehicle(Vehicle vehicle)
{
SqlConnection connection = ManageDatabaseConnection("Open");
try
{
using (SqlCommand sqlCommand = new SqlCommand("insert_vehicle", connection))
{
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add("@NumberPlate", SqlDbType.VarChar).Value = vehicle.NumberPlate;
sqlCommand.Parameters.Add("@IdUser", SqlDbType.Int).Value = vehicle.IdUser; // Hay que arregar esto..!!! Le falta idUser al objeto Vehicle..!!!!
sqlCommand.Parameters.Add("@Color", SqlDbType.VarChar).Value = vehicle.Color;
sqlCommand.Parameters.Add("@Type", SqlDbType.VarChar).Value = vehicle.Type;
sqlCommand.Parameters.Add("@IsApproved", SqlDbType.Bit).Value = vehicle.IsAproved;
sqlCommand.Parameters.Add("@IsActive", SqlDbType.Bit).Value = vehicle.HasCertificate;
//connection.Open();
sqlCommand.ExecuteNonQuery();
connection = ManageDatabaseConnection("Close");
}
}
catch (SqlException sqlException)
{
throw sqlException;
}
}
protected void btnAddCar_Click(object sender, EventArgs e)
{
VehicleData vehicleD = new VehicleData();
UserData user = new UserData();
User userInSession = user.getUserInSession("email");
userInSession = user.getUserInSession((string)Session["user"]);
int idUser = userInSession.Id;
bool isActive = true;
string type = ddlType.SelectedItem.Value;
SiCAP_GrupoCARARA.App_Domain.Vehicle car = new SiCAP_GrupoCARARA.App_Domain.Vehicle(plate.Text, idUser, color.Text, type , false, isActive);
vehicleD.InsertVehicle(car);
plate.Text = string.Empty;
color.Text = string.Empty;
ddlType.SelectedIndex = -1;
}
protected void btnAddCar_Click(object sender, EventArgs e)
{
VehicleData vehicleD = new VehicleData();
UserData user = new UserData();
User userInSession = user.getUserInSession("email");
userInSession = user.getUserInSession((string)Session["user"]);
int idUser = userInSession.Id;
bool isActive = true;
string type = ddlType.SelectedItem.Value;
SiCAP_GrupoCARARA.App_Domain.Vehicle car = new SiCAP_GrupoCARARA.App_Domain.Vehicle(plate.Text, idUser, color.Text, type, false, isActive);
vehicleD.InsertVehicle(car);
plate.Text = string.Empty;
color.Text = string.Empty;
ddlType.SelectedIndex = -1;
}
public List<Vehicle> readVehiclesOfUserFromDB(User user)
{
SqlConnection connection = ManageDatabaseConnection("Open");
List<Vehicle> lstVehiclesOfOneUser = new List<Vehicle>();
Vehicle vehicle;
try
{
using (SqlCommand sqlCommand = new SqlCommand("read_all_Vehicles_underOneUser", connection))
{
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add("@Username_Email", SqlDbType.VarChar).Value = user.Username;
SqlDataReader reader = sqlCommand.ExecuteReader();
while (reader.Read())
{
vehicle = new Vehicle((int)reader["IdVehicle"], (string)reader["NumberPlate"]);
lstVehiclesOfOneUser.Add(vehicle);
}
connection = ManageDatabaseConnection("Close");
}
}
catch (SqlException sqlException)
{
throw sqlException;
}
return lstVehiclesOfOneUser;
}