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