public static string GetSpFacevalue(string prequest_id, string psanchay_patra_no)
{
SpManager spManager = new SpManager();
Dictionary <string, object> inputParam = new Dictionary <string, object>();
inputParam.Add("prequest_id", prequest_id);
inputParam.Add("psanchay_patra_no", psanchay_patra_no);
DataTable dt = spManager.GetSpFacevalue(inputParam);
DataTable filteredData = new DataTable();
filteredData.Columns.Add("SANCHAY_PATRA_NO");
filteredData.Columns.Add("DENOMINATION");
foreach (DataRow dr in dt.Rows)
{
DataRow row = filteredData.NewRow();
row["SANCHAY_PATRA_NO"] = dr["SANCHAY_PATRA_NO"];
row["DENOMINATION"] = dr["DENOMINATION"];
filteredData.Rows.Add(row);
}
return(DatatableToJson(filteredData));
}