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