/// <summary> /// Creates a new instance of the Sol_OrderCardLink class and populates it with data from the specified SqlDataReader. /// </summary> protected virtual Sol_OrderCardLink MakeSol_OrderCardLink(SqlDataReader dataReader) { Sol_OrderCardLink sol_OrderCardLink = new Sol_OrderCardLink(); sol_OrderCardLink.CardNumber = SqlClientUtility.GetString(dataReader, "CardNumber", String.Empty); sol_OrderCardLink.OrderID = SqlClientUtility.GetInt32(dataReader, "OrderID", 0); return(sol_OrderCardLink); }
/// <summary> /// Saves a record to the Sol_OrderCardLink table. /// </summary> public virtual void Insert(Sol_OrderCardLink sol_OrderCardLink) { ValidationUtility.ValidateArgument("sol_OrderCardLink", sol_OrderCardLink); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@CardNumber", sol_OrderCardLink.CardNumber), new SqlParameter("@OrderID", sol_OrderCardLink.OrderID) }; SqlClientUtility.ExecuteNonQuery(connectionStringName, CommandType.StoredProcedure, "Sol_OrderCardLink_Insert", parameters); }
/// <summary> /// Selects all records from the Sol_OrderCardLink table by a foreign key. /// </summary> public virtual List <Sol_OrderCardLink> SelectAllByCardNumber(string cardNumber) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@CardNumber", cardNumber) }; using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(connectionStringName, CommandType.StoredProcedure, "Sol_OrderCardLink_SelectByCardNumber", parameters)) { List <Sol_OrderCardLink> sol_OrderCardLinkList = new List <Sol_OrderCardLink>(); while (dataReader.Read()) { Sol_OrderCardLink sol_OrderCardLink = MakeSol_OrderCardLink(dataReader); sol_OrderCardLinkList.Add(sol_OrderCardLink); } return(sol_OrderCardLinkList); } }