public HttpResponseMessage FetchShapeFiles(MapSearch map)
{
Models.Authentication.ViewModels.AuthViewModel auth = Infrastructure.Session.AuthSession.GetAuthModel(map);
HttpResponseMessage response = new HttpResponseMessage(HttpStatusCode.OK);
//response.Headers.Add("Set-Cookie", "fileDownload=false; path=/");
try
{
if (iAuth.IsUserValid(auth))
{
if (map.WhichDb == "MATAB")
{
response = MaSourceDocs(map);
}
else if (map.WhichDb == "DFSTAB")
{
response = DfsSourceDocs(map);
}
else if (map.WhichDb == "PORTFOLIOTAB")
{
response = PortfolioSourceDocs(map);
}
}
}
catch (Exception ex)
{
LogFactory.Instance.Log().GenerateEmail("Error Zipping Source Docs", ex.Message);
}
return(response);
}
public IHttpActionResult GenerateMarkers(MapSearch map)
{
//map.TheSessionId = HttpContext.Current.Session.SessionID;
Models.Authentication.ViewModels.AuthViewModel auth = Infrastructure.Session.AuthSession.GetAuthModel(map);
map.TheSessionId = map.UserName + "_" + map.QbTicket + "_" + map.QbToken;
if (iAuth.IsUserValid(auth))
{
object result = null;
if (map.WhichDb == "DFSTAB")
{
result = DfsMarkerData(map);
}
else if (map.WhichDb == "MATAB")
{
result = MaMarkerData(map);
}
else if (map.WhichDb == "PORTFOLIOTAB")
{
result = PortfolioMarkerData(map);
}
return(Ok(result));
}
else
{
return(Ok("Ok"));
}
}
public bool IsUserValid(Models.Authentication.ViewModels.AuthViewModel authModel)
{
bool isValid = false;
using (var con = GetConnection(""))
{
con.Open();
StringBuilder sb = new StringBuilder();
sb.Append("SELECT ").AppendLine();
sb.Append(" id ").Append(" AS ").Append(" id ").Append(", ").AppendLine();
sb.Append(" FROM ").Append(" ").AppendLine();
sb.Append(" WHERE ").AppendLine();
sb.Append(" UserName ").Append(" = ").Append("@userName").AppendLine();
sb.Append(" AND ").AppendLine();
sb.Append(" QbToken ").Append(" = ").Append("@qbToken").AppendLine();
sb.Append(" AND ").AppendLine();
sb.Append(" QbTicket ").Append(" = ").Append("@qbTicket").AppendLine();
var auth = con.Query <int>(sb.ToString(), new
{
userName = authModel.UserNameIncoming,
qbToken = authModel.QbTokenIncoming,
qbTicket = authModel.QbTicketIncoming
}).FirstOrDefault();
if (authModel != null)
{
isValid = true;
}
}
return(isValid);
}
public ActionResult FetchTokenData(Models.Authentication.ViewModels.AuthViewModel auth)
{
var response = new
{
Validates = iAuth.IsUserValid(auth),
ticket = RandomGenerators.RandomGenerator.GenerateRandomWord(26),
token = RandomGenerators.RandomGenerator.GenerateRandomWord(25)
};
return(Json(response));
}
public bool IsUserValid(Models.Authentication.ViewModels.AuthViewModel authModel)
{
StringBuilder cacheKey = new StringBuilder();
cacheKey.Append("CACHE_KEY_IS_USER_VALID").Append("_").Append("USER_ID").Append("_").Append(authModel.UserNameIncoming).Append("_").Append("QBTOKEN").Append("_").Append(authModel.QbTokenIncoming).Append("_").Append("QBTICKET").Append(authModel.QbTicketIncoming);
//var items = _cacheProvider.Retrieve<bool>(cacheKey.ToString());
//if (string.IsNullOrEmpty(items.ToString()))
//{
// items = _commonRepository.IsUserValid(authModel);
// if (!string.IsNullOrEmpty(items.ToString()))
// {
// _cacheProvider.Store(cacheKey.ToString(), items, int.MaxValue);
// }
//}
bool items = true;
return(items);
}
