private void SetReaderToObject(ref ForceTradition objForceTradition, ref SqlDataReader result) { if (result.HasRows) { objForceTradition.ForceTraditionID = (int)result.GetValue(result.GetOrdinal("ForceTraditionID")); objForceTradition.ForceTraditionName = result.GetValue(result.GetOrdinal("ForceTraditionName")).ToString(); objForceTradition.ForceTraditionDescription = result.GetValue(result.GetOrdinal("ForceTraditionDescription")).ToString(); } }
/// <summary> /// Clones the specified LST ForceTradition. /// </summary> /// <param name="lstForceTradition">The LST ForceTradition.</param> /// <returns>List<ForceTradition></returns> static public List <ForceTradition> Clone(List <ForceTradition> lstForceTradition) { List <ForceTradition> lstCForceTradition = new List <ForceTradition>(); foreach (ForceTradition objForceTradition in lstForceTradition) { lstCForceTradition.Add(ForceTradition.Clone(objForceTradition)); } return(lstCForceTradition); }
private List <ForceTradition> GetForceTraditionList(string strSprocName, string strWhere, string strOrderBy) { List <ForceTradition> ForceTraditions = new List <ForceTradition>(); 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()) { ForceTradition objForceTradition = new ForceTradition(); SetReaderToObject(ref objForceTradition, ref result); ForceTraditions.Add(objForceTradition); } } catch { Exception e = new Exception(); throw e; } finally { command.Dispose(); connection.Close(); } return(ForceTraditions); }
private void SetReaderToObject(ref Organization objOrganization, ref SqlDataReader result) { if (result.HasRows) { objOrganization.OrganizationID = (int)result.GetValue(result.GetOrdinal("OrganizationID")); objOrganization.OrganizationName = result.GetValue(result.GetOrdinal("OrganizationName")).ToString(); objOrganization.OrganizationDescription = result.GetValue(result.GetOrdinal("OrganizationDescription")).ToString(); objOrganization.ScaleID = (int)result.GetValue(result.GetOrdinal("ScaleID")); objOrganization.OrganizationTypeID = (int)result.GetValue(result.GetOrdinal("OrganizationTypeID")); objOrganization.OrganizationAllies = result.GetValue(result.GetOrdinal("OrganizationAllies")).ToString(); objOrganization.OrganizationEnemies = result.GetValue(result.GetOrdinal("OrganizationEnemies")).ToString(); objOrganization.ForceTraditionID = (int)result.GetValue(result.GetOrdinal("ForceTraditionID")); if (objOrganization.ForceTraditionID != 0) { ForceTradition objForceTrad = new ForceTradition(this.ForceTraditionID); objOrganization.objForceTradition = objForceTrad; } objOrganization.objOrganizationScale = new OrganizationScale(this.ScaleID); objOrganization.objOrganizationType = new OrganizationType(this.OrganizationTypeID); } }
/// <summary> /// Clones the specified object ForceTradition. /// </summary> /// <param name="objForceTradition">The object ForceTradition.</param> /// <returns>ForceTradition</returns> static public ForceTradition Clone(ForceTradition objForceTradition) { ForceTradition objCForceTradition = new ForceTradition(objForceTradition.ForceTraditionID); return(objCForceTradition); }