/// Please read this links before reading code:
/// http://www.jdconley.com/blog/archive/2007/11/28/linq-to-sql-surprise-performance-hit.aspx
/// http://blog.linqexchange.com/index.php/how-to-use-compiled-queries-in-linq-to-sql-for-high-demand-asp-net-websites/
/// <summary>
/// Main search function
/// </summary>
/// <param name="usi">Insert UserSearchInfo object</param>
/// <param name="pagelimit">Insert resultlimit</param>
/// <param name="pageindex">Insert index</param>
/// <param name="langId">Insert langid for what langauge you want the result in</param>
/// <param name="fromLastSeconds"></param>
/// <returns>return SearchObject object</returns>
private List <SearchObject> SearchMatchs(UserSearchInfo usi,
int pagelimit,
int pageindex,
int langId,
int fromLastSeconds)
{
Searchwar_netEntities db = new Searchwar_netEntities();
List <Guid> lastIds = new List <Guid>();
if (_context.Session["searchresult"] != null)
{
lastIds = (List <Guid>)_context.Session["searchresult"];
}
SearchColumns parameters = new SearchColumns
{
Usi = usi,
LangId = langId,
PageIndex = pageindex,
PageLimit = pagelimit,
FromLastSeconds = fromLastSeconds,
DateTimeNow = TimeZoneManager.DateTimeNow,
LastIds = lastIds
};
List <SearchObject> matchsFound = SearchResults(db, parameters).Skip(parameters.PageIndex == 0 ? (parameters.PageIndex * parameters.PageLimit) : 0).Take(
parameters.PageLimit).ToList <SearchObject>();
return(matchsFound);
}
// updating user activity
private SearchNoticeMessage UpdateUserActivity(UserSearchInfo usi,
int userActivityMinSeconds,
HttpContext context,
SearchNoticeMessage noticemessage)
{
DateTime DateTimeNow = TimeZoneManager.DateTimeNow;
Guid?searchId = ANOProfile.GetCookieValues(usi.UserIpAddress, context).SearchMatchID;
SW_SearchWar getSearch =
db.SW_SearchWar.SingleOrDefault <SW_SearchWar>(
s =>
s.SearchWarUserID == usi.UserID &&
(s.SearchWarId == searchId ||
s.SearchWarId == usi.SearchMatchID));
if (getSearch != null)
{
if (getSearch.SearchWarEditDate.AddSeconds(userActivityMinSeconds) > DateTimeNow)
{
getSearch.SearchWarEditDate = DateTimeNow.AddSeconds(5);
db.SaveChanges();
return(noticemessage);
}
}
return(SearchNoticeMessage.NoConnection);
}
private InsertusiResult CreateUserSearch(UserSearchInfo usi)
{
TimeZoneManager mngInfo = new TimeZoneManager(usi.UserIpAddress);
DateTime nowDatetime = TimeZoneManager.DateTimeNow;
List <SW_SearchWar> getUserMatchs = (from s in db.SW_SearchWar
where s.SearchWarUserID == usi.UserID &&
s.SearchWarIsRunning == true
select s).ToList();
foreach (SW_SearchWar s in getUserMatchs)
{
s.SearchWarIsRunning = false;
}
SW_SearchWar createusi = new SW_SearchWar
{
SearchWarId = Guid.NewGuid(),
SearchWarClanName = usi.ClanName,
SearchWarClanContinentId = usi.ClanContinentID,
SearchWarClanCountryId = usi.ClanCountryID,
SearchWarClanSkillId = usi.SearchSkillID,
SearchWarSearchGameId = usi.SearchGameID,
SearchWarSearchGameTypeId = usi.SearchGameModeID,
SearchWarSearchContinentId = usi.SearchContinentID,
SearchWarSearchCountryId = usi.SearchCountryID,
SearchWarSearchMap = usi.SearchMap,
SearchWarIsRunning = true,
SearchWarSearchSkillId = usi.SearchSkillID,
SearchWarSearchvsX = usi.SearchvsX,
SearchWarSearchXvs = usi.SearchXvs,
SearchWarSearchMatchStart = usi.SearchMatchStart,
SearchWarUserIpAddress = usi.UserIpAddress,
SearchWarUserID = usi.UserID,
SearchWarAddedDate = nowDatetime,
SearchWarEditDate = nowDatetime
};
db.SW_SearchWar.AddObject(createusi);
db.SaveChanges();
usi.SearchMatchID = createusi.SearchWarId;
_context.Session["usi"] = usi;
return(InsertusiResult.Done);
}
public Boolean GetUserMatchInfo(UserSearchInfo usi)
{
SW_SearchWar getSearch = null;
if (usi.SearchMatchID.HasValue && usi.UserID != null)
{
GetUserMatchInfoColumnNoPosition parameters = new GetUserMatchInfoColumnNoPosition
{
SearchWarId = usi.SearchMatchID.Value,
SearchWarUserId = usi.UserID
};
getSearch = GetUserSearchInfoFast(db, parameters);
}
if (getSearch != null)
{
usi.SearchGameID = getSearch.SearchWarSearchGameId;
usi.SearchMatchStart = getSearch.SearchWarSearchMatchStart;
usi.ClanSkillID = getSearch.SearchWarClanSkillId;
usi.ClanName = getSearch.SearchWarClanName;
if (getSearch.SearchWarClanSkillId.HasValue)
{
usi.ClanCountryID = getSearch.SearchWarClanCountryId.Value;
}
usi.ClanContinentID = getSearch.SearchWarClanContinentId.Value;
if (getSearch.SearchWarSearchContinentId.HasValue)
{
usi.SearchContinentID = getSearch.SearchWarSearchContinentId.Value;
}
usi.SearchCountryID = getSearch.SearchWarSearchCountryId;
usi.SearchGameModeID = getSearch.SearchWarSearchGameTypeId;
usi.SearchMap = getSearch.SearchWarSearchMap;
usi.SearchSkillID = getSearch.SearchWarSearchSkillId;
usi.SearchvsX = getSearch.SearchWarSearchvsX;
usi.SearchXvs = getSearch.SearchWarSearchXvs;
return(true);
}
else
{
return(false);
}
}
// check max idle time
private SearchNoticeMessage CheckUserIdleActivity(UserSearchInfo usi,
int maxIdleSearch_Seconds,
HttpContext context,
SearchNoticeMessage noticemessage)
{
Guid?searchID = ANOProfile.GetCookieValues(usi.UserIpAddress, context).SearchMatchID;
SW_SearchWar obj =
db.SW_SearchWar.SingleOrDefault <SW_SearchWar>(s => s.SearchWarUserID == usi.UserID && (s.SearchWarId == searchID));
DateTime getAddedDateTime;
if (obj != null)
{
getAddedDateTime = obj.SearchWarAddedDate;
}
else
{
return(SearchNoticeMessage.NoResults);
}
return(getAddedDateTime.AddSeconds(maxIdleSearch_Seconds) > TimeZoneManager.DateTimeNow ? noticemessage : SearchNoticeMessage.NoResults);
}
public void ProcessRequest(HttpContext context)
{
// Set defaults values
string data = null;
string currentUserIp = "62.107.21.129";
HttpRequest currentR = context.Request;
HttpServerUtility currentS = context.Server;
int currentLangId;
bool isValid = true;
bool isUpdateInfoSucces = true;
string errorMessage = "succes";
_currentUserIp = currentUserIp;
string sLangId = context.Request.QueryString["li"];
if (string.IsNullOrEmpty(sLangId))
{
isValid = false;
errorMessage = "You forgot langid (querystring li)";
}
string userAction = context.Request.QueryString["a"];
if (string.IsNullOrEmpty(userAction))
{
isValid = false;
errorMessage = "You forgot action (querystring a)";
}
// Convert langid querystring to int32
if (!Int32.TryParse(sLangId, out currentLangId))
{
isValid = false;
errorMessage = "Problem with converting langauge ID (querystring li)";
}
#region Go search
SearchEngine engine = new SearchEngine();
// default option
SearchEngine.UserSearchOption userOption = SearchEngine.UserSearchOption.UpdateUserSearch;
#region Set default user data
var otherData = new
{
UserID = (Guid)ANOProfile.GetCookieValues(currentUserIp, context).UserID,
UserIpAddress = (string)currentUserIp
};
#endregion
// Create user default information
UserSearchInfo usi = new UserSearchInfo
{
UserID = otherData.UserID,
UserIpAddress = otherData.UserIpAddress
};
// CREATE match search!
if (userAction == "1")
{
#region Set ints data (Get data by QueryStrings)
var dataConvertToInts = new
{
clanSkillID = (string)currentR.QueryString["cs"],
clanContinentID = (string)currentR.QueryString["cct"],
clanCountryID = (string)currentR.QueryString["cc"],
searchContinentID = (string)currentR.QueryString["sct"],
searchCountryID = (string)currentR.QueryString["sc"],
searchGameID = (string)currentR.QueryString["sg"],
searchGameModeID = (string)currentR.QueryString["sgt"],
searchXvs = (string)currentR.QueryString["sxv"],
searchvsX = (string)currentR.QueryString["svx"]
}.ToAnonymousObjectCollection();
int MaxIntValue = int.MaxValue;
var intdata = new
{
clanSkillID = (int?)null,
clanContinentID = (int)MaxIntValue,
clanCountryID = (int)MaxIntValue,
searchContinentID = (int)MaxIntValue,
searchCountryID = (int?)null,
searchGameID = (int)MaxIntValue,
searchGameModeID = (int?)null,
searchXvs = (int?)null,
searchvsX = (int?)null,
searchYearTo = (int)MaxIntValue,
searchYearFrom = (int)MaxIntValue,
searchDayTo = (int)MaxIntValue,
searchDayFrom = (int)MaxIntValue,
searchMonthTo = (int)MaxIntValue,
searchMonthFrom = (int)MaxIntValue,
searchHourFrom = (int)MaxIntValue,
searchHourTo = (int)MaxIntValue,
searchMinutesFrom = (int)MaxIntValue,
searchMinutesTo = (int)MaxIntValue
}.ToAnonymousObjectCollection();
#endregion
#region validate and convert properties to ints
for (int i = 0; i < dataConvertToInts.Count; i++)
{
AnonymousObject o = dataConvertToInts.GetAnonymousObject(i);
if (!string.IsNullOrEmpty(o.GetValue <string>()))
{
int result;
if (int.TryParse(o.GetValue <string>(), out result))
{
intdata.GetAnonymousObject(o.KeyName).SetValue(result);
}
}
if (intdata.GetAnonymousObject(o.KeyName).GetValue_UnknownObject() != null
&&
Convert.ToInt32(intdata.GetAnonymousObject(o.KeyName).GetValue_UnknownObject()) == MaxIntValue)
{
isValid = false;
errorMessage = "'" + o.KeyName +
"' much be more than empty";
}
}
#endregion
#region Set strings data (convert to HtmlEncode strings)
var stringData = new
{
ClanName = (string)currentS.HtmlEncode(currentS.UrlDecode(currentR.QueryString["cn"])),
SearchMap = (string)currentS.HtmlEncode(currentS.UrlDecode(currentR.QueryString["sm"])),
};
#endregion
#region Set datetime data (Replace + and . (This chars is used to avoid problems))
var datetimeData = new
{
SearchMatchStart = (DateTime)DateTime.ParseExact(currentS.UrlDecode(currentR.QueryString["sfd"]), "dd-MM-yyyy HH:mm:ss", new DateTimeFormatInfo())
};
#endregion
// Edit/Create user search information
usi.ClanName = stringData.ClanName;
usi.ClanSkillID = intdata.GetAnonymousObject("clanSkillID").GetValue <int?>();
usi.ClanContinentID = intdata.GetAnonymousObject("clanContinentID").GetValue <int>();
usi.ClanCountryID = intdata.GetAnonymousObject("clanCountryID").GetValue <int>();
usi.SearchContinentID = intdata.GetAnonymousObject("searchContinentID").GetValue <int>();
usi.SearchCountryID = intdata.GetAnonymousObject("searchCountryID").GetValue <int?>();
usi.SearchGameID = intdata.GetAnonymousObject("searchGameID").GetValue <int>();
usi.SearchGameModeID = intdata.GetAnonymousObject("searchGameModeID").GetValue <int?>();
usi.SearchMap = stringData.SearchMap;
usi.SearchXvs = intdata.GetAnonymousObject("searchXvs").GetValue <int>();
usi.SearchvsX = intdata.GetAnonymousObject("searchvsX").GetValue <int>();
usi.SearchMatchStart = new TimeZoneManager(currentUserIp).ConvertDateTimeToUtc(datetimeData.SearchMatchStart);
userOption = SearchEngine.UserSearchOption.CreateUserSearch;
}
// Update user activity
if (userAction == "2")
{
userOption = SearchEngine.UserSearchOption.UpdateUserSearch;
// Get UserSearchInfo from database
usi.SearchMatchID = ANOProfile.GetCookieValues(usi.UserIpAddress, context).SearchMatchID;
isUpdateInfoSucces = engine.GetUserMatchInfo(usi);
}
if (userAction == "3")
{
userOption = SearchEngine.UserSearchOption.UpdateActivity;
// Get UserSearchInfo from database
usi.SearchMatchID = ANOProfile.GetCookieValues(usi.UserIpAddress, context).SearchMatchID;
isUpdateInfoSucces = engine.GetUserMatchInfo(usi);
if (isValid == true)
{
errorMessage = "UpdatingUserActivity";
}
}
// Validate DateTimes
if (isUpdateInfoSucces == true)
{
if (TimeNowValidate(usi.SearchMatchStart) == true)
{
if (DateNowValidate(usi.SearchMatchStart) != true)
{
isValid = false;
errorMessage = "FromDateIsSmallerThanDateNow";
}
}
else
{
isValid = false;
errorMessage = "FromTimeIsSmallerThanTimeNow";
}
}
else
{
isValid = false;
errorMessage = "UserSearchMatchIsNotOnline";
}
SearchEngine.SearchNoticeMessage searchNotice = SearchEngine.SearchNoticeMessage.Searching;
const int defaultMaxResult = 10;
const int defaultPageIndex = 0;
const int defaultMaxSearchTimeSeconds = 1200;
const int defaultMinUserActivitySeconds = 10;
const int defaultFromLastSeconds = 10;
List <SearchObject> searchResult = engine.UserSearchMatch(usi,
userOption,
defaultMaxResult,
defaultPageIndex,
currentLangId,
defaultMaxSearchTimeSeconds,
defaultMinUserActivitySeconds,
out searchNotice,
defaultFromLastSeconds,
context);
#endregion
LangaugeSystem ls = new LangaugeSystem();
string getLang = ls.GetLang(Convert.ToInt32(sLangId)).LangShortname;
Thread.CurrentThread.CurrentCulture = CultureInfo.CreateSpecificCulture(getLang);
Thread.CurrentThread.CurrentUICulture = new CultureInfo(getLang);
// Create documet and first element called "ss" for "Searchs"
XDocument createXmlSearchs = new XDocument(
new XDeclaration("1.0", "iso-8859-1", "true"),
new XElement("ssi"));
// Get element "ssi" for "Searchs"
XElement getSearchsElement = createXmlSearchs.Descendants("ssi").Single();
// items element
getSearchsElement.Add(new XElement("is"));
// Get element "is" for "Items"
XElement getItemsElement = getSearchsElement.Descendants("is").Single();
// check the result is 0
if (searchResult != null)
{
if (searchResult.Count() > 0)
{
TimeZoneManager mngInfo = new TimeZoneManager(currentUserIp);
// Insert/Create data as xml
for (int i = 0; i < searchResult.Count(); i++)
{
var s = searchResult[i];
// Create element data
getItemsElement.Add(
new XElement("i",
new XAttribute("id", s.SearchWarID.ToString()),
new XElement("cn", s.ClanName),
new XElement("ct", new XAttribute("i", s.ClanContinentData.SearchWarContinentId),
s.ClanContinentData.SearchWarContinentName),
new XElement("cy", new XAttribute("i", s.ClanCountryData.SearchWarCountrytId),
new XAttribute("t", s.ClanCountryData.SearchWarCountryTLD),
s.ClanCountryData.SearchWarCountryName),
new XElement("cs",
new XAttribute("i",
s.ClanSkillData != null
? s.ClanSkillData.SearchWarSkillId.ToString()
: ""),
s.ClanSkillData != null ? s.ClanSkillData.SearchWarSkillName : ""),
new XElement("st", new XAttribute("i", s.SearchContinentData.SearchWarContinentId),
s.SearchContinentData.SearchWarContinentName),
new XElement("sy",
new XAttribute("i",
s.SearchCountryData != null
? s.SearchCountryData.SearchWarCountrytId.ToString()
: ""),
new XAttribute("t",
s.SearchCountryData != null
? s.SearchCountryData.SearchWarCountryTLD
: ""),
s.SearchCountryData != null
? s.SearchCountryData.SearchWarCountryName
: ""),
new XElement("ss",
new XAttribute("i",
s.SearchSkillData != null
? s.SearchSkillData.SearchWarSkillId.ToString()
: ""),
s.SearchSkillData != null ? s.SearchSkillData.SearchWarSkillName : ""),
new XElement("g", new XAttribute("i", s.SearchGame.SearchWarGameId),
s.SearchGame.SearchWarGameName),
new XElement("gt",
new XAttribute("i",
s.SearchGameType != null
? s.SearchGameType.SearchWarGameTypeId.ToString()
: ""),
s.SearchGameType != null ? s.SearchGameType.SearchWarGameTypeName : ""),
new XElement("fd", mngInfo.ConvertDateTimeFromUtc(s.SearchMatchStart).ToString()),
new XElement("x", s.SearchXvs),
new XElement("y", s.SearchvsX),
new XElement("m", s.SearchMap)));
}
}
else
{
if (isValid == true)
{
isValid = false;
errorMessage = "NoResults";
if (userAction == "3")
{
isValid = true;
errorMessage = "UpdatingUserActivity";
}
}
}
}
else
{
if (isValid == true)
{
isValid = false;
errorMessage = "NoResults";
if (userAction == "3")
{
isValid = true;
errorMessage = "UpdatingUserActivity";
}
}
}
// write status for result
getSearchsElement.Add(new XElement("status", new XAttribute("bool", isValid.ToString()), errorMessage));
// Write/save data
StringWriter sw = new StringWriter();
XmlWriter w = XmlWriter.Create(sw);
createXmlSearchs.Save(w);
w.Close();
data = sw.ToString();
sw.Close();
context.Response.ContentType = "text/xml";
context.Response.ContentEncoding = Encoding.UTF8;
context.Response.Write(XmlWhiteSpaceModule.RemoveWhitespace(data));
// release it
context.Response.Flush();
engine.CleanUpAndClose();
}
/// <summary>
/// Searching and matching other matchs/clanwars
/// </summary>
/// <param name="userSearchInfo">insert UserSearchInfo object</param>
/// <param name="option">are you starting searching OR just update search results?</param>
/// <param name="maxResults">max results you want</param>
/// <param name="pageIndex">page index (fx. what page you are on)</param>
/// <param name="langId">insert langid for langauge</param>
/// <param name="minNoUserActivityTimeSeconds">If there is no activity for the user (fx. internet connection lost)</param>
/// <param name="noticemessage">notice if user still can search OR errors</param>
/// <param name="fromLastSeconds">Write the number of seconds you want to get all "Searchs" from</param>
/// <param name="context">current httpcontext</param>
/// <param name="maxIdleTimeSeconds">How long the user can max search in time</param>
/// <returns>anynmous object</returns>
public List <SearchObject> UserSearchMatch(UserSearchInfo userSearchInfo,
UserSearchOption option,
int maxResults,
int pageIndex,
int langId,
int maxIdleTimeSeconds,
int minNoUserActivityTimeSeconds,
out SearchNoticeMessage noticemessage,
int fromLastSeconds,
HttpContext context)
{
_context = context;
noticemessage = SearchNoticeMessage.Searching; // default status value
// Create search
if (option == UserSearchOption.CreateUserSearch)
{
InsertusiResult result = CreateUserSearch(userSearchInfo);
if (result == InsertusiResult.Error)
{
noticemessage = SearchNoticeMessage.UnknownError;
}
}
// Check max idle/searching time
if (option == UserSearchOption.UpdateUserSearch)
{
// Update user activity
noticemessage = UpdateUserActivity(userSearchInfo,
minNoUserActivityTimeSeconds,
context,
noticemessage);
noticemessage = CheckUserIdleActivity(userSearchInfo,
maxIdleTimeSeconds,
context,
noticemessage);
}
if (option == UserSearchOption.UpdateActivity)
{
// Update user activity
noticemessage = UpdateUserActivity(userSearchInfo,
minNoUserActivityTimeSeconds,
context,
noticemessage);
noticemessage = CheckUserIdleActivity(userSearchInfo,
maxIdleTimeSeconds,
context,
noticemessage);
return(null);
}
// SEARCH NOW!!!!
var itemResult = noticemessage == SearchNoticeMessage.Searching
? SearchMatchs(userSearchInfo,
maxResults,
pageIndex,
langId,
fromLastSeconds)
: null;
// no result change noticemsg
if (itemResult == null)
{
noticemessage = SearchNoticeMessage.NoResults;
}
// return search/match results
return(itemResult);
}