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