//Select by specific column and value
public Angar SelectTask(string tableName, string columnName, string value, string comma)
{
Loader();
string SQL = "SELECT * FROM " + tableName + " WHERE "+columnName+"=" +comma+ value +comma+ ";";
Angar answer;
answer = new Angar();
Reader = Execute(SQL);
while (Reader.Read())
{
Task temp;
temp = new Task();
//DO IT
temp.Body = Reader.GetValue(Reader.GetOrdinal("Body")).ToString();
temp.Header = Reader.GetValue(Reader.GetOrdinal("Header")).ToString();
temp.Worker = Reader.GetValue(Reader.GetOrdinal("Worker")).ToString();
temp.ID = Convert.ToInt64(Reader.GetValue(Reader.GetOrdinal("ID")));
temp.IsDone = (bool)Reader.GetValue(Reader.GetOrdinal("IsDone"));
temp.Date = Convert.ToDateTime(Reader.GetValue(Reader.GetOrdinal("TargetDate")));
answer.Storage.Add(temp);
}
return answer;
}
//Массовая загрузка элементов в таблицу из хранилища
private void LoadToGrid(Angar tasks)
{
dataGridView1.Rows.Clear();
foreach (Task t in tasks.Storage )
{
dataGridView1.Rows.Add(t.ToValues());
}
}
