public IPenjualanModel GetByNoNota(object noNota)
{
var dataAccessStatus = new DataAccessStatus();
using (var context = new DbContext())
{
var queryStr = "SELECT * FROM penjualan WHERE no_nota = @noNota";
var model = context.Conn.Query <PenjualanModel>(queryStr, new { noNota }).FirstOrDefault();
if (model != null)
{
if (model.pelanggan_id != default(uint))
{
var pelangganModel = context.Conn.Get <PelangganModel>(model.pelanggan_id);
if (pelangganModel != null)
{
model.Pelanggan = pelangganModel;
}
}
var pdRepo = new PenjualanDetailRepository(context);
model.PenjualanDetails = pdRepo.GetAll(model);
}
return(model);
}
}
private IEnumerable <PenjualanModel> MappingObjects(DbContext context, IEnumerable <PenjualanModel> listObj)
{
if (listObj != null && listObj.ToList().Count > 0)
{
listObj = listObj.Map(p =>
{
if (p.pelanggan_id != default(uint))
{
p.Pelanggan = context.Conn.Get <PelangganModel>(p.pelanggan_id);
}
});
var pdRepo = new PenjualanDetailRepository(context);
foreach (var p in listObj)
{
p.PenjualanDetails = pdRepo.GetAll(p);
}
}
return(listObj);
}