public static string GetVOReportData(Reports.VOParams ObjParams) { Initialize(); String GetVOReportData = DBReportString.GetVOReportData; var data = (List <Reports.VOReport>)db.Query <Reports.VOReport>(GetVOReportData, new { ReportDate = ObjParams.ReportDate, VoucherCategory = ObjParams.VoucherCategory }); return(getJSON(data)); }
public static string GetVOReportData(Reports.VOParams VOParams) { //send id=0 for all data //var data = BAL.Select_Brands(0); var data = DReportDataTable.GetVOReportData(VOParams); 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); }