public ResponseBo GetListCount(CommentGetListCriteriaBo criteriaBo)
{
ResponseBo responseBo = new ResponseBo();
try
{
using (SqlConnection conn = DbAccess.Connection.GetConn())
{
var p = new DynamicParameters();
base.AddStandartSpParams(ref p, criteriaBo);
p.Add("@CaseId", criteriaBo.CaseId, DbType.Int32, ParameterDirection.Input);
p.Add("@CommentTypeId", criteriaBo.CommentTypeId, DbType.Int32, ParameterDirection.Input);
p.Add("@ProductId", criteriaBo.ProductId, DbType.Int64, ParameterDirection.Input);
p.Add("@PersonId", criteriaBo.PersonId, DbType.Int64, ParameterDirection.Input);
conn.Execute("spCommentListCount", p, commandType: CommandType.StoredProcedure);
responseBo.Message = p.Get <string>("@Message");
responseBo.IsSuccess = p.Get <bool>("@IsSuccess");
responseBo.ReturnedId = p.Get <long?>("@ReturnedId");
}
}
catch (Exception ex)
{
responseBo = base.SaveExLog(ex, this.GetType(), MethodBase.GetCurrentMethod().Name, criteriaBo);
}
return(responseBo);
}
public ResponseBo <List <CommentListBo> > GetList(CommentGetListCriteriaBo criteriaBo)
{
ResponseBo <List <CommentListBo> > responseBo = new ResponseBo <List <CommentListBo> >();
try
{
using (SqlConnection conn = DbAccess.Connection.GetConn())
{
var p = new DynamicParameters();
base.AddStandartSpParams(ref p, criteriaBo);
p.Add("@CaseId", criteriaBo.CaseId, DbType.Int32, ParameterDirection.Input);
p.Add("@CommentTypeId", criteriaBo.CommentTypeId, DbType.Int32, ParameterDirection.Input);
p.Add("@CommentSortTypeId", criteriaBo.CommentSortTypeId, DbType.Int32, ParameterDirection.Input);
p.Add("@ProductId", criteriaBo.ProductId, DbType.Int64, ParameterDirection.Input);
p.Add("@PersonId", criteriaBo.PersonId, DbType.Int64, ParameterDirection.Input);
p.Add("@CommentId", criteriaBo.CommentId, DbType.Int64, ParameterDirection.Input);
p.Add("@PageOffSet", criteriaBo.PageOffSet, DbType.Int32, ParameterDirection.Input);
responseBo.Bo = conn.Query <CommentListBo>("spCommentList", p, commandType: CommandType.StoredProcedure).ToList();
responseBo.Message = p.Get <string>("@Message");
responseBo.IsSuccess = p.Get <bool>("@IsSuccess");
}
}
catch (Exception ex)
{
responseBo = base.SaveExLog(ex, this.GetType(), MethodBase.GetCurrentMethod().Name, criteriaBo).ToResponse <List <CommentListBo> >();
}
return(responseBo);
}
public ResponseDto GetListCount(CommentGetListCriteriaDto criteriaDto)
{
ResponseDto responseDto = new ResponseDto();
CommentGetListCriteriaBo criteriaBo = new CommentGetListCriteriaBo()
{
CaseId = criteriaDto.CaseId,
CommentTypeId = criteriaDto.CommentTypeId,
ProductId = criteriaDto.ProductId,
PersonId = criteriaDto.PersonId,
Session = Session
};
ResponseBo responseBo = commentBusiness.GetListCount(criteriaBo);
responseDto = responseBo.ToResponseDto();
return(responseDto);
}
public ResponseDto <List <CommentListDto> > GetList(CommentGetListCriteriaDto criteriaDto)
{
CommentGetListCriteriaBo criteriaBo = new CommentGetListCriteriaBo()
{
CaseId = criteriaDto.CaseId,
CommentTypeId = criteriaDto.CommentTypeId,
CommentSortTypeId = criteriaDto.CommentSortTypeId,
ProductId = criteriaDto.ProductId,
PersonId = criteriaDto.PersonId,
CommentId = criteriaDto.CommentId,
PageOffSet = criteriaDto.PageOffSet,
Session = Session
};
ResponseBo <List <CommentListBo> > responseBo = commentBusiness.GetList(criteriaBo);
ResponseDto <List <CommentListDto> > responseDto = responseBo.ToResponseDto <List <CommentListDto>, List <CommentListBo> >();
if (responseBo.IsSuccess && responseBo.Bo != null)
{
responseDto.Dto = new List <CommentListDto>();
foreach (CommentListBo itemBo in responseBo.Bo)
{
responseDto.Dto.Add(new CommentListDto()
{
Id = itemBo.Id,
CommentTypeId = itemBo.CommentTypeId,
IsAuthorSeller = itemBo.IsAuthorSeller,
AuthorPersonFullName = itemBo.AuthorPersonFullName,
LanguageId = itemBo.LanguageId,
Comment = itemBo.Comment,
Star = itemBo.Star,
OrderId = itemBo.OrderId,
ProductId = itemBo.ProductId,
PersonId = itemBo.PersonId,
OrderProductId = itemBo.OrderProductId,
PersonFullName = itemBo.PersonFullName,
ProductName = itemBo.ProductName,
ProductTypeId = itemBo.ProductTypeId,
CreateDateNumber = itemBo.CreateDate.ToNumberFromDateTime(),
UpdateDateNumber = itemBo.UpdateDate.ToNumberFromDateTimeNull(),
LikeCount = itemBo.LikeCount,
DislikeCount = itemBo.DislikeCount,
MyLike = itemBo.MyLike,
RelatedCommentId = itemBo.RelatedCommentId
});
}
}
return(responseDto);
}
