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