public int InsertUpdateVehicle(Vehicle vehicle, int modo)
{
SqlCommand cmd = new SqlCommand("InsertarActualizarVehiculo", connectivity.Connection());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@VehicleID", vehicle.VehicleID);
cmd.Parameters.AddWithValue("@type", vehicle.type);
cmd.Parameters.AddWithValue("@brand", vehicle.brand);
cmd.Parameters.AddWithValue("@year", vehicle.year);
cmd.Parameters.AddWithValue("@engine", vehicle.engine);
cmd.Parameters.AddWithValue("@transmission", vehicle.transmission);
cmd.Parameters.AddWithValue("@fuel", vehicle.fuel);
cmd.Parameters.AddWithValue("@fueltank", vehicle.fueltank);
cmd.Parameters.AddWithValue("@created_at", vehicle.created_at);
cmd.Parameters.AddWithValue("@ConditionID", vehicle.ConditionID);
// 1= Add 2= Update
cmd.Parameters.AddWithValue("@Mode", modo);
connectivity.OpenConnection();
int i = cmd.ExecuteNonQuery();
cmd.Dispose();
connectivity.CloseConnection();
return(i);
}
public int InsertUpdateUser(User user, int modo)
{
SqlCommand cmd = new SqlCommand("InsertarActualizarUsuario", connectivity.Connection());
string ep = Helper.EncodePassword(string.Concat(user.UserID, user.passwd));
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserID", user.UserID);
cmd.Parameters.AddWithValue("@email", user.email);
cmd.Parameters.AddWithValue("@passwd", ep);
cmd.Parameters.AddWithValue("@remember_token", "laduchaliduchvsdlivubskdrvfbserkhb");
cmd.Parameters.AddWithValue("@name", user.name);
cmd.Parameters.AddWithValue("@lastname", user.lastname);
cmd.Parameters.AddWithValue("@dateofborn", user.dateofborn);
cmd.Parameters.AddWithValue("@nationality", user.nationality);
cmd.Parameters.AddWithValue("@phone", user.phone);
cmd.Parameters.AddWithValue("@created_at", user.created_at);
cmd.Parameters.AddWithValue("@updated_at", user.updated_at);
cmd.Parameters.AddWithValue("@ConditionID", user.ConditionID);
cmd.Parameters.AddWithValue("@RoleID", user.RoleID);
cmd.Parameters.AddWithValue("@DriverLicenseID", user.DriverLicenseID);
// 1= Add 2= Update
cmd.Parameters.AddWithValue("@Mode", modo);
connectivity.OpenConnection();
int i = cmd.ExecuteNonQuery();
cmd.Dispose();
connectivity.CloseConnection();
return(i);
}
public int InsertUpdateRole(Role role, int modo)
{
SqlCommand cmd = new SqlCommand("InsertarActualizarRol", connectivity.Connection());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@RoleID", role.RoleID);
cmd.Parameters.AddWithValue("@title", role.title);
// 1= Add 2= Update
cmd.Parameters.AddWithValue("@Mode", modo);
connectivity.OpenConnection();
int i = cmd.ExecuteNonQuery();
cmd.Dispose();
connectivity.CloseConnection();
return(i);
}
public int InsertUpdateDriverLicense(Driverlicense license, int modo)
{
SqlCommand cmd = new SqlCommand("InsertarActualizarCondicion", connectivity.Connection());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@DriverlicenseID", license.DriverlicenseID);
cmd.Parameters.AddWithValue("@description", license.description);
// 1= Add 2= Update
cmd.Parameters.AddWithValue("@Mode", modo);
connectivity.OpenConnection();
int i = cmd.ExecuteNonQuery();
cmd.Dispose();
connectivity.CloseConnection();
return(i);
}
public int InsertUpdateTravel(Travel travel, int modo)
{
SqlCommand cmd = new SqlCommand("InsertarActualizarViaje", connectivity.Connection());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@TravelID", travel.TravelID);
cmd.Parameters.AddWithValue("@UserID", travel.UserID);
cmd.Parameters.AddWithValue("@VehicleID", travel.VehicleID);
cmd.Parameters.AddWithValue("@ConditionID", travel.ConditionID);
cmd.Parameters.AddWithValue("@created_at", travel.created_at);
// 1= Add 2= Update
cmd.Parameters.AddWithValue("@Mode", modo);
connectivity.OpenConnection();
int i = cmd.ExecuteNonQuery();
cmd.Dispose();
connectivity.CloseConnection();
return(i);
}
public int InsertLocation(Location location)
{
SqlCommand cmd = new SqlCommand("InsertarLocalizacion", connectivity.Connection());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@TravelID", location.TravelID);
cmd.Parameters.AddWithValue("@name", location.name);
cmd.Parameters.AddWithValue("@address", location.address);
cmd.Parameters.AddWithValue("@latitude", location.latitude);
cmd.Parameters.AddWithValue("@longitude", location.longitude);
connectivity.OpenConnection();
int i = cmd.ExecuteNonQuery();
cmd.Dispose();
connectivity.CloseConnection();
return(i);
}
