public static IEnumerable <string> SelectPatternsByBrand(string brand)
        {
            var dt = DalPattern.SelectPatternsByBrand(brand);

            var list = new List <string>();

            if (dt?.Rows.Count > 0)
            {
                foreach (DataRow row in dt.Rows)
                {
                    var pattern = row["Pattern"].ToString();
                    if (!string.IsNullOrWhiteSpace(pattern))
                    {
                        list.Add(pattern);
                    }
                }
            }
            return(list);
        }