public IEnumerable <DalTag> GetAll(string filter = "") { var result = new List <DalTag>(); var data = _adapterHelper.GetAll(filter); for (var i = 0; i < data.Tables[0].Rows.Count; ++i) { var dataRow = data.Tables[0].Rows[i].ItemArray; result.Add(new DalTag(int.Parse(dataRow[0].ToString()), dataRow[1].ToString(), int.Parse(dataRow[2].ToString()))); } return(result); }
public IEnumerable <DalDashboardFilterRelation> GetAll(string filter = "") { var result = new List <DalDashboardFilterRelation>(); var data = _adapterHelper.GetAll(filter); for (var i = 0; i < data.Tables[0].Rows.Count; ++i) { var dataRow = data.Tables[0].Rows[i].ItemArray; result.Add(new DalDashboardFilterRelation(int.Parse(dataRow[0].ToString()), int.Parse(dataRow[1].ToString()), dataRow[2] != DBNull.Value ? int.Parse(dataRow[2].ToString()) : (int?)null, dataRow[3] != DBNull.Value ? int.Parse(dataRow[3].ToString()) : (int?)null, (bool)dataRow[4], int.Parse(dataRow[5].ToString()))); } return(result); }
public IEnumerable <DalOperation> GetAll(string filter = "") { var result = new List <DalOperation>(); var data = _adapterHelper.GetAll(filter); for (var i = 0; i < data.Tables[0].Rows.Count; ++i) { var dataRow = data.Tables[0].Rows[i].ItemArray; var parentId = int.TryParse(dataRow[1].ToString(), out var tempVal) ? tempVal : (int?)null; result.Add(new DalOperation(int.Parse(dataRow[0].ToString()), parentId, int.Parse(dataRow[2].ToString()), dataRow[3].ToString(), decimal.Parse(dataRow[4].ToString()), int.Parse(dataRow[6].ToString()), int.Parse(dataRow[5].ToString()), int.Parse(dataRow[7].ToString()), int.Parse(dataRow[8].ToString()), dataRow[9].ToString(), dataRow[10].ToString())); } return(result); }