public SageCRMDataSourceView(IDataSource owner, string TableName, string WhereClause,
SageCRMConnection SageCRMConnectionObj, string SelectSQL, string iTop)
: base(owner, DefaultViewName)
{
FSageCRMConnection = SageCRMConnectionObj;
FTableName = TableName;
FWhereClause = WhereClause;
FSelectSQL = SelectSQL;
FTop = iTop;
FSageCRMCustom = new SageCRMCustom(); //we use this to make our request
FSageCRMCustom.SageCRMConnection = FSageCRMConnection;
}
public string ExecSQL(string sqlExec)
{
SageCRMCustom FSageCRMCustom;
if (this.SageCRMConnection != null)
{
FSageCRMCustom = new SageCRMCustom(); //we use this to make our request
FSageCRMCustom.SageCRMConnection = FSageCRMConnection;
return(FSageCRMCustom._GetHTML(this.getExecSQLFile(), "&ExecSQL=" + sqlExec, "", false));
}
else
{
return("No SageCRMConnection set (ExecSQL Method)");
}
}
public SageCRMDataSourceView(IDataSource owner, string TableName, string WhereClause,
SageCRMConnection SageCRMConnectionObj, string SelectSQL, string iTop, bool pNoTLS, bool pCachable, string columnlist,
string Workflow, string WorkflowState, string OrderBy = "", string translate = "N")
: base(owner, DefaultViewName)
{
FSageCRMConnection = SageCRMConnectionObj;
FTableName = TableName;
FWhereClause = WhereClause;
FSelectSQL = SelectSQL;
FTop = iTop;
FNoTLS = pNoTLS;
FSageCRMCustom = new SageCRMCustom(); //we use this to make our request
FSageCRMCustom.SageCRMConnection = FSageCRMConnection;
FCachable = pCachable;
FColumnList = columnlist;
FTranslate = translate;
FWorkflow = Workflow;
FWorkflowState = WorkflowState;
FOrderBy = OrderBy;
}
private void populate_lb_buttonimages()
{
SageCRMCustom FSageCRMCustom;
string imageliststr = "";
string[] imageListArr;
string[] stringSeparators = new string[] { "," };
try
{
lb_buttonimages.Items.Clear();
if (this.connectionObject != null)
{
FSageCRMCustom = new SageCRMCustom(); //we use this to make our request
FSageCRMCustom.SageCRMConnection = connectionObject;
imageliststr =FSageCRMCustom._GetHTML("/CustomPages/SageCRM/component/imagelist.asp", "", "", false);
imageListArr = imageliststr.Split(stringSeparators, StringSplitOptions.None);
for (int i = 0; i < imageListArr.Length; i++)
{
lb_buttonimages.Items.Add(imageListArr[i].ToString());
}
setListValue(lb_buttonimages,this.ImageName);
}
else
{
MessageBox.Show("No SageCRMConnection set (populate_lb_buttonimages Method)");
}
}
catch (Exception ex3)
{
MessageBox.Show("Error retrieving image list. " + ex3.Message.ToString());
}
}
public SageCRMDataSourceView(IDataSource owner, string TableName, string WhereClause,
SageCRMConnection SageCRMConnectionObj, string SelectSQL, string iTop)
: base(owner, DefaultViewName)
{
FSageCRMConnection = SageCRMConnectionObj;
FTableName = TableName;
FWhereClause = WhereClause;
FSelectSQL = SelectSQL;
FTop = iTop;
FSageCRMCustom = new SageCRMCustom(); //we use this to make our request
FSageCRMCustom.SageCRMConnection = FSageCRMConnection;
}
public string ExecSQL(string sqlExec)
{
SageCRMCustom FSageCRMCustom;
if (this.SageCRMConnection != null)
{
FSageCRMCustom = new SageCRMCustom(); //we use this to make our request
FSageCRMCustom.SageCRMConnection = FSageCRMConnection;
return FSageCRMCustom._GetHTML(this.getExecSQLFile(), "&ExecSQL=" + sqlExec, "", false);
}
else
{
return "No SageCRMConnection set (ExecSQL Method)";
}
}
