public static User GetByID( int id ) { DataRow row = AdoNetSqlHelper.ExecuteRow( "GetUserByID", new AdoNetSqlParamCollection( AdoNetSqlParamCollection.CreateParameter( "@ID", id ) ) ); if ( row == null ) { return null; } else { User o = new User(); o.Load( row ); if ( o.IsEmpty ) { return null; } else { return o; } } }
private void UserLoginForm_FormClosing( object sender, FormClosingEventArgs e ) { if ( this.DialogResult == DialogResult.OK ) { DBObjects.User user; Cursor = Cursors.WaitCursor; try { user = DBObjects.User.GetByUserNameAndPassword( textBox1.Text.Trim(), textBox2.Text ); } finally { Cursor = Cursors.WaitCursor; } if ( user==null ) { MessageBox.Show( this, "Unknown username or wrong password. Please verify that you entered the correct information and try again.", "Error during login", MessageBoxButtons.OK, MessageBoxIcon.Error ); this.DialogResult = DialogResult.None; e.Cancel = true; } else { this.user = user; } } }
public static Ticket[] GetAssignedToUser( User user, TicketEvent.TicketEventState state ) { if ( user == null ) { return null; } else { DataTable table = AdoNetSqlHelper.ExecuteTable( "GetTicketsAssignedToUserSamNameWithState", new AdoNetSqlParamCollection( AdoNetSqlParamCollection.CreateParameter( "@UserSamName", user.SamName ), AdoNetSqlParamCollection.CreateParameter( "@State", state.ToString() ) ) ); 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 ) ); } } } }
/// <summary> /// Load all for the given parent. /// </summary> public static Ticket[] GetForCustomerCompanyAssignedToUser( CustomerCompany parentObject, User user ) { DataTable table = AdoNetSqlHelper.ExecuteTable( "GetTicketsForCustomerCompanyAssignedToUser", new AdoNetSqlParamCollection( AdoNetSqlParamCollection.CreateParameter( "@ID", parentObject.ID ), AdoNetSqlParamCollection.CreateParameter( "@UserSamName", user.SamName ) ) ); 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 ) ); } } }
public static User GetByUserNameAndPassword( string samName, string password ) { DataRow row = AdoNetSqlHelper.ExecuteRow( "GetUserBySamNameAndPassword", new AdoNetSqlParamCollection( AdoNetSqlParamCollection.CreateParameter( "@SamName", samName ), AdoNetSqlParamCollection.CreateParameter( "@Password", password ) ) ); if ( row == null ) { return null; } else { User o = new User(); o.Load( row ); if ( o.IsEmpty ) { return null; } else { return o; } } }
/// <summary> /// Load all. /// </summary> public static User[] GetAll() { DataTable table = AdoNetSqlHelper.ExecuteTable( "GetAllUsers", new AdoNetSqlParamCollection( ) ); if ( table == null ) { return null; } else { ArrayList result = new ArrayList(); foreach ( DataRow row in table.Rows ) { User o = new User(); o.Load( row ); if ( !o.IsEmpty ) { result.Add( o ); } } if ( result.Count <= 0 ) { return null; } else { return (User[])result.ToArray( typeof( User ) ); } } }
public static User GetByEMail( string emailAddress ) { DataRow row = AdoNetSqlHelper.ExecuteRow( "GetUserByEMailAddress", new AdoNetSqlParamCollection( AdoNetSqlParamCollection.CreateParameter( "@EMailAddress", emailAddress ) ) ); if ( row == null ) { return null; } else { User o = new User(); o.Load( row ); if ( o.IsEmpty ) { return null; } else { return o; } } }
public static User GetBySamName( string samName ) { if ( string.IsNullOrEmpty( samName ) ) { return null; } else { DataRow row = AdoNetSqlHelper.ExecuteRow( "GetUserBySamName", new AdoNetSqlParamCollection( AdoNetSqlParamCollection.CreateParameter( "@SamName", samName ) ) ); if ( row == null ) { return null; } else { User o = new User(); o.Load( row ); if ( o.IsEmpty ) { return null; } else { return o; } } } }
public static User GetByRow( DataRow row ) { User o = new User(); o.Load( row ); if ( o.IsEmpty ) { return null; } else { return o; } }