/// <summary> /// Creates a new instance of the sol_ExpenseTypes class and populates it with data from the specified SqlDataReader. /// </summary> protected virtual Sol_ExpenseType MakeSol_ExpenseType(SqlDataReader dataReader) { Sol_ExpenseType sol_ExpenseType = new Sol_ExpenseType(); sol_ExpenseType.ExpenseTypeID = SqlClientUtility.GetInt32(dataReader, "ExpenseTypeID", 0); sol_ExpenseType.Description = SqlClientUtility.GetString(dataReader, "Description", String.Empty); return(sol_ExpenseType); }
/// <summary> /// Saves a record to the sol_ExpenseTypes table. /// </summary> public virtual void Insert(Sol_ExpenseType sol_ExpenseType) { ValidationUtility.ValidateArgument("sol_ExpenseType", sol_ExpenseType); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@Description", sol_ExpenseType.Description) }; sol_ExpenseType.ExpenseTypeID = (int)SqlClientUtility.ExecuteScalar(connectionStringName, CommandType.StoredProcedure, "sol_ExpenseTypes_Insert", parameters); }
/// <summary> /// Updates a record in the sol_ExpenseTypes table. /// </summary> public virtual void Update(Sol_ExpenseType sol_ExpenseType) { ValidationUtility.ValidateArgument("sol_ExpenseType", sol_ExpenseType); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ExpenseTypeID", sol_ExpenseType.ExpenseTypeID), new SqlParameter("@Description", sol_ExpenseType.Description) }; SqlClientUtility.ExecuteNonQuery(connectionStringName, CommandType.StoredProcedure, "sol_ExpenseTypes_Update", parameters); }
/// <summary> /// Selects all records from the sol_ExpenseTypes table. /// </summary> public virtual List <Sol_ExpenseType> SelectAll() { using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(connectionStringName, CommandType.StoredProcedure, "sol_ExpenseTypes_SelectAll")) { List <Sol_ExpenseType> sol_ExpenseTypeList = new List <Sol_ExpenseType>(); while (dataReader.Read()) { Sol_ExpenseType sol_ExpenseType = MakeSol_ExpenseType(dataReader); sol_ExpenseTypeList.Add(sol_ExpenseType); } return(sol_ExpenseTypeList); } }