public HttpResponseMessage GetConfigValue(HttpRequestMessage request, RequestOrderListDTO obj)
{
return(CreateHttpResponse(request, () =>
{
HttpResponseMessage response;
try { response = request.CreateResponse(HttpStatusCode.OK, ConfigurationManager.ConnectionStrings[obj.KeyWord].ConnectionString); }
catch { return null; }
return response;
}));
}
public ResultDTO GetAfiliateListByAccount(RequestOrderListDTO obj)
{
ResultDTO accInfo = new ResultDTO();
try
{
accInfo = _repository.GetAfiliateListByAccount(obj);
}
catch (Exception ex)
{
Utilities.AppLog.WriteLog("GetAfiliateListByAccount", ActionType.GetData, ex.Message.ToString(), obj.SessionKey);
accInfo.StatusCode = Utilities.Common.ConvertErrorCodeToInt(RetCode.ECS9999);
accInfo.StatusMsg = ex.Message.ToString();
}
return(accInfo);
}
public static ResultDTO GetAfiliateListByAccount(this IEntityBaseRepository <Affiliate> repository, RequestOrderListDTO obj)
{
var result = new ResultDTO();
var dbContext = new ApplicationContext();
var errorCode = new SqlParameter("ErrorCode", System.Data.SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Output
};
result.Details = dbContext.Database.SqlQuery <AfiliateItemDTO>("EXEC [dbo].[sp_GetAfiliateListByAccount] @UserName,@SessionKey, @errorCode out",
new SqlParameter("UserName", DB.SafeSQL(obj.UserName)),
new SqlParameter("SessionKey", DB.SafeSQL(obj.SessionKey)),
errorCode).ToList <AfiliateItemDTO>();
result.StatusCode = int.Parse(errorCode.Value.ToString(), 0);
result.SetContentMsg();
return(result);
}
public HttpResponseMessage GetAfiliateListByAccount(HttpRequestMessage request, RequestOrderListDTO obj)
{
return(CreateHttpResponse(request, () =>
{
HttpResponseMessage response = null;
response = request.CreateResponse(HttpStatusCode.OK, _service.GetAfiliateListByAccount(obj));
return response;
}));
}
