/// <summary>
/// Creates a new instance of the Qds_CardType class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Qds_CardType MakeQds_CardType(SqlDataReader dataReader)
{
Qds_CardType qds_CardType = new Qds_CardType();
qds_CardType.CardTypeID = SqlClientUtility.GetInt32(dataReader, "CardTypeID", 0);
qds_CardType.CardType = SqlClientUtility.GetString(dataReader, "CardType", String.Empty);
return(qds_CardType);
}
/// <summary>
/// Saves a record to the Qds_CardType table.
/// </summary>
public virtual void Insert(Qds_CardType qds_CardType)
{
ValidationUtility.ValidateArgument("qds_CardType", qds_CardType);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@CardType", qds_CardType.CardType)
};
qds_CardType.CardTypeID = (int)SqlClientUtility.ExecuteScalar(connectionStringName, CommandType.StoredProcedure, "Qds_CardType_Insert", parameters);
}
/// <summary>
/// Updates a record in the Qds_CardType table.
/// </summary>
public virtual void Update(Qds_CardType qds_CardType)
{
ValidationUtility.ValidateArgument("qds_CardType", qds_CardType);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@CardTypeID", qds_CardType.CardTypeID),
new SqlParameter("@CardType", qds_CardType.CardType)
};
SqlClientUtility.ExecuteNonQuery(connectionStringName, CommandType.StoredProcedure, "Qds_CardType_Update", parameters);
}
/// <summary>
/// Selects all records from the Qds_CardType table.
/// </summary>
public virtual List <Qds_CardType> SelectAll()
{
using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(connectionStringName, CommandType.StoredProcedure, "Qds_CardType_SelectAll"))
{
List <Qds_CardType> qds_CardTypeList = new List <Qds_CardType>();
while (dataReader.Read())
{
Qds_CardType qds_CardType = MakeQds_CardType(dataReader);
qds_CardTypeList.Add(qds_CardType);
}
return(qds_CardTypeList);
}
}
