public string GetReportData(string companyCode, string userName, System.Web.Mvc.FormCollection coll, string subDominName, out string error)
{
DALAPI objdalAPI = new DALAPI();
CurrentInfo _objcurrentInfo = new CurrentInfo();
Data _objData = new Data();
int apiID = Convert.ToInt32(coll["APIId"]);
string serviceId = coll["ServiceId"].ToString();
//string ErrorMSG = string.Empty;
string TransNumber = Guid.NewGuid().ToString();
string CurrentUserCode = _objcurrentInfo.GetUserCode();
//string CurrentUserName = _objcurrentInfo.GetUserName();
string ConnectionString = _objData.GetConnectionString_Client();
string ExcelURL = string.Empty;
StringBuilder ParamDetails = new StringBuilder();
DataSet ds = GetAPIUIElements(apiID);
object[] param = new object[ds.Tables[0].Rows.Count];
int i = 0;
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (dr["Show_In_UI"].ToString().ToUpper() == "N")
{
param[i] = HttpContext.Current.Session[dr["Session_Key"].ToString()].ToString();
}
else
{
if (dr["Type"].ToString() != "TEXT_CSV")
{
param[i] = coll[dr["InputParam"].ToString()].ToString();
}
else
{
// input string formate for TEXT_CSV aaa^bbb^ccc^bbbb^
string paramValue = coll[dr["InputParam"].ToString()].ToString();
paramValue = paramValue.Replace("^", "','");
paramValue = "'" + paramValue + "'";
param[i] = paramValue;
}
}
ParamDetails.Append(dr["InputParam"].ToString() + ": " + param[i].ToString() + "<br />");
i++;
}
//Log Bulk API SVC Log
string hdLogId = Guid.NewGuid().ToString();
string OutError;
objdalAPI.BulkAPISvcLog(companyCode, userName, serviceId, hdLogId, apiID);
HDCoreDataService.HDCoreDataServiceClient coreClt = new HDCoreDataService.HDCoreDataServiceClient();
DataSet dsReport = new DataSet();
dsReport = coreClt.ExecuteServiceDS("SWAAS", subDominName, apiID, "", "", 0, param, out OutError);
// dsReport = coreClt.ExecuteServiceDS(out OutError,"SWAAS", subDominName, apiID, "", "", 0, param);
error = "";
return(bindReport(dsReport).ToString());
}
