public static QVDataTable FromJson(string json)
{
QVDataTable qvDataTable = null;
qvDataTable = (QVDataTable)JsonConvert.DeserializeObject(json.ToString());
return(qvDataTable);
}
public WSResponse GetQlikViewData(QVDataTable qvDataTable)
{
// WSResponse can be used to deliver some additional data back to the
// client (QlikView extension), e.g. a download-link, some detailed additional information, etc.
WSResponse wsResponse = new WSResponse();
try
{
#region Loop trough the data table
if (qvDataTable != null)
{
// Loop through the header columns
if (qvDataTable.Headers != null)
{
foreach (var h in qvDataTable.Headers)
{
Debug.Write("Header: " + "\t\t");
}
Debug.Write("\n");
}
// Loop trough all rows & cells
if (qvDataTable.Rows != null)
{
foreach (var r in qvDataTable.Rows)
{
foreach (var c in r.Cells)
{
// Access the text value of the current cell
Debug.Write(c.Text + "\t");
// Access the data value of the current cell
Debug.Write(c.Data + "\t");
}
Debug.Write("\n");
}
}
}
#endregion
wsResponse.StatusMessage = "Successfully exported " + qvDataTable.Rows.Count.ToString() + " accounts to salesforce.com ...";
string rMsg = String.Format("Upload of data has been process successfully. ({0} records)", qvDataTable.Rows.Count.ToString());
wsResponse.ReturnMessage = rMsg;
}
catch (Exception ex)
{
wsResponse.StatusMessage = "Error";
}
return wsResponse;
}
public WSResponse GetQlikViewData(QVDataTable qvDataTable)
{
// WSResponse can be used to deliver some additional data back to the
// client (QlikView extension), e.g. a download-link, some detailed additional information, etc.
WSResponse wsResponse = new WSResponse();
try
{
#region Loop trough the data table
if (qvDataTable != null)
{
// Loop through the header columns
if (qvDataTable.Headers != null)
{
foreach (var h in qvDataTable.Headers)
{
Debug.Write("Header: " + "\t\t");
}
Debug.Write("\n");
}
// Loop trough all rows & cells
if (qvDataTable.Rows != null)
{
foreach (var r in qvDataTable.Rows)
{
foreach (var c in r.Cells)
{
// Access the text value of the current cell
Debug.Write(c.Text + "\t");
// Access the data value of the current cell
Debug.Write(c.Data + "\t");
}
Debug.Write("\n");
}
}
}
#endregion
wsResponse.StatusMessage = "Successfully exported " + qvDataTable.Rows.Count.ToString() + " accounts to salesforce.com ...";
string rMsg = String.Format("Upload of data has been process successfully. ({0} records)", qvDataTable.Rows.Count.ToString());
wsResponse.ReturnMessage = rMsg;
}
catch (Exception ex)
{
wsResponse.StatusMessage = "Error";
}
return(wsResponse);
}
