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