private void RegisterSearchWord(string word, DataSet dataset, HttpRequestMessage Request, Stopwatch sw)
{
if (word != "")
{
var stringBuilder = new StringBuilder();
var ipAddress = Utility.GetClientIpAddress(Request);
var resultNum = dataset.Tables[0].Rows.Count;
stringBuilder.Append("insert into [dbo].[Search] (SearchWord,IPAddress,ResultNum,SearchTime,Time) values");
stringBuilder.Append("('" + word.Replace("'", "''") + "','" + ipAddress + "','" + resultNum + "','" + sw.ElapsedMilliseconds + "','" + Utility.GetDateTimeNow() + "');");
DBAccessor.ExecuteSQLScalar(stringBuilder.ToString(), DataBaseType.WORD);
}
}
private void RegisterSelectedWord(HttpRequestMessage Request)
{
var selectedType = Request.RequestUri.LocalPath.Split('/')[4];
var selectedID = Request.RequestUri.LocalPath.Split('/')[5];
if (selectedID != "" && selectedType != "")
{
var stringBuilder = new StringBuilder();
//var ipAddress = GetIPAddress();
var ipAddress = Utility.GetClientIpAddress(Request);
stringBuilder.Append("insert into [dbo].[Selected] (IPAddress,SelectedType,SelectedID,Time) values");
stringBuilder.Append("('" + ipAddress + "','" + GetSelectedType(selectedType) + "','" + selectedID + "','" + Utility.GetDateTimeNow() + "');");
//Selected Type : 1:Word,2:Button
DBAccessor.ExecuteSQLScalar(stringBuilder.ToString(), DataBaseType.WORD);
}
}
