private static Transporte LoadTransporte(IDataReader dr) { var transporte = new Transporte { id = GetDataValue <int>(dr, "Id_Transporte"), IdProveedor = GetDataValue <int>(dr, "IdProveedor_Transporte"), Marca = GetDataValue <string>(dr, "Marca_Transporte"), Modelo = GetDataValue <string>(dr, "Modelo_Transporte"), Tara = GetDataValue <int>(dr, "tara_Transporte"), Patente = GetDataValue <string>(dr, "Patente_Transporte"), Descripcion = GetDataValue <string>(dr, "Descripcion_Transporte"), Titular = GetDataValue <string>(dr, "Titular_Transporte"), }; return(transporte); }
public Transporte SelectbyID(int id) { // WARNING! Performance const string sqlStatement = "SELECT [Id_empresa], [razonSocial_empresa], [NombreFantasia_empresa], [TipoContribuyente_empresa], [Tipo_empresa] FROM dbo.Transporte WHERE [Id_empresa]=@Id_empresa "; Transporte empresa = null; var db = DatabaseFactory.CreateDatabase(ConnectionName); using (var cmd = db.GetSqlStringCommand(sqlStatement)) { db.AddInParameter(cmd, "@Id_empresa", DbType.Int32, id); using (var dr = db.ExecuteReader(cmd)) { if (dr.Read()) { empresa = LoadTransporte(dr); } } } return(empresa); }
/// <summary> /// /// </summary> /// <param name="product"></param> public void UpdateById(Transporte transporte) { const string sqlStatement = "UPDATE [dbo].[Transporte] SET[IdProveedor_Transporte] = @IdProveedor_Transporte" + ",[Marca_Transporte] = @Marca_Transporte,[Modelo_Transporte] = @Modelo_Transporte," + "[tara_Transporte] = @tara_Transporte,[Patente_Transporte] = @Patente_Transporte," + "[Descripcion_Transporte] = @Descripcion_Transporte,[Titular_Transporte] = @Titular_Transporte " + "WHERE [Id_Transporte] = @Id_Transporte"; var db = DatabaseFactory.CreateDatabase(ConnectionName); using (var cmd = db.GetSqlStringCommand(sqlStatement)) { db.AddInParameter(cmd, "@IdProveedor_Transporte", DbType.Int32, transporte.IdProveedor); db.AddInParameter(cmd, "@Marca_Transporte", DbType.String, transporte.Marca); db.AddInParameter(cmd, "@Modelo_Transporte", DbType.String, transporte.Modelo); db.AddInParameter(cmd, "@tara_Transporte", DbType.Int32, transporte.Tara); db.AddInParameter(cmd, "@Patente_Transporte", DbType.String, transporte.Patente); db.AddInParameter(cmd, "@Descripcion_Transporte", DbType.String, transporte.Descripcion); db.AddInParameter(cmd, "@Titular_Transporte", DbType.String, transporte.Titular); db.ExecuteNonQuery(cmd); } }