private string GetDefaultPartner() { System.Data.DataTable dt = new System.Data.DataTable(); try { // Try to retrieve the table from cache dt = (System.Data.DataTable)Data.Cache.Get("DefaultPartnersTable"); if (dt == null) { tbl_authorized_partners partners = new tbl_authorized_partners(GetBasicSettingsObject()); dt = partners.GetByBU(BusinessUnit); Data.Cache.Add("DefaultPartnersTable", dt, CacheTimeInMins); } //Retrieve the default partner for this business unit if ((dt != null)) { foreach (System.Data.DataRow row in dt.Rows) { if (BusinessUnit.Equals(row["BUSINESS_UNIT"])) { return(row["PARTNER"].ToString()); } } } return(Utilities.GetAllString()); } catch (Exception) { return(Utilities.GetAllString()); } }