/// <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);
}
