/// <summary> /// Sets the reader to object. /// </summary> /// <param name="objExtraClassItem">The object extra class item.</param> /// <param name="result">The result.</param> private void SetReaderToObject(ref ExtraClassItem objExtraClassItem, ref SqlDataReader result) { if (result.HasRows) { objExtraClassItem.ExtraClassLevelItemID = (int)result.GetValue(result.GetOrdinal("ExtraClassLevelItemID")); objExtraClassItem.ExtraClassLevelItemName = result.GetValue(result.GetOrdinal("ExtraClassLevelItemName")).ToString(); objExtraClassItem.ExtraClassLevelItemDescription = result.GetValue(result.GetOrdinal("ExtraClassLevelItemDescription")).ToString(); objExtraClassItem._objComboBoxData.Add(objExtraClassItem.ExtraClassLevelItemID, objExtraClassItem.ExtraClassLevelItemName); } }
/// <summary> /// Clones the specified LST ExtraClassItem. /// </summary> /// <param name="lstExtraClassItem">The LST ExtraClassItem.</param> /// <returns>List<ExtraClassItem></returns> static public List <ExtraClassItem> Clone(List <ExtraClassItem> lstExtraClassItem) { List <ExtraClassItem> lstCExtraClassItem = new List <ExtraClassItem>(); foreach (ExtraClassItem objExtraClassItem in lstExtraClassItem) { lstCExtraClassItem.Add(ExtraClassItem.Clone(objExtraClassItem)); } return(lstCExtraClassItem); }
/// <summary> /// Gets the extra class item 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 ExtraClassItem Objects</returns> private List <ExtraClassItem> GetExtraClassItemList(string strSprocName, string strWhere, string strOrderBy) { List <ExtraClassItem> featPrerequisiteAbilitys = new List <ExtraClassItem>(); 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()) { ExtraClassItem objExtraClassItem = new ExtraClassItem(); SetReaderToObject(ref objExtraClassItem, ref result); featPrerequisiteAbilitys.Add(objExtraClassItem); } } catch { Exception e = new Exception(); throw e; } finally { command.Dispose(); connection.Close(); } return(featPrerequisiteAbilitys); }
/// <summary> /// Clones the specified object ExtraClassItem. /// </summary> /// <param name="objExtraClassItem">The object ExtraClassItem.</param> /// <returns>ExtraClassItem</returns> static public ExtraClassItem Clone(ExtraClassItem objExtraClassItem) { ExtraClassItem objCExtraClassItem = new ExtraClassItem(objExtraClassItem.ExtraClassLevelItemID); return(objCExtraClassItem); }