private void populate_lb_screens()
{
try
{
lb_screens.Items.Clear();
string entityFilter = "";
if (this.EntityName != "")
{
entityFilter = "and cobj_entityname='" + this.EntityName + "' ";
}
this.setConnection();
this.ds.SelectSQL = "select cobj_name from custom_screenobjects " + //create our sql to get our entities
"where (cobj_type='Screen' or cobj_type='SearchScreen') " +
entityFilter +
"order by cobj_name";
IDataReader idr = ds.SelectData(); //get our IDataReader class
//loop through our class
while (idr.Read())
{
lb_screens.Items.Add(idr["cobj_name"].ToString());
}
//lb_lists.SelectedValue = this.ListBlock;
}
catch (Exception ex3)
{
MessageBox.Show("Error retrieving list names. " + ex3.Message.ToString());
}
}
private void populate_tb_idcolumn()
{
try
{
this.setConnection();
this.ds.SelectSQL = "select bord_idfield from custom_tables where bord_name='" + this.EntityName + "'";
IDataReader idr = ds.SelectData(); //get our IDataReader class
idr.Read();
tb_idcolumn.Text = idr["bord_idfield"].ToString();
}
catch (Exception ex3)
{
MessageBox.Show("Error retrieving Entity ID Column. " + ex3.Message.ToString());
}
}
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);
}
