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