public List <BranchModel> GetAllBranchesNamesIds()
        {
            DataTable          dt          = new DataTable();
            List <BranchModel> arrBranches = new List <BranchModel>();

            using (SqlCommand command = new SqlCommand())
            {
                dt = GetMultipleQuery(BranchStringsSql.GetAllBranchesNamesIds());
            }

            foreach (DataRow ms in dt.Rows)
            {
                arrBranches.Add(BranchModel.ToObject(ms));
            }

            return(arrBranches);
        }