public static Dictionary <string, int> GetReferers(string url, int siteId) { var dataAccess = DataAccessBaseEx.GetWorker(); var referersDs = dataAccess.GetRequestReferers(url, siteId); Dictionary <string, int> referers = new Dictionary <string, int>(); if (referersDs.Tables[0] != null) { int unknownReferers = 0; for (int i = 0; i < referersDs.Tables[0].Rows.Count; i++) { var referer = referersDs.Tables[0].Rows[i][0].ToString(); int count = Convert.ToInt32(referersDs.Tables[0].Rows[i][1].ToString()); if (referer.Trim() != string.Empty && !referer.Contains("(null)")) { if (!referer.Contains("://")) { referer = referer.Insert(0, "/"); } referers.Add(referer, count); } else { unknownReferers += count; } } if (unknownReferers > 0) { referers.Add(UknownReferer, unknownReferers); } } return(referers); }
public static int GetCurrentSiteId() { var host = HttpContext.Current.Request.Url.Host; try { var dataAccess = DataAccessBaseEx.GetWorker(); var hostDataSet = dataAccess.FindSiteIdByHost(host); foreach (DataTable table in hostDataSet.Tables) { if (table.Rows.Count > 0) { var row = table.Rows[0]; return(Convert.ToInt32(row[0])); } } } catch (Exception ex) { _logger.Error(String.Format("Fel vid GetCurrentSiteId Fix: {0} Hosten var: {1}", ex, host)); return(-1); } return(-1); }
public static int GetTotalSuggestionCount(int siteId) { var dataAccess = DataAccessBaseEx.GetWorker(); var totalSuggestionCountDs = dataAccess.GetTotalNumberOfSuggestions(siteId); if (totalSuggestionCountDs != null && totalSuggestionCountDs.Tables.Count > 0) { return(Convert.ToInt32(totalSuggestionCountDs.Tables[0].Rows[0][0])); } return(0); }
public static List <int> GetAllSiteIds() { List <int> siteIds = new List <int>(); var dataAccess = DataAccessBaseEx.GetWorker(); var hostDataSet = dataAccess.FindSiteIds(); foreach (DataTable table in hostDataSet.Tables) { if (table.Rows.Count > 0) { siteIds.AddRange(from DataRow row in table.Rows select Convert.ToInt32(row[0])); } } return(siteIds); }
public static Dictionary <string, int> GetRedirects(int siteId) { var keyCounts = new Dictionary <string, int>(); DataAccessBaseEx dabe = DataAccessBaseEx.GetWorker(); var allkeys = dabe.GetAllClientRequestCount(siteId); foreach (DataTable table in allkeys.Tables) { foreach (DataRow row in table.Rows) { var oldUrl = row[0].ToString(); keyCounts.Add(oldUrl, Convert.ToInt32(row[1])); } } return(keyCounts); }
public static int GetSiteIdFromUrl(string url) { var host = HttpContext.Current.Request.Url.Host; var dataAccess = DataAccessBaseEx.GetWorker(); var hostDataSet = dataAccess.FindSiteIdByHost(host); foreach (DataTable table in hostDataSet.Tables) { if (table.Rows.Count > 0) { var row = table.Rows[0]; return(Convert.ToInt32(row[0])); } } return(-1); }