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); }