public static string JSONRequestFromClient()
{
Dictionary <string, string> Params = GetFilterParameters();
if (Params.ContainsKey("Action"))
{
Params["Action"] = "LOCK_AUDIT_SALES";
}
else
{
Params.Add("Action", "LOCK_AUDIT_SALES");
}
Queries.ExecuteFromStoreProcedure2("spx_PAYOUTAuditSales", Params, "Results");
//DataSet ds = Queries.GetResultsFromStoreProcedure("spx_PAYOUTAuditSales", ref Params, "Results");
//string FolderPath = HttpContext.Current.Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["FolderPath"] + @"\DownloadFilefolder\");
//Common.ExportCSVFile(FolderPath, "AuditSales", HttpContext.Current.Session["userFullname"].ToString(), Params, "spx_PAYOUTAuditSales", "Results");
//if(ds.Tables.Count > 0)
// Common.ExportToExcel_List(new List<DataTable> { ds.Tables[0] }, "RoadShow SalesAudit");
return(Params["Results"]);
}
