public IActionResult getKedalaman(ParamKedalaman data) { MasKedalamanDL dal = new MasKedalamanDL(); MasKedalamanModel hasil = new MasKedalamanModel(); IEnumerable <Kedalaman> result = dal.getKedalaman(data); hasil.message = "Success"; hasil.status = "S"; hasil.count = result.Cast <Object>().Count(); hasil.data = result.ToList(); return(Ok(hasil)); }
public IEnumerable <Kedalaman> getKedalaman(ParamKedalaman paramKedalaman) { IEnumerable <Kedalaman> result = null; using (IDbConnection connection = Extension.GetConnection(1)) { try { string paramKodeRegional = ""; if (!string.IsNullOrEmpty(paramKedalaman.kd_regional) && paramKedalaman.kd_regional != "string") { paramKodeRegional = " WHERE KD_REGIONAL ='" + paramKedalaman.kd_regional + "'"; } string paramKdCabang = ""; if (!string.IsNullOrEmpty(paramKedalaman.kd_cabang) && paramKedalaman.kd_cabang != "string") { paramKdCabang = " AND KD_CABANG ='" + paramKedalaman.kd_cabang + "'"; } string paramTgl = ""; if (!string.IsNullOrEmpty(paramKedalaman.tgl) && paramKedalaman.tgl != "string") { paramTgl = " AND TO_CHAR(TGL, 'YYYY-MM-DD')='" + paramKedalaman.tgl + "'"; } string paramJam = ""; if (!string.IsNullOrEmpty(paramKedalaman.jam) && paramKedalaman.jam != "string") { paramJam = " AND JAM='" + paramKedalaman.jam + "'"; } string sql = ""; sql = @"SELECT * FROM PASANG_SURUT " + paramKodeRegional + paramKdCabang + paramTgl + paramJam; result = connection.Query <Kedalaman>(sql, new { KD_REGIONAL = paramKedalaman.kd_regional }); } catch (Exception) { result = null; } } return(result); }