private void LoadCustomFields()
{
m_customFields = new RobotList <OrgCustomField>();
//m_customFields = OrgCustomField.GetOrgCustomFields(this);
//CustomFieldDef.AllDefs.ListChanged += AllCustomFieldDefs_ListChanged;
}
private void AllCustomFieldDefs_ListChanged(object sender,
ListChangedEventArgs e)
{
// If we have dirty custom fields we'll need to preserve those values.
RobotList <OrgCustomField> mydefs = OrgCustomField.GetOrgCustomFields(this);
foreach (OrgCustomField new_cf in mydefs)
{
OrgCustomField old_cf = m_customFields.Find(
delegate(OrgCustomField checkObj, int id)
{
return(checkObj.Def.Id == id);
}, new_cf.Def.Id);
if (old_cf == null)
{
continue;
}
new_cf.Value = old_cf.Value;
}
m_customFields = mydefs;
NotifyPropertyChanged("CustomFields");
}
public static RobotList <Contact> GetOrganizationContacts(Organization o)
{
RobotList <Contact> rval = new RobotList <Contact>();
SqlConnection cn = new SqlConnection(Helpers.CnnStr());
SafeDataReader dr = null;
SqlTransaction tr;
SqlCommand cmd;
cn.Open();
tr = cn.BeginTransaction(IsolationLevel.ReadCommitted);
try
{
cmd = cn.CreateCommand();
cmd.Transaction = tr;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_GetOrganizationContacts";
cmd.Parameters.AddWithValue("@org_id", o.Id);
dr = new SafeDataReader(cmd.ExecuteReader());
while (dr.Read())
{
Contact c = new Contact(o);
c.DoLoad(dr);
rval.Add(c);
}
dr.Close();
tr.Commit();
}
catch
{
if ((dr != null) && !dr.IsClosed)
{
dr.Close();
}
tr.Rollback();
throw;
}
finally
{
if ((dr != null) && !dr.IsClosed)
{
dr.Close();
}
cn.Close();
}
return(rval);
}
private static RobotList <Country> GetCountries()
{
RobotList <Country> rval = new RobotList <Country>();
SqlConnection cn = new SqlConnection(Helpers.CnnStr());
SafeDataReader dr = null;
SqlTransaction tr;
SqlCommand cmd;
cn.Open();
tr = cn.BeginTransaction(IsolationLevel.ReadCommitted);
try
{
cmd = cn.CreateCommand();
cmd.Transaction = tr;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_GetCountryList";
dr = new SafeDataReader(cmd.ExecuteReader());
while (dr.Read())
{
Country c = new Country();
c.DoLoad(dr);
rval.Add(c);
}
dr.Close();
tr.Commit();
}
catch
{
if ((dr != null) && !dr.IsClosed)
{
dr.Close();
}
tr.Rollback();
throw;
}
finally
{
if ((dr != null) && !dr.IsClosed)
{
dr.Close();
}
cn.Close();
}
return(rval);
}
protected static RobotList <Organization> LoadList(SafeDataReader dr)
{
RobotList <Organization> rval = new RobotList <Organization>();
while (dr.Read())
{
Organization o = new Organization();
o.Load(dr);
rval.Add(o);
}
return(rval);
}
public RobotList <ItemTy> FindAll <ParamTy>(FindDelegate <ParamTy> func, ParamTy p)
{
RobotList <ItemTy> rval = new RobotList <ItemTy>();
foreach (ItemTy i in this)
{
if (func(i, p))
{
rval.Add(i);
}
}
return(rval);
}
public static RobotList <Organization> GetActiveOrganizations()
{
RobotList <Organization> rval = new RobotList <Organization>();
SqlConnection cn = new SqlConnection(Helpers.CnnStr());
SafeDataReader dr = null;
SqlTransaction tr;
SqlCommand cmd;
cn.Open();
tr = cn.BeginTransaction(IsolationLevel.ReadCommitted);
try
{
cmd = cn.CreateCommand();
cmd.Transaction = tr;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_GetActiveOrganizations";
dr = new SafeDataReader(cmd.ExecuteReader());
rval = LoadList(dr);
dr.Close();
tr.Commit();
}
catch (Exception ex)
{
tr.Rollback();
MessageBox.Show(ex.Message);
}
finally
{
if ((dr != null) && !dr.IsClosed)
{
dr.Close();
}
cn.Close();
}
return(rval);
}
public RobotList <ItemTy> FindAll <ParamTy>(string PropName, ParamTy p)
{
RobotList <ItemTy> rval = new RobotList <ItemTy>();
Type t = typeof(ItemTy);
PropertyInfo pi = t.GetProperty(PropName);
if (pi == null)
{
throw new Exception("Invalid property name: " + PropName);
}
if (pi.PropertyType.IsArray)
{
string msg = String.Format("Property {0} is an array type.",
PropName);
throw new Exception(msg);
}
if (pi.PropertyType != typeof(ParamTy))
{
throw new Exception("Property not of type: " +
typeof(ParamTy).Name);
}
foreach (ItemTy i in this)
{
ParamTy objVal = (ParamTy)pi.GetValue(i, null);
if (objVal.Equals(p))
{
rval.Add(i);
}
}
return(rval);
}
public static RobotList <OrgCustomField> GetOrgCustomFields(Organization org)
{
RobotList <OrgCustomField> rval = new RobotList <OrgCustomField>();
SqlConnection cn = new SqlConnection(Helpers.CnnStr());
SafeDataReader dr = null;
SqlTransaction tr;
SqlCommand cmd;
cn.Open();
tr = cn.BeginTransaction(IsolationLevel.ReadCommitted);
try
{
cmd = cn.CreateCommand();
cmd.Transaction = tr;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_GetOrgCustomFields";
cmd.Parameters.AddWithValue("@org_id", org.Id);
dr = new SafeDataReader(cmd.ExecuteReader());
while (dr.Read())
{
int defId = dr.GetInt32(dr.GetOrdinal("def_id"));
CustomFieldDef def =
CustomFieldDef.AllDefs.Find(CustomFieldDef.ById, defId);
if (def == null)
{
continue;
}
OrgCustomField cf = new OrgCustomField(def, org);
cf.DoLoad(dr);
rval.Add(cf);
}
dr.Close();
tr.Commit();
}
catch
{
tr.Rollback();
throw;
}
finally
{
if ((dr != null) && !dr.IsClosed)
{
dr.Close();
}
cn.Close();
}
/*
* Make sure all the currently defined custom field definitions
* are listed.
*/
foreach (CustomFieldDef def in CustomFieldDef.AllDefs)
{
OrgCustomField cf = rval.Find(
delegate(OrgCustomField obj, CustomFieldDef p)
{
return(obj.Def == p);
}, def);
if (cf == null)
{
cf = new OrgCustomField(def, org);
rval.Add(cf);
}
}
return(rval);
}
private void LoadContacts()
{
m_contacts = Contact.GetOrganizationContacts(this);
}
private void LoadAddresses()
{
m_addresses = Address.GetOrganizationAddresses(this);
}
