public string UserLogout()
{
var mTimer = new Stopwatch();
mTimer.Start();
euPaths clseuPaths = new euPaths();
Context.Session["isAuthenticated"] = null;
Context.Session["usr_id"] = null;
Context.Session.Clear();
Context.Session.Abandon();
string strQuery = string.Empty;
string strRV = string.Empty;
if (Context.Session["isAuthenticated"] == null)
{
clseuPaths.createTemporaryUser(Context);
}
//Get anonymous user data.
strRV = clseuPaths.GetCurrentUserDetails(Convert.ToString(Context.Session["usr_id"]));
Utility.LogRequest(strRV, false, mTimer);
return strRV;
}
public string AddRating(int fk_rating_scale_id, string fk_rel_uri)
{
string strRV = string.Empty;
euPaths clseuPaths = new euPaths();
if (Context.Session["isAuthenticated"] == null)
{
clseuPaths.createTemporaryUser(Context);
}
try
{
string strQuery = "SELECT count(id) FROM rating WHERE fk_usr_id = '" + Convert.ToString(Context.Session["usr_id"]) + "' and fk_rel_uri = '" + fk_rel_uri + "' and isdeleted = false;";
int intResult = Utility.DBExecuteScalar(strQuery);
int mRatingId;
if (intResult > 0)
{
strQuery = "UPDATE rating SET fk_rating_scale_id = '" + fk_rating_scale_id + "' WHERE fk_usr_id = '" + Convert.ToString(Context.Session["usr_id"]) + "' AND fk_rel_uri = '" + fk_rel_uri + "' AND isdeleted = false;";
Utility.DBExecuteNonQuery(strQuery);
strQuery = "SELECT id FROM rating WHERE fk_usr_id = '" + Convert.ToString(Context.Session["usr_id"]) + "' and fk_rel_uri = '" + fk_rel_uri + "' AND isdeleted = false;";
mRatingId = Utility.DBExecuteScalar(strQuery);
}
else
{
strQuery = "INSERT INTO rating (fk_usr_id, fk_rating_scale_id, fk_rel_uri) VALUES ('" + Convert.ToString(Context.Session["usr_id"]) + "','" + fk_rating_scale_id + "','" + fk_rel_uri + "');SELECT currval('rating_id_seq');";
mRatingId = Utility.DBExecuteScalar(strQuery);
}
strQuery = "SELECT (SELECT COUNT(id) FROM rating WHERE fk_rating_scale_id = 2 AND fk_rel_uri = '" + fk_rel_uri + "' and isdeleted=false) AS likes, (SELECT COUNT(id) FROM rating WHERE fk_rating_scale_id = 1 AND fk_rel_uri = '" + fk_rel_uri + "' and isdeleted=false) AS dislikes";
DataTable dtab = Utility.DBExecuteDataTable(strQuery);
if (dtab.Rows.Count > 0)
{
strRV = Utility.DataTableToDictionary(dtab);
}
else
{
strRV = Utility.GetMsg(Utility.msgStatusCodes.QueryDidNotReturnRecords, "No comment was returned");
}
return strRV;
}
catch (Exception ex)
{
return Utility.GetMsg(Utility.msgStatusCodes.DatabaseSQLError, ex.Message);
}
}