// ------------------------------------------------------------------ /// <summary> /// Load an object by a given ID. /// </summary> public static CustomerPerson GetByID( int id ) { DataRow row = AdoNetSqlHelper.ExecuteRow( "GetCustomerPersonByID", new AdoNetSqlParamCollection( AdoNetSqlParamCollection.CreateParameter( "@ID", id ) ) ); if ( row == null ) { return null; } else { CustomerPerson o = new CustomerPerson(); o.Load( row ); if ( o.IsEmpty ) { return null; } else { return o; } } }
/// <summary> /// Load all for the given parent. /// </summary> public static CustomerPerson[] GetForCompany( CustomerCompany parentObject ) { DataTable table = AdoNetSqlHelper.ExecuteTable( "GetCustomerPersonByCustomerCompanyID", new AdoNetSqlParamCollection( AdoNetSqlParamCollection.CreateParameter( "@ID", parentObject.ID ) ) ); if ( table == null ) { return null; } else { ArrayList result = new ArrayList(); foreach ( DataRow row in table.Rows ) { CustomerPerson o = new CustomerPerson(); o.Load( row ); if ( !o.IsEmpty ) { result.Add( o ); } } if ( result.Count <= 0 ) { return null; } else { return (CustomerPerson[])result.ToArray( typeof( CustomerPerson ) ); } } }
private void newCustomerPersonButton_Click( object sender, EventArgs e ) { DBObjects.CustomerPerson item = customerPersonComboBox.SelectedItem as DBObjects.CustomerPerson; DBObjects.CustomerCompany selectedCompany = customerCompanyComboBox.SelectedItem as DBObjects.CustomerCompany; DBObjects.CustomerCompany company = item==null?selectedCompany:item.Company; DBObjects.CustomerPerson person = new DBObjects.CustomerPerson(); CustomerPersonEditForm form = new CustomerPersonEditForm( company, person ); if ( form.ShowDialog( this ) == DialogResult.OK ) { FillCustomerPersonList( company ); FillGroupList( company ); SelectCustomerPerson( person ); } }
private void newpersonToolStripMenuItem_Click( object sender, EventArgs e ) { DBObjects.CustomerCompany company = customerCompanyTreeView.SelectedNode.Tag as DBObjects.CustomerCompany; DBObjects.CustomerPerson person = new DBObjects.CustomerPerson(); CustomerPersonEditForm form = new CustomerPersonEditForm( company, person ); form.ShowDialog( this ); }
/// <summary> /// Load all for the given parent. /// </summary> public static Ticket[] GetForCustomerPerson( CustomerPerson parentObject ) { DataTable table = AdoNetSqlHelper.ExecuteTable( "SELECT * FROM [Tickets] WHERE [CustomerPersonID]=@ID", new AdoNetSqlParamCollection( AdoNetSqlParamCollection.CreateParameter( "@ID", parentObject.ID ) ) ); if ( table == null ) { return null; } else { ArrayList result = new ArrayList(); foreach ( DataRow row in table.Rows ) { Ticket o = new Ticket(); o.Load( row ); if ( !o.IsEmpty ) { result.Add( o ); } } if ( result.Count <= 0 ) { return null; } else { return (Ticket[])result.ToArray( typeof( Ticket ) ); } } }
private void newToolStripMenuItem_Click( object sender, EventArgs e ) { // Must store parent before adding child. Store(); DBObjects.CustomerPerson person = new DBObjects.CustomerPerson(); CustomerPersonEditForm form = new CustomerPersonEditForm( item, person ); if ( form.ShowDialog( this ) == DialogResult.OK ) { FillPersonsList(); } }
public static CustomerPerson GetForCrmPerson( Crm.CrmPerson crmPerson ) { DataRow row = AdoNetSqlHelper.ExecuteRow( "GetCustomerPersonFromCrmPerson", new AdoNetSqlParamCollection( AdoNetSqlParamCollection.CreateParameter( "@PersonID", crmPerson.ID ) ) ); if ( row == null ) { return null; } else { CustomerPerson o = new CustomerPerson(); o.Load( row ); if ( o.IsEmpty ) { return null; } else { return o; } } }
public static CustomerPerson GetByCrmReplicationUniqueID( Guid crmReplicationUniqueID ) { DataRow row = AdoNetSqlHelper.ExecuteRow( "GetCustomerPersonByCrmReplicationUniqueID", new AdoNetSqlParamCollection( AdoNetSqlParamCollection.CreateParameter( "@CrmReplicationUniqueID", crmReplicationUniqueID ) ) ); if ( row == null ) { return null; } else { CustomerPerson o = new CustomerPerson(); o.Load( row ); if ( o.IsEmpty ) { return null; } else { return o; } } }