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