public IActionResult getListContainerContent(ParamContainerContent data)
{
MonContainerAvailableDetailContentDL dal = new MonContainerAvailableDetailContentDL();
MonContainerAvailableDetailContentModel hasil = new MonContainerAvailableDetailContentModel();
/**
* 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";
}
//if (!string.IsNullOrEmpty(data.kd_regional) && data.kd_regional != "string")
//{
IEnumerable <ContainerContentData> result = dal.getContainerAvailableDetailDataContent(data);
hasil.message = "Success";
hasil.status = "S";
hasil.count = result.Cast <Object>().Count();
hasil.data = new PagedList <ContainerContentData>(result.ToList(), Convert.ToInt32(data.page), Convert.ToInt32(data.limit));
/*}
* else
* {
*
* hasil.message = "Kode Regional Null !!!";
* hasil.status = "E";
* hasil.count = 0;
* }*/
return(Ok(hasil));
}
public IEnumerable <ContainerContentData> getContainerAvailableDetailDataContent(ParamContainerContent paramContainerContent)
{
IEnumerable <ContainerContentData> result = null;
using (IDbConnection connection = Extension.GetConnection(1))
{
try
{
string paramKodeRegional = "";
if (!string.IsNullOrEmpty(paramContainerContent.kd_regional) && paramContainerContent.kd_regional != "string")
{
paramKodeRegional = " AND T_STORAGE_CONTAINER_BOX_DETAIL.KD_REGIONAL ='" + paramContainerContent.kd_regional + "'";
}
string paramKodeCabang = "";
if (!string.IsNullOrEmpty(paramContainerContent.kd_cabang) && paramContainerContent.kd_cabang != "string")
{
paramKodeCabang = " AND T_STORAGE_CONTAINER_BOX_DETAIL.KD_CABANG ='" + paramContainerContent.kd_cabang + "'";
}
string paramKodeTerminal = "";
if (!string.IsNullOrEmpty(paramContainerContent.kd_terminal) && paramContainerContent.kd_terminal != "string")
{
paramKodeTerminal = " AND T_STORAGE_CONTAINER_BOX_DETAIL.KD_TERMINAL ='" + paramContainerContent.kd_terminal + "'";
}
string paramArea = "";
if (!string.IsNullOrEmpty(paramContainerContent.area) && paramContainerContent.area != "string")
{
paramArea = " AND T_STORAGE_CONTAINER_BOX_DETAIL.AREA ='" + paramContainerContent.area + "'";
}
string paramVoyageNo = "";
if (!string.IsNullOrEmpty(paramContainerContent.voyage_no) && paramContainerContent.voyage_no != "string")
{
paramVoyageNo = " AND T_STORAGE_CONTAINER_BOX_DETAIL.VOYAGE_NO ='" + paramContainerContent.voyage_no + "'";
}
string paramContainerNo = "";
if (!string.IsNullOrEmpty(paramContainerContent.container_no) && paramContainerContent.container_no != "string")
{
if (!string.IsNullOrEmpty(paramContainerContent.kd_regional) && paramContainerContent.kd_regional != "string")
{
paramContainerNo = " AND T_STORAGE_CONTAINER_BOX_DETAIL.CONTAINER_NO ='" + paramContainerContent.container_no + "'";
}
else
{
paramContainerNo = " AND T_STORAGE_CONTAINER_BOX_DETAIL.CONTAINER_NO ='" + paramContainerContent.container_no + "'";
}
}
string paramTransactDate = "";
if (!string.IsNullOrEmpty(paramContainerContent.transact_date) && paramContainerContent.transact_date != "string")
{
paramTransactDate = " AND TO_CHAR(T_STORAGE_CONTAINER_BOX_DETAIL.TRANSACT_DATE, 'YYYY-MM-DD HH24:MI:SS') = '" + paramContainerContent.transact_date + "'";
}
string paramSort = "";
if (!string.IsNullOrEmpty(paramContainerContent.order_by_column) && paramContainerContent.order_by_column != "string" && !string.IsNullOrEmpty(paramContainerContent.order_by_sort) && paramContainerContent.order_by_sort != "string")
{
paramSort = " ORDER BY T_STORAGE_CONTAINER_BOX_DETAIL." + paramContainerContent.order_by_column + " " + paramContainerContent.order_by_sort;
}
string paramSearch = "";
if (paramContainerContent.is_searching == true && !string.IsNullOrEmpty(paramContainerContent.search_key) && paramContainerContent.search_key != "string")
{
paramSearch = " WHERE NAMA_PELANGGAN LIKE '" + paramContainerContent.search_key + "%' OR VOYAGE_NO LIKE '" + paramContainerContent.search_key + "%' OR CONTAINER_NO LIKE '" + paramContainerContent.search_key + "%' OR VES_NAME LIKE '" + paramContainerContent.search_key + "%'";
}
var sql = "SELECT * FROM (" +
"SELECT T_STORAGE_CONTAINER_BOX_DETAIL.*, APP_REGIONAL.REGIONAL_NAMA NAMA_REGIONAL FROM T_STORAGE_CONTAINER_BOX_DETAIL JOIN APP_REGIONAL ON T_STORAGE_CONTAINER_BOX_DETAIL.KD_REGIONAL=APP_REGIONAL.ID AND APP_REGIONAL.PARENT_ID IS NULL AND APP_REGIONAL.ID NOT IN (12300000,20300001)" + paramKodeRegional + paramKodeCabang + paramKodeTerminal + paramArea + paramVoyageNo + paramContainerNo + paramTransactDate + paramSort +
")" + paramSearch;
result = connection.Query <ContainerContentData>(sql, new
{
KD_REGIONAL = paramContainerContent.kd_regional
});
}
catch (Exception)
{
result = null;
}
}
return(result);
}
