public ConfigModulo GetById(int id) { ConfigModulo config = null; string query = "select * from ConfigModulos where Id = {0};"; query = String.Format(query, id); DataSet dr = conexion.Query(query, "Usuarios"); config = dr.Tables[0].Rows.Cast <DataRow>(). Select( x => new ConfigModulo { Id = Int32.Parse(x[0].ToString()), Modulo = x[1].ToString(), Forma = x[2].ToString(), Campo = x[3].ToString(), RE = x[4].ToString() } ).ToList <ConfigModulo>()[0]; return(config); }
public ConfigModulo GetByFields(String modulo, String forma, String campo) { ConfigModulo config = null; string query = "select * from ConfigModulos where modulo = '{0}' and forma = '{1}' and campo = '{2}'"; query = String.Format(query, modulo, forma, campo); DataSet dr = conexion.Query(query, "ConfigModulos"); config = dr.Tables[0].Rows.Cast <DataRow>(). Select( x => new ConfigModulo { Id = Int32.Parse(x[0].ToString()), Modulo = x[1].ToString(), Forma = x[2].ToString(), Campo = x[3].ToString(), RE = x[4].ToString() } ).ToList <ConfigModulo>()[0]; return(config); }