public IActionResult getWarehouseData(ParamWarehouseDataVAKContent data)
{
MonWarehouseDataVAKContentDL dal = new MonWarehouseDataVAKContentDL();
MonWarehouseDataVAKContentModel hasil = new MonWarehouseDataVAKContentModel();
/**
* 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 <WarehouseDataVAKContent> result = dal.getWarehouseDataVAKContent(data);
hasil.message = "Success";
hasil.status = "S";
hasil.count = result.Cast <Object>().Count();
hasil.data = new PagedList <WarehouseDataVAKContent>(result.ToList(), Convert.ToInt32(data.page), Convert.ToInt32(data.limit));
return(Ok(hasil));
}
public IEnumerable <WarehouseDataVAKContent> getWarehouseDataVAKContent(ParamWarehouseDataVAKContent paramWarehouse)
{
IEnumerable <WarehouseDataVAKContent> 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 paramNamaPelanggan = null;
if (!string.IsNullOrEmpty(paramWarehouse.nama_pelanggan) && paramWarehouse.nama_pelanggan != "string")
{
paramNamaPelanggan = " AND T_STORAGE_CARGO_DETAIL.PELANGGAN='" + paramWarehouse.nama_pelanggan + "'";
}
string paramNamaVak = null;
if (!string.IsNullOrEmpty(paramWarehouse.nama_vak) && paramWarehouse.nama_vak != "string")
{
paramNamaVak = " AND T_STORAGE_CARGO_DETAIL.NAMA_VAK='" + paramWarehouse.nama_vak + "'";
}
string paramSearch = null;
if (!string.IsNullOrEmpty(paramWarehouse.search_key) && paramWarehouse.search_key != "string" && paramWarehouse.is_searching == true)
{
paramSearch = " WHERE PELANGGAN LIKE '" + paramWarehouse.search_key + "%' OR NAMA_VAK LIKE '" + paramWarehouse.search_key + "%' OR NAMA_BARANG LIKE '" + paramWarehouse.search_key + "%' OR NAMA_KAPAL 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 paramTgl = "";
if (!string.IsNullOrEmpty(paramWarehouse.tgl_mulai) && paramWarehouse.tgl_mulai != "string")
{
paramTgl = " WHERE TGL_MULAI IS NOT NULL AND TO_CHAR(TGL_MULAI, 'YYYY-MM-DD HH24:MI') < '" + paramWarehouse.tgl_mulai + "'";
}
string paramCreated = "";
if (!string.IsNullOrEmpty(paramWarehouse.created_date) && paramWarehouse.created_date != "string")
{
paramTgl = " WHERE CREATED_DATE IS NOT NULL AND TO_CHAR(CREATED_DATE, 'YYYY-MM-DD HH24:MI') = '" + paramWarehouse.created_date + "'";
}
string sql = "SELECT * FROM(" +
"SELECT T_STORAGE_CARGO_DETAIL.*, 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 + paramNamaPelanggan + paramNamaVak + paramSort +
")" + paramSearch + paramCreated + paramTgl;
result = connection.Query <WarehouseDataVAKContent>(sql);
}
catch (Exception)
{
result = null;
}
}
return(result);
}
