public static string GetGCSReportData(Reports.GCSParams ObjParams) { Initialize(); String GetGCSReportData = DBReportString.GetGCSReportData; var data = (List <Reports.GCSReport>)db.Query <Reports.GCSReport>(GetGCSReportData, new { StartDate = ObjParams.StartDate, EndDate = ObjParams.EndDate }); return(getJSON(data)); }
public static string GetGCRReportData(Reports.GCSParams GCRParams) { //send id=0 for all data //var data = BAL.Select_Brands(0); var data = DReportDataTable.GetGCRReportData(GCRParams); HttpContext context = HttpContext.Current; context.Response.Filter = new GZipStream(context.Response.Filter, CompressionMode.Compress); HttpContext.Current.Response.AppendHeader("Content-Encoding", "gzip"); HttpContext.Current.Response.ContentType = "application/json charset=utf-8"; return(data); }