public JsonResult Get(string sessionGuid)
{
var returnDataObj = new Dictionary <string, Dictionary <string, object> >();
var qryResult = new Dictionary <int, Dictionary <string, object> >();
var spd = new StoredProc();
var procParams = new Dictionary <string, string>();
string transactionUserIP = Request.HttpContext.Connection.RemoteIpAddress.ToString();
procParams.Add("@SESSION_GUID", sessionGuid);
qryResult = spd.RunStoredProc("evidencebx.USERS_SELECT_SELF", procParams);
return(Json(qryResult[0]["USER_STAMP"]));
// GET SESSION INFO
/*
* string userStamp = string.Empty;
* using (sakuraDbEntities _db = new sakuraDbEntities())
* {
* ObjectResult<USERS_SELECT_SELF_Result> userResults = _db.USERS_SELECT_SELF(sessionGuid);
* foreach (var user in userResults)
* {
* userStamp = user.USER_STAMP;
* }
* }
*/
}
public JsonResult Get(ControllerContext context)
{
var returnDataObj = new Dictionary <string, Dictionary <int, object> >();
var spd = new StoredProc();
returnDataObj.Add("AGENCIES", spd.RunStoredProc("evidencebx.AGENCIES_SELECT", null));
return(Json(returnDataObj));
}
public JsonResult Get(string agency_guid)
{
var returnDataObj = new Dictionary <string, Dictionary <int, object> >();
var spd = new StoredProc();
var procParams = new Dictionary <string, string>();
procParams.Add("@AGENCY_GUID", agency_guid);
returnDataObj.Add("AGENCY_USERS", spd.RunStoredProc("evidencebx.AGENCY_USERS_SELECT", procParams));
return(Json(returnDataObj));
}