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); }