/// <exception cref="ConnectionStringNotFoundException">Some connection string is not found</exception> /// <exception cref="DatabaseException">Error is occurred while saving data to database</exception> /// <exception cref="ConnectionStringLookupException">Error is occurred while getting a customer DB</exception> public async Task SavePriceBandData(Guid organisationId, XmlDocument xmlDoc) { var loginDbConnectionString = await _csProvider.GetLoginDb(); if (string.IsNullOrEmpty(loginDbConnectionString)) { throw new ConnectionStringNotFoundException("Login connection string is not found"); } var connectionString = await _csProvider.GetCustomerDb(organisationId, loginDbConnectionString); if (string.IsNullOrEmpty(connectionString)) { throw new ConnectionStringNotFoundException("Customer DB connection string is not found"); } await Exec(connectionString, "sc_save_product_price_band_list", p => { p.Add("@PriceBandListXml", SqlDbType.Xml).Value = xmlDoc.InnerXml; }); }