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