public void OpenSession(string url, bool forceSession)
{
string Login = string.Empty;
string Password = string.Empty;
using (AvtoritetEntities ae = new AvtoritetEntities())
{
string sql = "SELECT TOP (1) dbo.ProviderAccount.Login, dbo.ProviderAccount.Password\r\n FROM dbo.Provider INNER JOIN\r\n dbo.ProviderAccount ON dbo.Provider.ProviderId = dbo.ProviderAccount.ProviderId\r\n WHERE(dbo.Provider.Uri LIKE N'%imtportal.gm.com/chevrolet%') AND(dbo.ProviderAccount.Enable = 1)";
ProvAcc provider = ae.Database.SqlQuery <ProvAcc>(sql, new object[0]).FirstOrDefault <ProvAcc>();
if (provider != null)
{
Login = provider.Login;
Password = provider.Password;
}
}
//Login = "******";
//Password = "******";
this.requestHandler = RequestHandlerFactory.Create(url, Login, Password, null);
HttpResponseMessage responseMessage = this.GetResponse(url, forceSession, this.requestHandler, ChevroletPortal.CookieContainer);
if (responseMessage != null)
{
this.requestHandler.GetSessionResultAsync(responseMessage);
}
}
public void OpenSession(string url, bool forceSession)
{
string Login = string.Empty;
string Password = string.Empty;
using (AvtoritetEntities ae = new AvtoritetEntities())
{
string sql = "SELECT dbo.ProviderAccount.Login, dbo.ProviderAccount.Password\r\n FROM dbo.Provider INNER JOIN\r\n dbo.ProviderAccount ON dbo.Provider.ProviderId = dbo.ProviderAccount.ProviderId\r\n WHERE(dbo.Provider.Uri LIKE N'%partslink%') AND(dbo.ProviderAccount.Enable = 1)";
System.Collections.Generic.List <ProvAcc> provider = ae.Database.SqlQuery <ProvAcc>(sql, new object[0]).ToList <ProvAcc>();
if (provider.Count > 0)
{
System.Random random = new System.Random();
int randomValue = (provider.Count > 1) ? random.Next(provider.Count - 1) : 0;
Login = provider[randomValue].Login;
Password = provider[randomValue].Password;
}
}
this.requestHandler = RequestHandlerFactory.Create(url, Login, Password, null);
HttpResponseMessage responseMessage = this.GetResponse(url, forceSession, this.requestHandler, PartslinkPortal.CookieContainer);
if (responseMessage != null)
{
this.requestHandler.GetSessionResultAsync(responseMessage);
}
}
public override void OpenSession(string url, long providerId, bool forceSession)
{
string url_session = string.Empty;
int validateSession = -1;
//uri = new Uri(url);
//urlSession = string.Format("{0}://{1}/", uri.Scheme, uri.Host);
url_session = url;
if (!((validateSession = GetValidateSession(url_session, forceSession, ChevroletPortal.CookieContainer)) == 0))
{
string login = string.Empty,
password = string.Empty;
if (validateSession == -1)
{
using (AvtoritetEntities ae = new AvtoritetEntities()) {
string sql =
//string.Format(
////"SELECT TOP (1) dbo.ProviderAccount.Login, dbo.ProviderAccount.Password\r\n FROM dbo.Provider INNER JOIN\r\n dbo.ProviderAccount ON dbo.Provider.ProviderId = dbo.ProviderAccount.ProviderId\r\n WHERE(dbo.Provider.Uri LIKE N'%{0}%') AND(dbo.ProviderAccount.Enable = 1)"
////, CatalogApi.UrlConstants.ChevroletOpelGroupRoot)
//"SELECT TOP (1) dbo.ProviderAccount.Login, dbo.ProviderAccount.Password{0}{1}"
// + "FROM dbo.Provider{0}{1}"
// + "INNER JOIN dbo.ProviderAccount ON dbo.Provider.ProviderId = dbo.ProviderAccount.ProviderId{0}{1}"
// + "WHERE(dbo.Provider.Uri = N'{2}') AND (dbo.ProviderAccount.Enable = 1)"
// , "\r\n", " ", url_session)
GetQueryCreditionals(providerId)
;
ProvAcc provider = ae.Database.SqlQuery <ProvAcc>(sql, new object[0]).FirstOrDefault <ProvAcc>();
if (provider != null)
{
login = provider.Login;
password = provider.Password;
}
}
//uri = new Uri(url);
//urlSession = string.Format("{0}://{1}/", uri.Scheme, uri.Host);
url_session = url;
this.m_requestHandler = RequestHandlerFactory.Create(url_session, login, password, null);
}
else
{
;
}
}
else
{
;
}
HttpResponseMessage responseMessage = this.GetResponse(url_session, providerId, validateSession, this.m_requestHandler, ChevroletPortal.CookieContainer);
if (responseMessage != null)
{
this.m_requestHandler.GetSessionResultAsync(responseMessage);
}
}
public override void OpenSession(string url, long providerId, bool forceSession)
{
string url_session = url;
int validateSession = -1;
if (!((validateSession = GetValidateSession(url_session, forceSession, PartslinkPortal.CookieContainer)) == 0))
{
string login = string.Empty
, password = string.Empty;
if (validateSession < 0)
{
using (AvtoritetEntities ae = new AvtoritetEntities()) {
string sql =
string.Format("SELECT dbo.ProviderAccount.Login, dbo.ProviderAccount.Password{1}{0}{0}{0}{0}"
+ "FROM dbo.Provider{1}{0}{0}{0}{0}"
+ "INNER JOIN dbo.ProviderAccount ON dbo.Provider.ProviderId = dbo.ProviderAccount.ProviderId{1}{0}{0}{0}{0}"
+ "WHERE(dbo.Provider.Uri LIKE N'%{2}%') AND (dbo.ProviderAccount.Enable = 1)"
, " "
, "\r\n"
, ResourceManager.Urls[CatalogApi.UrlConstants.Key.PartslinkRoot])
//GetQueryCreditionals(providerId)
;
System.Collections.Generic.List <ProvAcc> provider = ae.Database.SqlQuery <ProvAcc>(sql, new object[0]).ToList <ProvAcc>();
if (provider.Count > 0)
{
System.Random random = new System.Random();
int randomValue = (provider.Count > 1) ? random.Next(provider.Count - 1) : 0;
login = provider[randomValue].Login;
password = provider[randomValue].Password;
}
}
this.m_requestHandler = RequestHandlerFactory.Create(url_session, login, password, null);
}
else
{
;
}
}
else
{
;
}
HttpResponseMessage responseMessage = this.GetResponse(url_session, providerId, validateSession, this.m_requestHandler, PartslinkPortal.CookieContainer);
if (responseMessage != null)
{
this.m_requestHandler.GetSessionResultAsync(responseMessage);
}
else
{
;
}
}
public AggregateReportApi()
{
_getAggregatedHeadLineStatisticsRequestHandler = RequestHandlerFactory.Create <IGetAggregatedHeadlineStatisticsRequestHandler>();
_getAggregatedTrustStatisticsRequestHandler = RequestHandlerFactory.Create <IGetAggregatedTrustStatisticsRequestHandler>();
_getAggregatedComplianceStatisticsRequestHandler = RequestHandlerFactory.Create <IGetAggregatedComplianceStatisticsRequestHandler>();
_getAggregatedDispositionStatisticsRequestHandler = RequestHandlerFactory.Create <IGetAggregatedDispositionStatisticsRequestHandler>();
_getDailyHeadLineStatisticsRequestHandler = RequestHandlerFactory.Create <IGetDailyHeadlineStatisticsRequestHandler>();
_getDailyTrustStatisticsRequestHandler = RequestHandlerFactory.Create <IGetDailyTrustStatisticsRequestHandler>();
_getDailyComplianceStatisticsRequestHandler = RequestHandlerFactory.Create <IGetDailyComplianceStatisticsRequestHandler>();
_getDailyDispositionStatisticsRequestHandler = RequestHandlerFactory.Create <IGetDailyDispositionStatisticsRequestHandler>();
_getDomainSearchRequestHandler = RequestHandlerFactory.Create <IGetMatchingDomainsRequestHandler>();
}
public override void OpenSession(string url, long providerId, bool forceSession)
{
string url_session = url;
int validateSession = -1;
if (!((validateSession = GetValidateSession(url_session, forceSession, PeugeotPortal.CookieContainer)) == 0))
{
string login = string.Empty
, password = string.Empty;
if (validateSession < 0)
{
using (AvtoritetEntities ae = new AvtoritetEntities()) {
string sql =
//string.Format("SELECT TOP (1) dbo.ProviderAccount.Login, dbo.ProviderAccount.Password{0}"
// + " FROM dbo.Provider{0}"
// + " INNER JOIN dbo.ProviderAccount ON dbo.Provider.ProviderId = dbo.ProviderAccount.ProviderId{0}"
// + " WHERE(dbo.Provider.Uri LIKE N'%peugeot%') AND(dbo.ProviderAccount.Enable = 1)"
// , "\r\n")
GetQueryCreditionals(providerId)
;
ProvAcc provider = ae.Database.SqlQuery <ProvAcc>(sql, new object[0]).FirstOrDefault <ProvAcc>();
login = provider.Login;
password = provider.Password;
}
this.m_requestHandler = RequestHandlerFactory.Create(url_session, login, password, null);
}
else
{
;
}
}
else
{
;
}
HttpResponseMessage responseMessage = this.GetResponse(url_session, providerId, validateSession, this.m_requestHandler, PeugeotPortal.CookieContainer);
if (responseMessage != null)
{
this.m_requestHandler.GetSessionResultAsync(responseMessage);
}
else
{
;
}
}
public void CloseSession(string url)
{
if (this.requestHandler != null)
{
this.requestHandler.Close(CitroenPortal.CookieContainer).Wait();
}
else
{
IRequestHandler request = RequestHandlerFactory.Create(url, string.Empty, string.Empty, null);
if (request != null)
{
request.Close(CitroenPortal.CookieContainer).Wait();
}
}
ConsoleHelper.Info("Session was closed");
}
public bool IsServiceAvailable()
{
bool result;
try
{
CookieContainer cookieContainer = new CookieContainer();
IRequestHandler requestHandler = RequestHandlerFactory.Create("http://www.partslink24.com/", string.Empty, string.Empty, null);
Task <HttpResponseMessage> responseMessage = requestHandler.GetSessionAsync("http://www.partslink24.com/", cookieContainer);
string content = responseMessage.Result.Content.ReadAsStringAsync().Result;
result = (!content.Contains("maintenance_general") && int.Parse(RequestProcessor.GetConfig("Partslink")) > 0);
}
catch (System.Exception ex)
{
ErrorLogHelper.AddErrorInLog("IsServiceAvailable()", ex.Message + "|" + ex.StackTrace);
ConsoleHelper.Error(string.Format("{0} || {1} || {2}", ex.Message, ex.StackTrace, ex.Data));
result = false;
}
return(result);
}
