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 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)"; } }