/// <summary> /// Clones the specified LST OrganizationRank. /// </summary> /// <param name="lstOrganizationRank">The LST OrganizationRank.</param> /// <returns>List<OrganizationRank></returns> static public List <OrganizationRank> Clone(List <OrganizationRank> lstOrganizationRank) { List <OrganizationRank> lstCOrganizationRank = new List <OrganizationRank>(); foreach (OrganizationRank objOrganizationRank in lstOrganizationRank) { lstCOrganizationRank.Add(OrganizationRank.Clone(objOrganizationRank)); } return(lstCOrganizationRank); }
private void SetReaderToObject(ref OrganizationRank objOrganizationRank, ref SqlDataReader result) { if (result.HasRows) { objOrganizationRank.OrganizationRankID = (int)result.GetValue(result.GetOrdinal("OrganizationRankID")); objOrganizationRank.OrganizationID = (int)result.GetValue(result.GetOrdinal("OrganizationID")); objOrganizationRank.OrganizationRankLevel = (int)result.GetValue(result.GetOrdinal("OrganizationRankLevel")); objOrganizationRank.ScoreMin = (int)result.GetValue(result.GetOrdinal("ScoreMin")); objOrganizationRank.Title = result.GetValue(result.GetOrdinal("Title")).ToString(); objOrganizationRank.Benefits = result.GetValue(result.GetOrdinal("Benefits")).ToString(); objOrganizationRank.Duties = result.GetValue(result.GetOrdinal("Duties")).ToString(); Organization objOrg = new Organization(this.OrganizationID); objOrganizationRank.objOrganization = objOrg; } }
private List <OrganizationRank> GetOrganizationRankList(string strSprocName, string strWhere, string strOrderBy) { List <OrganizationRank> OrganizationRanks = new List <OrganizationRank>(); SqlDataReader result; DatabaseConnection dbconn = new DatabaseConnection(); SqlCommand command = new SqlCommand(); SqlConnection connection = new SqlConnection(dbconn.SQLSEVERConnString); try { connection.Open(); command.Connection = connection; command.CommandType = CommandType.StoredProcedure; command.CommandText = strSprocName; command.Parameters.Add(dbconn.GenerateParameterObj("@strWhere", SqlDbType.VarChar, strWhere, 1000)); command.Parameters.Add(dbconn.GenerateParameterObj("@strOrderBy", SqlDbType.VarChar, strOrderBy, 1000)); result = command.ExecuteReader(); while (result.Read()) { OrganizationRank objOrganizationRank = new OrganizationRank(); SetReaderToObject(ref objOrganizationRank, ref result); OrganizationRanks.Add(objOrganizationRank); } } catch { Exception e = new Exception(); throw e; } finally { command.Dispose(); connection.Close(); } return(OrganizationRanks); }
/// <summary> /// Clones the specified object OrganizationRank. /// </summary> /// <param name="objOrganizationRank">The object OrganizationRank.</param> /// <returns>OrganizationRank</returns> static public OrganizationRank Clone(OrganizationRank objOrganizationRank) { OrganizationRank objCOrganizationRank = new OrganizationRank(objOrganizationRank.OrganizationRankID); return(objCOrganizationRank); }