private List<WorkingField> GetField(string _SQL)
{
List<WorkingField> OutPut = new List<WorkingField>();
AccessDatabaseConnection myconn = new AccessDatabaseConnection();
myconn.getQuery = _SQL;
foreach (DataRow row in myconn.OutTable.Rows)
{
OutPut.Add(new WorkingField(row["ID"].ToString(), row["NameofUnit"].ToString(), row["Description"].ToString()));
}
return OutPut;
}
//General method for get skills
private List<Skills> GetSkill(string _SQL)
{
List<Skills> OutPut = new List<Skills>();
AccessDatabaseConnection myconn = new AccessDatabaseConnection();
myconn.getQuery = _SQL;
foreach (DataRow row in myconn.OutTable.Rows)
{
OutPut.Add(new Skills(row["ID"].ToString(), row["SkillName"].ToString()));
}
return OutPut;
}
//General method for get reservation
private List<Order> GetResevation(string _SQL)
{
List<Order> OutPut = new List<Order>();
AccessDatabaseConnection myconn = new AccessDatabaseConnection();
myconn.getQuery = _SQL;
foreach (DataRow row in myconn.OutTable.Rows)
{
OutPut.Add(new Order(row["ID"].ToString(), row["CustomerID"].ToString(), row["DateofReservation"].ToString(), row["Time"].ToString(), row["UnitID"].ToString()));
}
return OutPut;
}
private void SaveChangeReservation(string _SQL)
{
AccessDatabaseConnection myconn = new AccessDatabaseConnection();
myconn.getQuery = _SQL;
myconn.nonQueryCmd();
}
