public static Musculo SingleSpecificSelect(string query) { Object[] columns = new Object[] { 0, "" }; Musculo mus = DataBase.SingleSpecificSelect <Musculo>(TablesManager.Tables[tableId].tableName, columns, query); return(mus); }
public static Musculo ReadValue(int id) { Object[] columns = new Object[] { 0, "" }; Musculo muscle = DataBase.ReadValue <Musculo>(TablesManager.Tables[tableId].tableName, TablesManager.Tables[tableId].colName[0], id, columns); return(muscle); }
public static Musculo GetLast() { Object[] columns = new Object[] { 0, "" }; Musculo muscle = DataBase.GetLast <Musculo>(TablesManager.Tables[tableId].tableName, TablesManager.Tables[tableId].colName[0], columns); return(muscle); }
/** * Função que lê dados já cadastrados anteriormente na relação musculo. */ public static List <Musculo> Read() { DataBase banco = new DataBase(); using (banco.conn = new SqliteConnection(GlobalController.instance.path)) { banco.conn.Open(); banco.cmd = banco.conn.CreateCommand(); banco.sqlQuery = "SELECT * " + "FROM MUSCULO"; banco.cmd.CommandText = banco.sqlQuery; IDataReader reader = banco.cmd.ExecuteReader(); List <Musculo> muscles = new List <Musculo>(); while (reader.Read()) { int idMusculoTemp = 0; string nomeMusculoTemp = "null"; if (!reader.IsDBNull(0)) { idMusculoTemp = reader.GetInt32(0); } if (!reader.IsDBNull(1)) { nomeMusculoTemp = reader.GetString(1); } Musculo muscle = new Musculo(idMusculoTemp, nomeMusculoTemp); muscles.Add(muscle); } reader.Close(); reader = null; banco.cmd.Dispose(); banco.cmd = null; banco.conn.Close(); banco.conn = null; return(muscles); } }
public static Musculo ReadValue(int id) { DataBase banco = new DataBase(); using (banco.conn = new SqliteConnection(GlobalController.instance.path)) { banco.conn.Open(); banco.cmd = banco.conn.CreateCommand(); banco.sqlQuery = "SELECT * " + string.Format("FROM \"{0}\" WHERE \"{1}\" = \"{2}\";", TablesManager.Tables[tableId].tableName, TablesManager.Tables[tableId].colName[0], id); banco.cmd.CommandText = banco.sqlQuery; IDataReader reader = banco.cmd.ExecuteReader(); reader.Read(); int idMusculoTemp = 0; string nomeMusculoTemp = "null"; if (!reader.IsDBNull(0)) { idMusculoTemp = reader.GetInt32(0); } if (!reader.IsDBNull(1)) { nomeMusculoTemp = reader.GetString(1); } Musculo muscle = new Musculo(idMusculoTemp, nomeMusculoTemp); reader.Close(); reader = null; banco.cmd.Dispose(); banco.cmd = null; banco.conn.Close(); banco.conn = null; return(muscle); } }