/// <summary>
/// Sets the reader to object.
/// </summary>
/// <param name="objConditionTrack">The object condition track.</param>
/// <param name="result">The result.</param>
private void SetReaderToObject(ref ConditionTrack objConditionTrack, ref SqlDataReader result)
{
if (result.HasRows)
{
objConditionTrack.ConditionTrackID = (int)result.GetValue(result.GetOrdinal("ConditionTrackID"));
objConditionTrack.Modifier = (int)result.GetValue(result.GetOrdinal("Modifier"));
objConditionTrack.Description = result.GetValue(result.GetOrdinal("Description")).ToString();
objConditionTrack._objComboBoxData.Add(objConditionTrack.ConditionTrackID, objConditionTrack.Description);
}
}
/// <summary>
/// Clones the specified LST ConditionTrack.
/// </summary>
/// <param name="lstConditionTrack">The LST ConditionTrack.</param>
/// <returns>List<ConditionTrack></returns>
static public List <ConditionTrack> Clone(List <ConditionTrack> lstConditionTrack)
{
List <ConditionTrack> lstCConditionTrack = new List <ConditionTrack>();
foreach (ConditionTrack objConditionTrack in lstConditionTrack)
{
lstCConditionTrack.Add(ConditionTrack.Clone(objConditionTrack));
}
return(lstCConditionTrack);
}
/// <summary>
/// Gets the condition track 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>List of ConditionTrack Objects</returns>
private List <ConditionTrack> GetConditionTrackList(string strSprocName, string strWhere, string strOrderBy)
{
List <ConditionTrack> conditionTracks = new List <ConditionTrack>();
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())
{
ConditionTrack objConditionTrack = new ConditionTrack();
SetReaderToObject(ref objConditionTrack, ref result);
conditionTracks.Add(objConditionTrack);
}
}
catch
{
Exception e = new Exception();
throw e;
}
finally
{
command.Dispose();
connection.Close();
}
return(conditionTracks);
}
/// <summary>
/// Clones the specified object ConditionTrack.
/// </summary>
/// <param name="objConditionTrack">The object ConditionTrack.</param>
/// <returns>ConditionTrack</returns>
static public ConditionTrack Clone(ConditionTrack objConditionTrack)
{
ConditionTrack objCConditionTrack = new ConditionTrack(objConditionTrack.ConditionTrackID);
return(objCConditionTrack);
}
