private void SetReaderToObject(ref ModificationType objModificationType, ref SqlDataReader result)
{
if (result.HasRows)
{
objModificationType.ModificationTypeID = (int)result.GetValue(result.GetOrdinal("ModificationTypeID"));
objModificationType.ModificationTypeName = result.GetValue(result.GetOrdinal("ModificationTypeName")).ToString();
objModificationType.ModificationTypeDescription = result.GetValue(result.GetOrdinal("ModificationTypeDescription")).ToString();
}
}
/// <summary>
/// Clones the specified object ModificationType.
/// </summary>
/// <param name="objModificationType">The object ModificationType.</param>
/// <returns>ModificationType</returns>
static public ModificationType Clone(ModificationType objModificationType)
{
ModificationType objCModificationType = new ModificationType(objModificationType.ModificationTypeID);
objCModificationType.ModificationTypeID = objModificationType.ModificationTypeID;
objCModificationType.ModificationTypeName = objModificationType.ModificationTypeName;
objCModificationType.ModificationTypeDescription = objModificationType.ModificationTypeDescription;
return(objCModificationType);
}
/// <summary>
/// Clones the specified LST ModificationType.
/// </summary>
/// <param name="lstModificationType">The LST ModificationType.</param>
/// <returns>List<ModificationType></returns>
static public List <ModificationType> Clone(List <ModificationType> lstModificationType)
{
List <ModificationType> lstCModificationType = new List <ModificationType>();
foreach (ModificationType objModificationType in lstModificationType)
{
lstCModificationType.Add(ModificationType.Clone(objModificationType));
}
return(lstCModificationType);
}
private void SetReaderToObject(ref Modification objModification, ref SqlDataReader result)
{
if (result.HasRows)
{
objModification.ModificationID = (int)result.GetValue(result.GetOrdinal("ModificationID"));
objModification.ModificationName = result.GetValue(result.GetOrdinal("ModificationName")).ToString();
objModification.ModificationDescription = result.GetValue(result.GetOrdinal("ModificationDescription")).ToString();
objModification.UpgradePoints = (int)result.GetValue(result.GetOrdinal("UpgradePoints"));
//objModification.ModificationTypeID = (int)result.GetValue(result.GetOrdinal("ModificationTypeID"));
objModification.ModificationCost = (int)result.GetValue(result.GetOrdinal("ModificationCost"));
ModificationType objModType = new ModificationType();
objModification.lstModificationType = objModType.GetModificationTypesByModfication(objModification.ModificationID);
}
}
/// <summary>
/// Clones the specified object Modification.
/// </summary>
/// <param name="objModification">The object Modification.</param>
/// <returns>Modification</returns>
static public Modification Clone(Modification objModification)
{
Modification objCModification = new Modification(objModification.ModificationID);
objCModification.ModificationID = objModification.ModificationID;
objCModification.ModificationName = objModification.ModificationName;
objCModification.ModificationDescription = objModification.ModificationDescription;
//objCModification.ModificationTypeID = objModification.ModificationTypeID;
objCModification.ModificationCost = objModification.ModificationCost;
objCModification.UpgradePoints = objModification.UpgradePoints;
objCModification.lstModificationType = ModificationType.Clone(objModification.lstModificationType);
return(objCModification);
}
private List <ModificationType> GetModificationTypeList(string strSprocName, string strWhere, string strOrderBy)
{
List <ModificationType> ModificationTypes = new List <ModificationType>();
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())
{
ModificationType objModificationType = new ModificationType();
SetReaderToObject(ref objModificationType, ref result);
ModificationTypes.Add(objModificationType);
}
}
catch
{
Exception e = new Exception();
throw e;
}
finally
{
command.Dispose();
connection.Close();
}
return(ModificationTypes);
}
