public IList <Produk> GetByName(string name, string sortBy, int pageNumber, int pageSize, ref int pagesCount)
{
IList <Produk> oList = new List <Produk>();
try
{
name = "%" + name.ToLower() + "%";
var sqlPageCount = SQL_TEMPLATE_FOR_PAGING.Replace("{WHERE}", "WHERE LOWER(m_produk.nama_produk) LIKE @name OR LOWER(m_produk.kode_produk) LIKE @name");
pagesCount = _context.GetPagesCount(sqlPageCount, pageSize, new { name });
sortBy = string.Format("ORDER BY {0}", sortBy);
_sql = SQL_TEMPLATE.Replace("{WHERE}", "WHERE LOWER(m_produk.nama_produk) LIKE @name OR LOWER(m_produk.kode_produk) LIKE @name");
_sql = _sql.Replace("{ORDER BY}", sortBy);
_sql = _sql.Replace("{OFFSET}", "OFFSET @pageSize * (@pageNumber - 1) LIMIT @pageSize");
oList = MappingRecordToObject(_sql, new { name, pageNumber, pageSize }).ToList();
foreach (var item in oList)
{
item.list_of_harga_grosir = GetListHargaGrosir(item.produk_id);
}
}
catch (Exception ex)
{
_log.Error("Error:", ex);
}
return(oList);
}
public IList <JualProduk> GetByName(string name, int pageNumber, int pageSize, ref int pagesCount)
{
IList <JualProduk> oList = new List <JualProduk>();
try
{
name = "%" + name.ToLower() + "%";
var sqlPageCount = SQL_TEMPLATE_FOR_PAGING.Replace("{WHERE}", "WHERE LOWER(m_customer.nama_customer) LIKE @name OR LOWER(t_jual_produk.keterangan) LIKE @name");
pagesCount = _context.GetPagesCount(sqlPageCount, pageSize, new { name });
_sql = SQL_TEMPLATE.Replace("{WHERE}", "WHERE LOWER(m_customer.nama_customer) LIKE @name OR LOWER(t_jual_produk.keterangan) LIKE @name");
_sql = _sql.Replace("{ORDER BY}", "ORDER BY t_jual_produk.tanggal DESC, t_jual_produk.nota");
_sql = _sql.Replace("{OFFSET}", "OFFSET @pageSize * (@pageNumber - 1) LIMIT @pageSize");
oList = MappingRecordToObject(_sql, new { name, pageNumber, pageSize }).ToList();
// load item jual
foreach (var item in oList)
{
item.item_jual = GetItemJual(item.jual_id);
}
}
catch (Exception ex)
{
_log.Error("Error:", ex);
}
return(oList);
}
public IList <BeliProduk> GetByName(string name, int pageNumber, int pageSize, ref int pagesCount)
{
IList <BeliProduk> oList = new List <BeliProduk>();
try
{
name = "%" + name.ToLower() + "%";
var sqlPageCount = SQL_TEMPLATE_FOR_PAGING.Replace("{WHERE}", "WHERE LOWER(m_supplier.nama_supplier) LIKE @name OR LOWER(t_beli_produk.keterangan) LIKE @name");
pagesCount = _context.GetPagesCount(sqlPageCount, pageSize, new { name });
_sql = SQL_TEMPLATE.Replace("{WHERE}", "WHERE LOWER(m_supplier.nama_supplier) LIKE @name OR LOWER(t_beli_produk.keterangan) LIKE @name");
_sql = _sql.Replace("{ORDER BY}", "ORDER BY t_beli_produk.tanggal DESC, t_beli_produk.nota");
_sql = _sql.Replace("{OFFSET}", "LIMIT @pageSize OFFSET @pageSize * (@pageNumber - 1)");
oList = MappingRecordToObject(_sql, new { name, pageNumber, pageSize }).ToList();
}
catch (Exception ex)
{
_log.Error("Error:", ex);
}
return(oList);
}