public IActionResult getListKomoditi(ParamKomoditi paramKomoditi)
{
MasKomoditiDL dal = new MasKomoditiDL();
MasKomoditiModel hasil = new MasKomoditiModel();
IEnumerable <KomoditiData> result = dal.getKomoditiData(paramKomoditi);
hasil.message = "Success";
hasil.status = "S";
hasil.count = result.Cast <Object>().Count();
hasil.data = result.ToList();
return(Ok(hasil));
}
public IEnumerable <KomoditiData> getKomoditiData(ParamKomoditi paramKomoditi)
{
IEnumerable <KomoditiData> result = null;
using (IDbConnection connection = Extension.GetConnection(0))
{
try
{
string paramSearch = "";
if (!string.IsNullOrEmpty(paramKomoditi.search) && paramKomoditi.search != "string")
{
paramSearch = " WHERE NAMA LIKE '" + paramKomoditi.search.ToUpper() + "%'";
}
string sql = @"SELECT DISTINCT NAMA,
(CASE WHEN NAMA = 'GENERAL CARGO' OR NAMA = 'GENERAL CARGO (GC)' OR NAMA = 'GC' OR NAMA = 'MOBIL' OR NAMA = 'SEPEDA MOTOR' THEN 'GC'
WHEN NAMA = 'CURAH CAIR' THEN 'CURAH CAIR'
WHEN NAMA = 'CURAH KERING' THEN 'CURAH KERING'
WHEN NAMA = 'BESI PRODUKSI' OR NAMA = 'HEWAN' OR NAMA = 'UNITIZED' OR NAMA = 'DRILLING MATERIAL'
OR NAMA = 'SEMBAKO' OR NAMA = 'KAYU MASAK' OR NAMA = 'BUNKER' OR NAMA = 'COMBO WINDOWS' OR NAMA = 'COMBO NON WINDOWS'
OR NAMA = 'BAG CARGO' OR NAMA = 'CREW SERVICE' OR NAMA = 'MULTIPURPOSE' THEN 'UNITIZED'
WHEN NAMA = 'UMUM' THEN 'UMUM'
WHEN NAMA = 'PENUMPANG' THEN 'PENUMPANG'
WHEN NAMA = 'MUATAN PENUMPANG' THEN 'UNITIZED'
WHEN NAMA = 'PETI KEMAS' OR NAMA = 'PETI KEMAS NON WINDOWS' OR NAMA = 'PETIKEMAS' OR NAMA = 'KONTAINER' THEN 'PETIKEMAS'
END) KATEGORI
FROM (SELECT ID, UPPER(NAMA) NAMA
FROM VASA.CLUSTERING)" + paramSearch + " ORDER BY NAMA ASC";
result = connection.Query <KomoditiData>(sql);
}
catch (Exception)
{
result = null;
}
}
return(result);
}
