public static object GetCorrectedCBCR(string countryCode, string reportingPeriod)
{
var cbcr = DBReadManager.GetCorrectedCBCByCountryAndReportingPeriod(countryCode, reportingPeriod);
string jsonString = "";
if (cbcr.HasRows)
{
var lst = cbcr.Tables[0].AsEnumerable()
.Select(r => r.Table.Columns.Cast <DataColumn>()
.Select(c => new KeyValuePair <string, object>(c.ColumnName, r[c.Ordinal])
).ToDictionary(z => z.Key, z => z.Value)
).ToList();
var serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
jsonString = serializer.Serialize(lst);
}
;
return(jsonString);
}