public IActionResult getWarehouseData(ParamWarehouse data)
{
MonWarehouseAvailableDL dal = new MonWarehouseAvailableDL();
MonWarehouseAvailableModel hasil = new MonWarehouseAvailableModel();
/**
* This params is for pagination function
*/
if (!string.IsNullOrEmpty(data.limit) && data.limit != "string" && !string.IsNullOrEmpty(data.page) && data.page != "string")
{
data.page = data.page;
data.limit = data.limit;
}
else if (!string.IsNullOrEmpty(data.page) && data.page != "string" && string.IsNullOrEmpty(data.limit) && data.limit != "string")
{
data.page = data.page;
data.limit = "10";
}
else if (!string.IsNullOrEmpty(data.limit) && data.limit != "string" && string.IsNullOrEmpty(data.page) && data.page != "string")
{
data.page = "1";
data.limit = data.limit;
}
else
{
data.page = "1";
data.limit = "10";
}
IEnumerable <WarehouseData> result = dal.getWarehouseData(data);
hasil.message = "Success";
hasil.status = "S";
hasil.count = result.Cast <Object>().Count();
hasil.data = new PagedList <WarehouseData>(result.ToList(), Convert.ToInt32(data.page), Convert.ToInt32(data.limit));
return(Ok(hasil));
}
public IEnumerable <WarehouseData> getWarehouseData(ParamWarehouse paramWarehouse)
{
IEnumerable <WarehouseData> result = null;
using (IDbConnection connection = Extension.GetConnection(1))
{
try
{
string paramKdRegion = null;
if (!string.IsNullOrEmpty(paramWarehouse.kd_region) && paramWarehouse.kd_region != "string")
{
paramKdRegion = " AND T_STORAGE_CARGO_DETAIL.KD_REGION='" + paramWarehouse.kd_region + "'";
}
string paramKdCabang = null;
if (!string.IsNullOrEmpty(paramWarehouse.kd_cabang) && paramWarehouse.kd_cabang != "string")
{
paramKdCabang = " AND T_STORAGE_CARGO_DETAIL.KD_CABANG='" + paramWarehouse.kd_cabang + "'";
}
string paramKdTerminal = null;
if (!string.IsNullOrEmpty(paramWarehouse.kd_terminal) && paramWarehouse.kd_terminal != "string")
{
paramKdTerminal = " AND T_STORAGE_CARGO_DETAIL.KD_TERMINAL='" + paramWarehouse.kd_terminal + "'";
}
string paramSearch = null;
if (!string.IsNullOrEmpty(paramWarehouse.search_key) && paramWarehouse.search_key != "string" && paramWarehouse.is_searching == true)
{
paramSearch = " WHERE PELANGGAN LIKE '" + paramWarehouse.search_key + "%'";
}
string paramSort = null;
if (!string.IsNullOrEmpty(paramWarehouse.order_by_column) && paramWarehouse.order_by_column != "string" && !string.IsNullOrEmpty(paramWarehouse.order_by_sort) && paramWarehouse.order_by_sort != "string")
{
paramSort = " ORDER BY T_STORAGE_CARGO_DETAIL." + paramWarehouse.order_by_column + " " + paramWarehouse.order_by_sort;
}
string sql = "SELECT * FROM (" +
"SELECT " +
"DISTINCT(T_STORAGE_CARGO_DETAIL.PELANGGAN), " +
"COUNT(T_STORAGE_CARGO_DETAIL.NAMA_BARANG) JUMLAH_BARANG, " +
"T_STORAGE_CARGO_DETAIL.NAMA_VAK, " +
"T_STORAGE_CARGO_DETAIL.KD_REGION, " +
"T_STORAGE_CARGO_DETAIL.KD_TERMINAL, " +
"T_STORAGE_CARGO_DETAIL.KD_CABANG, " +
"APP_REGIONAL.REGIONAL_NAMA NAMA_REGIONAL " +
"FROM T_STORAGE_CARGO_DETAIL JOIN APP_REGIONAL " +
"ON T_STORAGE_CARGO_DETAIL.KD_REGION=APP_REGIONAL.ID " +
"AND APP_REGIONAL.PARENT_ID IS NULL " +
"AND APP_REGIONAL.ID NOT IN (12300000,20300001)" + paramKdRegion + paramKdCabang + paramKdTerminal +
" GROUP BY PELANGGAN, KD_REGION, KD_CABANG, KD_TERMINAL, NAMA_VAK, REGIONAL_NAMA " + paramSort +
")" + paramSearch;
result = connection.Query <WarehouseData>(sql);
}
catch (Exception)
{
result = null;
}
}
return(result);
}
