public ResponseBo <FicheBo> Get(FicheGetCriteriaBo criteriaBo)
{
ResponseBo <FicheBo> responseBo = new ResponseBo <FicheBo>();
try
{
using (SqlConnection conn = DbAccess.Connection.GetConn())
{
var p = new DynamicParameters();
p.Add("@Message", dbType: DbType.String, direction: ParameterDirection.Output, size: 255);
p.Add("@IsSuccess", dbType: DbType.Boolean, direction: ParameterDirection.Output);
p.Add("@FicheJson", dbType: DbType.String, direction: ParameterDirection.Output, size: 4000);
p.Add("@MyPersonId", criteriaBo.MyPersonId, DbType.Int64, ParameterDirection.Input);
p.Add("@FicheId", criteriaBo.FicheId, DbType.Int64, ParameterDirection.Input);
p.Add("@OperatorRealId", criteriaBo.Session.RealPerson.Id, DbType.Int64, ParameterDirection.Input);
p.Add("@LanguageId", criteriaBo.Session.RealPerson.LanguageId, DbType.Int32, ParameterDirection.Input);
conn.Execute("spFicheGet", p, commandType: CommandType.StoredProcedure);
responseBo.Message = p.Get <string>("@Message");
responseBo.IsSuccess = p.Get <bool>("@IsSuccess");
string ficheJson = p.Get <string>("@FicheJson");
responseBo.Bo = JsonConvert.DeserializeObject <FicheBo>(ficheJson);
}
}
catch (Exception ex)
{
responseBo = base.SaveExLog(ex, this.GetType(), MethodBase.GetCurrentMethod().Name, criteriaBo).ToResponse <FicheBo>();
}
return(responseBo);
}
public ResponseDto <FicheDto> Get(FicheGetCriteriaDto criteriaDto)
{
FicheGetCriteriaBo criteriaBo = new FicheGetCriteriaBo()
{
MyPersonId = criteriaDto.MyPersonId,
FicheId = criteriaDto.FicheId,
Session = Session
};
ResponseBo <FicheBo> responseBo = ficheBusiness.Get(criteriaBo);
ResponseDto <FicheDto> responseDto = responseBo.ToResponseDto <FicheDto, FicheBo>();
if (responseBo.IsSuccess && responseBo.Bo != null)
{
responseDto.Dto = new FicheDto()
{
Id = responseBo.Bo.Id,
DebtPersonId = responseBo.Bo.DebtPersonId,
CreditPersonId = responseBo.Bo.CreditPersonId,
FicheTypeId = responseBo.Bo.FicheTypeId,
CurrencyId = responseBo.Bo.CurrencyId,
ApprovalStatId = responseBo.Bo.ApprovalStatId,
IncludingVat = responseBo.Bo.IncludingVat,
FicheContentId = responseBo.Bo.FicheContentId,
FicheContentGroupId = responseBo.Bo.FicheContentGroupId,
PrintedCode = responseBo.Bo.PrintedCode,
IssueDateNumber = responseBo.Bo.IssueDate.ToNumberFromDateTime(),
GrandTotal = responseBo.Bo.GrandTotal,
Total = responseBo.Bo.Total,
RowDiscountTotal = responseBo.Bo.RowDiscountTotal,
UnderDiscountRate = responseBo.Bo.UnderDiscountRate,
UnderDiscountTotal = responseBo.Bo.UnderDiscountTotal,
Notes = responseBo.Bo.Notes,
IsUncompleted = responseBo.Bo.ApprovalStatId == Enums.ApprovalStats.xUncompleted,
MoneyList = responseBo.Bo.MoneyList == null ? null :
(from x in responseBo.Bo.MoneyList
select new FicheMoneyDto
{
Id = x.Id,
DebtPersonAccountId = x.DebtPersonAccountId,
CreditPersonAccountId = x.CreditPersonAccountId,
Total = x.Total,
DebtPersonAccountTypeId = x.DebtPersonAccountTypeId,
CreditPersonAccountTypeId = x.CreditPersonAccountTypeId,
Notes = x.Notes
}).ToList()
};
}
return(responseDto);
}
