public DataSet getCases()
{
getSageObject();
SageCRMDataSource ds = new SageCRMDataSource();
ds.SageCRMConnection = this.SageCon;
ds.TableName = "Cases";
string id = SageObject.GetVisitorInfo("pers_personid");
ds.WhereClause = "case_primarypersonid=" + id;
return(ds.getDataSet());
}
public bool setUpData()
{
string extraSQL = "";
if (this.SageCRMConnectionObject == null)
{
return(false);
}
cbds = new SageCRMDataSource(); //create our datasource
cbds.SageCRMConnection = this.SageCRMConnectionObject; //assign a connection
cbds.SelectSQL = "select * from custom_screenobjects " +
" where cobj_type='List' " +
extraSQL +
" order by cobj_name";
listBox1.DataSource = cbds;
listBox1.DisplayMember = "bord_caption";
listBox1.ValueMember = "bord_name";
return(true);
}
public string getCompanyId()
{
string result = "-1";
SageCRMDataSource ds = new SageCRMDataSource();
ds.SageCRMConnection = this.SageCRMConnection;
ds.TableName = "CrmProject";
ds.WhereClause = "proj_projectid=" + Session["proj_projectid"];
IDataReader idr = ds.SelectData();
while (idr.Read())
{
result = idr["proj_companyid"].ToString();
if (result == "")
{
result = "-1";
}
}
return(result);
}
private void setConnection()
{
this.ds = new SageCRMDataSource(); //create our datasource
this.ds.SageCRMConnection = this.connectionObject; //assign a connection
}
public DataSourcePropEditor(SageCRMDataSource _block)
{
this.Block = _block;
this.connectionObject = this.Block.SageCRMConnection;
InitializeComponent();
}
public override bool EditComponent(ITypeDescriptorContext context, object component,
IWin32Window owner)
{
SageCRMDataSource block = component as SageCRMDataSource;
if (block == null)
{
throw new ArgumentException("Component must be a SageCRMDataSource", "component");
}
IServiceProvider site = block.Site;
IComponentChangeService changeservice = null;
DesignerTransaction transaction = null;
bool changed = false;
try
{
if (site != null)
{
IDesignerHost designerhost = (IDesignerHost)site.GetService(typeof(IDesignerHost));
transaction = designerhost.CreateTransaction("Property Editor");
changeservice = (IComponentChangeService)site.GetService(typeof(IComponentChangeService));
if (changeservice != null)
{
try
{
changeservice.OnComponentChanging(block, null);
}
catch (CheckoutException ex)
{
if (ex == CheckoutException.Canceled)
{
return(false);
}
throw ex;
}
}
}
try
{
DataSourcePropEditor form = new DataSourcePropEditor(block);
form.TableName = block.TableName;
form.SelectSQL = block.SelectSQL;
form.WhereClause = block.WhereClause;
if (form.ShowDialog(owner) == DialogResult.OK)
{
changed = true;
}
}
finally
{
if (changed && changeservice != null)
{
changeservice.OnComponentChanged(block, null, null, null);
}
}
}
finally
{
if (transaction != null)
{
if (changed)
{
transaction.Commit();
}
else
{
transaction.Cancel();
}
}
}
return(changed);
}
