/// <summary>
/// Sets the reader to object.
/// </summary>
/// <param name="objForcePower">The object force power.</param>
/// <param name="result">The result.</param>
private void SetReaderToObject(ref ForcePower objForcePower, ref SqlDataReader result)
{
if (result.HasRows)
{
objForcePower.ForcePowerID = (int)result.GetValue(result.GetOrdinal("ForcePowerID"));
objForcePower.ForcePowerName = result.GetValue(result.GetOrdinal("ForcePowerName")).ToString();
objForcePower.ForcePowerDescription = result.GetValue(result.GetOrdinal("ForcePowerDescription")).ToString();
//objForcePower.ForcePowerDescriptorID = (int)result.GetValue(result.GetOrdinal("ForcePowerDescriptorID"));
objForcePower.TurnSegmentID = (int)result.GetValue(result.GetOrdinal("TurnSegmentID"));
objForcePower.ForcePowerTarget = result.GetValue(result.GetOrdinal("ForcePowerTarget")).ToString();
objForcePower.ForcePowerSpecial = result.GetValue(result.GetOrdinal("ForcePowerSpecial")).ToString();
ForcePowerDescriptor FPD = new ForcePowerDescriptor();
objForcePower.objForcePowerDescriptors = FPD.GetForcePowerForcePowerDescriptors(" ForcePowerID=" + objForcePower.ForcePowerID.ToString(), " ForcePowerDescriptorName ");
if (objForcePower.TurnSegmentID != 0)
{
TurnSegment TS = new TurnSegment();
objForcePower.objTurnSegment = TS.GetTurnSegment(objForcePower.TurnSegmentID);
}
objForcePower._objComboBoxData.Add(objForcePower.ForcePowerID, objForcePower.ForcePowerName);
}
}
/// <summary>
/// Sets the reader to object.
/// </summary>
/// <param name="objForcePowerDescriptor">The object force power descriptor.</param>
/// <param name="result">The result.</param>
private void SetReaderToObject(ref ForcePowerDescriptor objForcePowerDescriptor, ref SqlDataReader result)
{
if (result.HasRows)
{
objForcePowerDescriptor.ForcePowerDescriptorID = (int)result.GetValue(result.GetOrdinal("ForcePowerDescriptorID"));
objForcePowerDescriptor.ForcePowerDescriptorName = result.GetValue(result.GetOrdinal("ForcePowerDescriptorName")).ToString();
objForcePowerDescriptor._objComboBoxData.Add(objForcePowerDescriptor.ForcePowerDescriptorID, objForcePowerDescriptor.ForcePowerDescriptorName);
}
}
/// <summary>
/// Clones the specified LST ForcePowerDescriptor.
/// </summary>
/// <param name="lstForcePowerDescriptor">The LST ForcePowerDescriptor.</param>
/// <returns>List<ForcePowerDescriptor></returns>
static public List <ForcePowerDescriptor> Clone(List <ForcePowerDescriptor> lstForcePowerDescriptor)
{
List <ForcePowerDescriptor> lstCForcePowerDescriptor = new List <ForcePowerDescriptor>();
foreach (ForcePowerDescriptor objForcePowerDescriptor in lstForcePowerDescriptor)
{
lstCForcePowerDescriptor.Add(ForcePowerDescriptor.Clone(objForcePowerDescriptor));
}
return(lstCForcePowerDescriptor);
}
/// <summary>
/// Gets the force power descriptor list.
/// </summary>
/// <param name="strSprocName">Name of the string sproc.</param>
/// <param name="strWhere">The string where.</param>
/// <param name="strOrderBy">The string order by.</param>
/// <returns></returns>
private List <ForcePowerDescriptor> GetForcePowerDescriptorList(string strSprocName, string strWhere, string strOrderBy)
{
List <ForcePowerDescriptor> forcePowerDescriptors = new List <ForcePowerDescriptor>();
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())
{
ForcePowerDescriptor objForcePowerDescriptor = new ForcePowerDescriptor();
SetReaderToObject(ref objForcePowerDescriptor, ref result);
forcePowerDescriptors.Add(objForcePowerDescriptor);
}
}
catch
{
Exception e = new Exception();
throw e;
}
finally
{
command.Dispose();
connection.Close();
}
return(forcePowerDescriptors);
}
/// <summary>
/// Clones the specified object ForcePowerDescriptor.
/// </summary>
/// <param name="objForcePowerDescriptor">The object ForcePowerDescriptor.</param>
/// <returns>ForcePowerDescriptor</returns>
static public ForcePowerDescriptor Clone(ForcePowerDescriptor objForcePowerDescriptor)
{
ForcePowerDescriptor objCForcePowerDescriptor = new ForcePowerDescriptor(objForcePowerDescriptor.ForcePowerDescriptorID);
return(objCForcePowerDescriptor);
}