public static string GetSpFacevalue(string pregistration_no, string pinstrument_number)
{
SpManager spManager = new SpManager();
Dictionary <string, object> inputParam = new Dictionary <string, object>();
inputParam.Add("pregistration_no", pregistration_no);
inputParam.Add("pinstrument_number", pinstrument_number);
DataTable dt = spManager.GetImportedSpFacevalue(inputParam);
HttpContext.Current.Session["SpFaceValue"] = dt;
DataTable filteredData = new DataTable();
filteredData.Columns.Add("INSTRUMENT_NUMBER");
filteredData.Columns.Add("DENOMINATION");
foreach (DataRow dr in dt.Rows)
{
DataRow row = filteredData.NewRow();
row["INSTRUMENT_NUMBER"] = dr["INSTRUMENT_NUMBER"];
row["DENOMINATION"] = dr["DENOMINATION"];
filteredData.Rows.Add(row);
}
return(DatatableToJson(filteredData));
}