public HttpResponseMessage GetDetailFunnalPage(HttpRequestMessage request, RequestViewDetaiDTO obj)
{
return(CreateHttpResponse(request, () =>
{
HttpResponseMessage response;
ResultDTO result = _service.GetDetailFunnalPage(obj);
response = request.CreateResponse(HttpStatusCode.OK, result);
return response;
}));
}
public ResultDTO GetDetailSoloPage(RequestViewDetaiDTO obj)
{
ResultDTO accInfo = null;
try
{
accInfo = _repository.GetDetailSoloPage(obj);
}
catch (Exception ex)
{
Utilities.AppLog.WriteLog("GetDetailSoloPage", ActionType.Login, ex.Message.ToString(), obj.SessionKey);
accInfo.StatusCode = Utilities.Common.ConvertErrorCodeToInt(RetCode.ECS9999);
accInfo.StatusMsg = ex.Message.ToString();
}
return(accInfo);
}
public static ResultDTO GetDetailSoloPage(this IEntityBaseRepository <LandingPage> repository, RequestViewDetaiDTO 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 <SoloPageItemDTO>("EXEC [dbo].[sp_GetDetailSoloPage] @ID,@UserName,@SessionKey,@errorCode out",
new SqlParameter("ID", obj.ID),
new SqlParameter("UserName", DB.SafeSQL(obj.UserName)),
new SqlParameter("SessionKey", DB.SafeSQL(obj.SessionKey)),
errorCode).FirstOrDefault <SoloPageItemDTO>();
result.StatusCode = int.Parse(errorCode.Value.ToString(), 0);
result.SetContentMsg();
return(result);
}
public static ResultDTO GetDetailFunnalPage(this IEntityBaseRepository <LandingPage> repository, RequestViewDetaiDTO obj)
{
var result = new ResultDTO();
var dbContext = new ApplicationContext();
var errorCode = new SqlParameter("ErrorCode", System.Data.SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Output
};
FunnalPageItem1DTO data = dbContext.Database.SqlQuery <FunnalPageItem1DTO>("EXEC [dbo].[sp_GetDetailFunnalPage] @ID,@UserName,@SessionKey,@errorCode out",
new SqlParameter("ID", obj.ID),
new SqlParameter("UserName", DB.SafeSQL(obj.UserName)),
new SqlParameter("SessionKey", DB.SafeSQL(obj.SessionKey)),
errorCode).FirstOrDefault <FunnalPageItem1DTO>();
if (data != null && !string.IsNullOrEmpty(data.StepList) && !string.IsNullOrEmpty(data.SoloIDList))
{
data.StepList = data.StepList.TrimEnd(',');
data.SoloIDList = data.SoloIDList.TrimEnd(',');
}
result.Details = data;
result.StatusCode = int.Parse(errorCode.Value.ToString(), 0);
result.SetContentMsg();
return(result);
}
