public ResultDTO GetFunnalDetailByPublic(RequestNextSoloDTO obj)
{
ResultDTO accInfo = null;
try
{
accInfo = _repository.GetFunnalDetailByPublic(obj);
}
catch (Exception ex)
{
Utilities.AppLog.WriteLog("GetFunnalDetailByPublic", ActionType.GetData, ex.Message.ToString(), obj.SessionKey);
accInfo.StatusCode = Utilities.Common.ConvertErrorCodeToInt(RetCode.ECS9999);
accInfo.StatusMsg = ex.Message.ToString();
}
return(accInfo);
}
public static ResultDTO GetFunnalDetailByPublic(this IEntityBaseRepository <LandingPage> repository, RequestNextSoloDTO obj)
{
var result = new ResultDTO();
FunnalDetailDTO funnalDetail = new FunnalDetailDTO();
var dbContext = new ApplicationContext();
var errorCode = new SqlParameter("ErrorCode", System.Data.SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Output
};
var pageName = new SqlParameter("PageName", System.Data.SqlDbType.VarChar, 50)
{
Direction = System.Data.ParameterDirection.Output
};
var status = new SqlParameter("Status", System.Data.SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Output
};
try
{
funnalDetail.ID = obj.FunnalID;
funnalDetail.SoloObj = dbContext.Database.SqlQuery <NextSoloPageDTO>("EXEC [dbo].[sp_GetFunnalDetailByPublic] @FunnalID,@SoloID,@IsNext, @PageName out, @Status out, @ErrorCode out",
new SqlParameter("FunnalID", obj.FunnalID),
new SqlParameter("SoloID", obj.SoloID),
new SqlParameter("IsNext", obj.IsNext),
pageName,
status,
errorCode
).FirstOrDefault <NextSoloPageDTO>();
if (status != null && status.Value != null && !string.IsNullOrEmpty(status.Value.ToString()))
{
funnalDetail.Status = int.Parse(status.Value.ToString(), 0);
}
if (pageName != null && pageName.Value != null && !string.IsNullOrEmpty(pageName.Value.ToString()))
{
funnalDetail.PageName = pageName.Value.ToString();
}
result.StatusCode = int.Parse(errorCode.Value.ToString(), 0);
result.SetContentMsg();
if (result.StatusCode == 0)
{
result.Details = funnalDetail;
}
}
catch (Exception ex)
{
result.StatusCode = int.Parse(errorCode.Value.ToString(), 0);
result.Details = ex.Message;
}
return(result);
}
public HttpResponseMessage GetFunnalDetailByPublic(HttpRequestMessage request, RequestNextSoloDTO obj)
{
return(CreateHttpResponse(request, () =>
{
HttpResponseMessage response;
ResultDTO result = _service.GetFunnalDetailByPublic(obj);
response = request.CreateResponse(HttpStatusCode.OK, result);
return response;
}));
}
