/// <summary>
/// Selects all records from the Sac_Charity table.
/// </summary>
public virtual List <Sac_Charity> SelectAll()
{
using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(connectionStringName, CommandType.StoredProcedure, "Sac_Charity_SelectAll"))
{
List <Sac_Charity> sac_CharityList = new List <Sac_Charity>();
while (dataReader.Read())
{
Sac_Charity sac_Charity = MakeSac_Charity(dataReader);
sac_CharityList.Add(sac_Charity);
}
return(sac_CharityList);
}
}
/// <summary>
/// Creates a new instance of the Sac_Charity class and populates it with data from the specified SqlDataReader.
/// </summary>
protected virtual Sac_Charity MakeSac_Charity(SqlDataReader dataReader)
{
Sac_Charity sac_Charity = new Sac_Charity();
sac_Charity.CharityID = SqlClientUtility.GetInt32(dataReader, "CharityID", 0);
sac_Charity.CustomerID = SqlClientUtility.GetInt32(dataReader, "CustomerID", 0);
sac_Charity.ShortName = SqlClientUtility.GetString(dataReader, "ShortName", String.Empty);
sac_Charity.CharityDescription = SqlClientUtility.GetString(dataReader, "CharityDescription", String.Empty);
sac_Charity.CharityTypeID = SqlClientUtility.GetInt32(dataReader, "CharityTypeID", 0);
sac_Charity.RegistrationNumber = SqlClientUtility.GetString(dataReader, "RegistrationNumber", String.Empty);
sac_Charity.IsActive = SqlClientUtility.GetBoolean(dataReader, "IsActive", false);
sac_Charity.ButtonPosition = SqlClientUtility.GetByte(dataReader, "ButtonPosition", 0x00);
sac_Charity.Logo = SqlClientUtility.GetBytes(dataReader, "Logo", new byte[0]);
return(sac_Charity);
}
/// <summary>
/// Saves a record to the Sac_Charity table.
/// </summary>
public virtual void Insert(Sac_Charity sac_Charity)
{
ValidationUtility.ValidateArgument("sac_Charity", sac_Charity);
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@CustomerID", sac_Charity.CustomerID),
new SqlParameter("@ShortName", sac_Charity.ShortName),
new SqlParameter("@CharityDescription", sac_Charity.CharityDescription),
new SqlParameter("@CharityTypeID", sac_Charity.CharityTypeID),
new SqlParameter("@RegistrationNumber", sac_Charity.RegistrationNumber),
new SqlParameter("@IsActive", sac_Charity.IsActive),
new SqlParameter("@ButtonPosition", sac_Charity.ButtonPosition),
new SqlParameter("@Logo", sac_Charity.Logo)
};
sac_Charity.CharityID = (int)SqlClientUtility.ExecuteScalar(connectionStringName, CommandType.StoredProcedure, "Sac_Charity_Insert", parameters);
}