public RequestTypesData SelectSingleData(string requestTypeId) { var data = new RequestTypesData(); using var dataTable = dbHelper.GetDataTable($"select * from RequestTypes where Id = '{requestTypeId}'"); foreach (var row in dataTable.Rows.Cast <DataRow>()) { data.PrimaryId = int.Parse(row["PrimaryId"].ToString()); data.Id = row["Id"].ToString(); data.Name = row["Name"].ToString(); } return(data); }
private RequestTypesData GetRequestTypes(string requestTypeId) { var data = new RequestTypesData(); try { RequestTypesHelper dbHelper = new RequestTypesHelper(_appSettings.Secrets.DbConnectionString); data = dbHelper.SelectSingleData(requestTypeId); } catch (Exception ex) { _logger.LogError("Error GetRequestTypes: {0}", ex.Message); } return(data); }
public List <RequestTypesData> SelectData() { var dataList = new List <RequestTypesData>(); using var dataTable = dbHelper.GetDataTable(@"select * from RequestTypes order by PrimaryId Asc"); foreach (var row in dataTable.Rows.Cast <DataRow>()) { var data = new RequestTypesData(); data.PrimaryId = int.Parse(row["PrimaryId"].ToString()); data.Id = row["Id"].ToString(); data.Name = row["Name"].ToString(); dataList.Add(data); } return(dataList); }