public static string GetAllSpDetails(string pregistration_no)
{
SpManager spManager = new SpManager();
DataTable dt = new DataTable();
if (HttpContext.Current.Session["BranchId"] != null)
{
if (!HttpContext.Current.Session["BranchId"].ToString().Equals("0001"))
{
dt = spManager.GetSpDetailsByReg(pregistration_no);
DataColumn[] columns = dt.Columns.Cast <DataColumn>().ToArray();
bool contains = dt.AsEnumerable()
.Any(row => columns.Any(col => row[col].ToString() == HttpContext.Current.Session["BranchId"].ToString()));
if (contains)
{
dt = dt.AsEnumerable().Where(r => r.Field <string>("BRANCH_NAME") == HttpContext.Current.Session["BranchId"].ToString()).CopyToDataTable();
}
else
{
dt = new DataTable();
}
}
}
return(DatatableToJson(dt));
}