public List <ValueParametr> GetValuesWithRequest(String req) { List <ValueParametr> res = null; SQLiteCommand cmd = new SQLiteCommand(conn); cmd.Transaction = trans; cmd.CommandText = req; try { SQLiteDataReader r = cmd.ExecuteReader(); string line = String.Empty; res = new List <ValueParametr>(); ValueParametr valueParametr; while (r.Read()) { valueParametr = new ValueParametr(); valueParametr.ID = int.Parse(string.Format("{0}", r["ID"])); valueParametr.ParametrID = int.Parse(string.Format("{0}", r["PARAM_ID"])); valueParametr.SelectionID = int.Parse(string.Format("{0}", r["SELECTION_ID"])); valueParametr.RowIndex = int.Parse(string.Format("{0}", r["ROW_INDEX"])); valueParametr.Value = r["VALUE"].ToString(); res.Add(valueParametr); } r.Close(); } catch (SQLiteException ex) { Console.WriteLine(ex.Message); return(null); } return(res); }
public EducationTable(List <ValueParametr> arrValues, List <Parametr> arrParams) { Rows = new List <ValueParametr[]>(); ParameterCount = arrParams.Count(); if (arrValues != null) { int prevIndex = arrValues[0].RowIndex; int indexInRow = 0; ValueParametr[] row = new ValueParametr[arrParams.Count()]; foreach (ValueParametr valueParam in arrValues) { if (valueParam.RowIndex != prevIndex) { Rows.Add(row); indexInRow = 0; row = new ValueParametr[arrParams.Count()]; } row[indexInRow] = valueParam; indexInRow++; prevIndex = valueParam.RowIndex; } } }
public EducationTable(List<ValueParametr> arrValues, List<Parametr> arrParams) { Rows = new List<ValueParametr[]>(); ParameterCount = arrParams.Count(); if (arrValues != null) { int prevIndex = arrValues[0].RowIndex; int indexInRow = 0; ValueParametr[] row = new ValueParametr[arrParams.Count()]; foreach (ValueParametr valueParam in arrValues) { if (valueParam.RowIndex != prevIndex) { Rows.Add(row); indexInRow = 0; row = new ValueParametr[arrParams.Count()]; } row[indexInRow] = valueParam; indexInRow++; prevIndex = valueParam.RowIndex; } } }
public List<ValueParametr> GetValuesWithRequest(String req) { List<ValueParametr> res = null; SQLiteCommand cmd = new SQLiteCommand(conn); cmd.Transaction = trans; cmd.CommandText = req; try { SQLiteDataReader r = cmd.ExecuteReader(); string line = String.Empty; res = new List<ValueParametr>(); ValueParametr valueParametr; while (r.Read()) { valueParametr = new ValueParametr(); valueParametr.ID = int.Parse(string.Format("{0}", r["ID"])); valueParametr.ParametrID = int.Parse(string.Format("{0}", r["PARAM_ID"])); valueParametr.SelectionID = int.Parse(string.Format("{0}", r["SELECTION_ID"])); valueParametr.RowIndex = int.Parse(string.Format("{0}", r["ROW_INDEX"])); valueParametr.Value = r["VALUE"].ToString(); res.Add(valueParametr); } r.Close(); } catch (SQLiteException ex) { Console.WriteLine(ex.Message); return null; } return res; }