public string POST(string offset, string limit, string searchQry, string category, string town, string sortBy)
{
OracleCommand cmd = new OracleCommand();
cmd.Connection = db.conn;
cmd.CommandText = "DbPack.getWallListWithParam";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("var_cur", OracleDbType.RefCursor, ParameterDirection.ReturnValue);
cmd.Parameters.Add("offsetVh", Convert.ToInt32(offset));
cmd.Parameters.Add("limitVh", Convert.ToInt32(limit));
cmd.Parameters.Add("searchQryVh", searchQry);
cmd.Parameters.Add("categoryVh", category);
cmd.Parameters.Add("townVh", town);
cmd.Parameters.Add("sortByVh", sortBy);
OracleDataReader dr = cmd.ExecuteReader();
List <PreviewWallInfo> arrayJson = new List <PreviewWallInfo>();
if (dr.HasRows)
{
while (dr.Read())
{
PreviewWallInfo previewWallInfo = new PreviewWallInfo();
previewWallInfo.idWalls = dr.GetValue(0).ToString();
previewWallInfo.titleWalls = dr.GetValue(1).ToString();
previewWallInfo.nearestTown = dr.GetValue(2).ToString();
previewWallInfo.category = dr.GetValue(3).ToString();
previewWallInfo.dateCreate = dr.GetValue(4).ToString();
previewWallInfo.avatarUrl = dr.GetValue(5).ToString();
arrayJson.Add(previewWallInfo);
}
return(JsonConvert.SerializeObject(arrayJson));
}
else
{
return("000");
}
}
public string POST(string token)
{
OracleCommand cmd = new OracleCommand();
cmd.Connection = db.conn;
cmd.CommandText = "DbPack.getWallListMy";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("var_cur", OracleDbType.RefCursor, ParameterDirection.ReturnValue);
cmd.Parameters.Add("tokenVh", token);
OracleDataReader dr = cmd.ExecuteReader();
List <PreviewWallInfo> arrayJson = new List <PreviewWallInfo>();
if (dr.HasRows)
{
while (dr.Read())
{
PreviewWallInfo previewWallInfo = new PreviewWallInfo();
previewWallInfo.idWalls = dr.GetValue(0).ToString();
previewWallInfo.titleWalls = dr.GetValue(1).ToString();
previewWallInfo.nearestTown = dr.GetValue(2).ToString();
previewWallInfo.dateCreate = dr.GetValue(3).ToString();
previewWallInfo.avatarUrl = dr.GetValue(4).ToString();
arrayJson.Add(previewWallInfo);
}
return(JsonConvert.SerializeObject(arrayJson));
}
else
{
return("000");
}
}
