public async Task <List <MeasureUnitVM> > GetMeasureUnitsAsync()
{
string commandText = $"SELECT * FROM MeasureUnits";
var dt = await _sqlManager
.GetDataTableAsync(commandText, CommandType.Text);
var measureUnits = (from DataRow dr in dt.Rows
select new MeasureUnitVM
{
Name = (string)dr["Name"]
}).ToList();
return(measureUnits);
}