public HttpResponseMessage getBrowseHistory(BrowseHistoryList BH)
{
ar = new WebApiResponse();
try
{
string qry = "select * from MDM_BrowseHistory where DeviceID='" + BH.uuid + "'";
dr = databaseHelper.getDataReader(qry);
if (dr.Read())
{
if (!dr.IsClosed)
{
dr.Close();
}
qry = "delete from MDM_BrowseHistory where DeviceID='" + BH.uuid + "'";
rcnt = databaseHelper.ExecuteQuery(qry);
}
if (!dr.IsClosed)
{
dr.Close();
}
foreach (SortedList <string, string> key_val in BH.BrowseHistory)
{
qry = "insert into MDM_BrowseHistory(DeviceID,URL,BrowseTimeStamp)values('" + BH.uuid + "','" + key_val["url"] + "',convert(datetime,'" + key_val["BrowseTimeStamp"] + "',120))";
//linfo.LogException(null, "Browse History Query = " + qry);
databaseHelper.ExecuteQuery(qry);
}
qry = "delete from MDM_PushNotification where DeviceID='" + BH.uuid + "' and Command='Browse History'";
rcnt = databaseHelper.ExecuteQuery(qry);
ar.errorCode = "Successfully Completed";
ar.response = true;
response = Request.CreateResponse(HttpStatusCode.Created, ar);
return(response);
}
catch (Exception ex)
{
ar.errorCode = "Browse History Submission Failed";
ar.response = false;
response = Request.CreateResponse(HttpStatusCode.BadRequest, ar);
linfo.LogFile(enLogType.EXCEPTION, ex.Message, null);
}
finally
{
if (dr != null && !dr.IsClosed)
{
dr.Close();
}
}
return(response);
}
public HttpResponseMessage getBrowseHistory(BrowseHistoryList BH)
{
ar = new WebApiResponse();
try
{
string qry = "select * from MDM_BrowseHistory where DeviceID='" + BH.uuid + "'";
dr = databaseHelper.getDataReader(qry);
if (dr.Read())
{
if (!dr.IsClosed)
dr.Close();
qry = "delete from MDM_BrowseHistory where DeviceID='" + BH.uuid + "'";
rcnt = databaseHelper.ExecuteQuery(qry);
}
if (!dr.IsClosed)
dr.Close();
foreach (SortedList<string, string> key_val in BH.BrowseHistory)
{
qry = "insert into MDM_BrowseHistory(DeviceID,URL,BrowseTimeStamp)values('" + BH.uuid + "','" + key_val["url"] + "',convert(datetime,'"+key_val["BrowseTimeStamp"]+"',120))";
//linfo.LogException(null, "Browse History Query = " + qry);
databaseHelper.ExecuteQuery(qry);
}
qry = "delete from MDM_PushNotification where DeviceID='" + BH.uuid + "' and Command='Browse History'";
rcnt = databaseHelper.ExecuteQuery(qry);
ar.errorCode = "Successfully Completed";
ar.response = true;
response = Request.CreateResponse(HttpStatusCode.Created, ar);
return response;
}
catch (Exception ex)
{
ar.errorCode = "Browse History Submission Failed";
ar.response = false;
response = Request.CreateResponse(HttpStatusCode.BadRequest, ar);
linfo.LogFile(enLogType.EXCEPTION, ex.Message,null);
}
finally
{
if (dr != null && !dr.IsClosed)
dr.Close();
}
return response;
}
