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