/// <summary>
/// Creates a new instance of the Sac_CharityType class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Sac_CharityType MakeSac_CharityType(SqlDataReader dataReader)
{
Sac_CharityType sac_CharityType = new Sac_CharityType();
sac_CharityType.CharityTypeID = SqlClientUtility.GetInt32(dataReader, "CharityTypeID", 0);
sac_CharityType.CharityType = SqlClientUtility.GetString(dataReader, "CharityType", String.Empty);
return(sac_CharityType);
}
/// <summary>
/// Updates a record in the Sac_CharityType table.
/// </summary>
public virtual void Update(Sac_CharityType sac_CharityType)
{
ValidationUtility.ValidateArgument("sac_CharityType", sac_CharityType);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@CharityTypeID", sac_CharityType.CharityTypeID),
new SqlParameter("@CharityType", sac_CharityType.CharityType)
};
SqlClientUtility.ExecuteNonQuery(connectionStringName, CommandType.StoredProcedure, "Sac_CharityType_Update", parameters);
}
/// <summary>
/// Selects all records from the Sac_CharityType table.
/// </summary>
public virtual List <Sac_CharityType> SelectAll()
{
using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(connectionStringName, CommandType.StoredProcedure, "Sac_CharityType_SelectAll"))
{
List <Sac_CharityType> sac_CharityTypeList = new List <Sac_CharityType>();
while (dataReader.Read())
{
Sac_CharityType sac_CharityType = MakeSac_CharityType(dataReader);
sac_CharityTypeList.Add(sac_CharityType);
}
return(sac_CharityTypeList);
}
}
