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