/// <summary> /// Updates a record in the <c>InventoryHistory</c> table. /// </summary> /// <param name="value">The <see cref="InventoryHistoryRow"/> /// object used to update the table record.</param> /// <returns>true if the record was updated; otherwise, false.</returns> public virtual bool Update(InventoryHistoryRow value) { string sqlStr = "UPDATE [dbo].[InventoryHistory] SET " + "[command]=" + _db.CreateSqlParameterName("Command") + ", " + "[number_of_cards]=" + _db.CreateSqlParameterName("Number_of_cards") + ", " + "[denomination]=" + _db.CreateSqlParameterName("Denomination") + ", " + "[customer_acct_id]=" + _db.CreateSqlParameterName("Customer_acct_id") + ", " + "[reseller_partner_id]=" + _db.CreateSqlParameterName("Reseller_partner_id") + ", " + "[reseller_agent_id]=" + _db.CreateSqlParameterName("Reseller_agent_id") + ", " + "[person_id]=" + _db.CreateSqlParameterName("Person_id") + " WHERE " + "[service_id]=" + _db.CreateSqlParameterName("Service_id") + " AND " + "[batch_id]=" + _db.CreateSqlParameterName("Batch_id") + " AND " + "[timestamp]=" + _db.CreateSqlParameterName("Timestamp"); IDbCommand cmd = _db.CreateCommand(sqlStr); AddParameter(cmd, "Command", value.Command); AddParameter(cmd, "Number_of_cards", value.Number_of_cards); AddParameter(cmd, "Denomination", value.Denomination); AddParameter(cmd, "Customer_acct_id", value.IsCustomer_acct_idNull ? DBNull.Value : (object)value.Customer_acct_id); AddParameter(cmd, "Reseller_partner_id", value.IsReseller_partner_idNull ? DBNull.Value : (object)value.Reseller_partner_id); AddParameter(cmd, "Reseller_agent_id", value.IsReseller_agent_idNull ? DBNull.Value : (object)value.Reseller_agent_id); AddParameter(cmd, "Person_id", value.Person_id); AddParameter(cmd, "Service_id", value.Service_id); AddParameter(cmd, "Batch_id", value.Batch_id); AddParameter(cmd, "Timestamp", value.Timestamp); return(0 != cmd.ExecuteNonQuery()); }
private static void logInventoryHistory(Rbr_Db pDb, PersonDto pPerson, DateTime pTimestamp, short pServiceId, decimal pDenomination, int pBatchId, int pNumberOfCards, InventoryCommand pInventoryCommand, short pCustomerAcctId, int pResellerPartnerId, int pResellerAgentId) { var _inventoryHistoryRow = new InventoryHistoryRow(); _inventoryHistoryRow.Service_id = pServiceId; _inventoryHistoryRow.Batch_id = pBatchId; _inventoryHistoryRow.Timestamp = pTimestamp; _inventoryHistoryRow.InventoryCommand = pInventoryCommand; _inventoryHistoryRow.Number_of_cards = pNumberOfCards; _inventoryHistoryRow.Denomination = pDenomination; _inventoryHistoryRow.Person_id = pPerson.PersonId; if (pCustomerAcctId > 0) { _inventoryHistoryRow.Customer_acct_id = pCustomerAcctId; //N/A FOR THIS COMMAND } if (pResellerPartnerId > 0) { _inventoryHistoryRow.Reseller_partner_id = pResellerPartnerId; //N/A FOR THIS COMMAND } if (pResellerAgentId > 0) { _inventoryHistoryRow.Reseller_agent_id = pResellerAgentId; //N/A FOR THIS COMMAND } pDb.InventoryHistoryCollection.Insert(_inventoryHistoryRow); }
/// <summary> /// Adds a new record into the <c>InventoryHistory</c> table. /// </summary> /// <param name="value">The <see cref="InventoryHistoryRow"/> object to be inserted.</param> public virtual void Insert(InventoryHistoryRow value) { string sqlStr = "INSERT INTO [dbo].[InventoryHistory] (" + "[service_id], " + "[batch_id], " + "[timestamp], " + "[command], " + "[number_of_cards], " + "[denomination], " + "[customer_acct_id], " + "[reseller_partner_id], " + "[reseller_agent_id], " + "[person_id]" + ") VALUES (" + _db.CreateSqlParameterName("Service_id") + ", " + _db.CreateSqlParameterName("Batch_id") + ", " + _db.CreateSqlParameterName("Timestamp") + ", " + _db.CreateSqlParameterName("Command") + ", " + _db.CreateSqlParameterName("Number_of_cards") + ", " + _db.CreateSqlParameterName("Denomination") + ", " + _db.CreateSqlParameterName("Customer_acct_id") + ", " + _db.CreateSqlParameterName("Reseller_partner_id") + ", " + _db.CreateSqlParameterName("Reseller_agent_id") + ", " + _db.CreateSqlParameterName("Person_id") + ")"; IDbCommand cmd = _db.CreateCommand(sqlStr); AddParameter(cmd, "Service_id", value.Service_id); AddParameter(cmd, "Batch_id", value.Batch_id); AddParameter(cmd, "Timestamp", value.Timestamp); AddParameter(cmd, "Command", value.Command); AddParameter(cmd, "Number_of_cards", value.Number_of_cards); AddParameter(cmd, "Denomination", value.Denomination); AddParameter(cmd, "Customer_acct_id", value.IsCustomer_acct_idNull ? DBNull.Value : (object)value.Customer_acct_id); AddParameter(cmd, "Reseller_partner_id", value.IsReseller_partner_idNull ? DBNull.Value : (object)value.Reseller_partner_id); AddParameter(cmd, "Reseller_agent_id", value.IsReseller_agent_idNull ? DBNull.Value : (object)value.Reseller_agent_id); AddParameter(cmd, "Person_id", value.Person_id); cmd.ExecuteNonQuery(); }
/// <summary> /// Converts <see cref="System.Data.DataRow"/> to <see cref="InventoryHistoryRow"/>. /// </summary> /// <param name="row">The <see cref="System.Data.DataRow"/> object to be mapped.</param> /// <returns>A reference to the <see cref="InventoryHistoryRow"/> object.</returns> protected virtual InventoryHistoryRow MapRow(DataRow row) { InventoryHistoryRow mappedObject = new InventoryHistoryRow(); DataTable dataTable = row.Table; DataColumn dataColumn; // Column "Service_id" dataColumn = dataTable.Columns["Service_id"]; if (!row.IsNull(dataColumn)) { mappedObject.Service_id = (short)row[dataColumn]; } // Column "Batch_id" dataColumn = dataTable.Columns["Batch_id"]; if (!row.IsNull(dataColumn)) { mappedObject.Batch_id = (int)row[dataColumn]; } // Column "Timestamp" dataColumn = dataTable.Columns["Timestamp"]; if (!row.IsNull(dataColumn)) { mappedObject.Timestamp = (System.DateTime)row[dataColumn]; } // Column "Command" dataColumn = dataTable.Columns["Command"]; if (!row.IsNull(dataColumn)) { mappedObject.Command = (byte)row[dataColumn]; } // Column "Number_of_cards" dataColumn = dataTable.Columns["Number_of_cards"]; if (!row.IsNull(dataColumn)) { mappedObject.Number_of_cards = (int)row[dataColumn]; } // Column "Denomination" dataColumn = dataTable.Columns["Denomination"]; if (!row.IsNull(dataColumn)) { mappedObject.Denomination = (decimal)row[dataColumn]; } // Column "Customer_acct_id" dataColumn = dataTable.Columns["Customer_acct_id"]; if (!row.IsNull(dataColumn)) { mappedObject.Customer_acct_id = (short)row[dataColumn]; } // Column "Reseller_partner_id" dataColumn = dataTable.Columns["Reseller_partner_id"]; if (!row.IsNull(dataColumn)) { mappedObject.Reseller_partner_id = (int)row[dataColumn]; } // Column "Reseller_agent_id" dataColumn = dataTable.Columns["Reseller_agent_id"]; if (!row.IsNull(dataColumn)) { mappedObject.Reseller_agent_id = (int)row[dataColumn]; } // Column "Person_id" dataColumn = dataTable.Columns["Person_id"]; if (!row.IsNull(dataColumn)) { mappedObject.Person_id = (int)row[dataColumn]; } return(mappedObject); }
/// <summary> /// Reads data from the provided data reader and returns /// an array of mapped objects. /// </summary> /// <param name="reader">The <see cref="System.Data.IDataReader"/> object to read data from the table.</param> /// <param name="startIndex">The index of the first record to map.</param> /// <param name="length">The number of records to map.</param> /// <param name="totalRecordCount">A reference parameter that returns the total number /// of records in the reader object if 0 was passed into the method; otherwise it returns -1.</param> /// <returns>An array of <see cref="InventoryHistoryRow"/> objects.</returns> protected virtual InventoryHistoryRow[] MapRecords(IDataReader reader, int startIndex, int length, ref int totalRecordCount) { if (0 > startIndex) { throw new ArgumentOutOfRangeException("startIndex", startIndex, "StartIndex cannot be less than zero."); } if (0 > length) { throw new ArgumentOutOfRangeException("length", length, "Length cannot be less than zero."); } int service_idColumnIndex = reader.GetOrdinal("service_id"); int batch_idColumnIndex = reader.GetOrdinal("batch_id"); int timestampColumnIndex = reader.GetOrdinal("timestamp"); int commandColumnIndex = reader.GetOrdinal("command"); int number_of_cardsColumnIndex = reader.GetOrdinal("number_of_cards"); int denominationColumnIndex = reader.GetOrdinal("denomination"); int customer_acct_idColumnIndex = reader.GetOrdinal("customer_acct_id"); int reseller_partner_idColumnIndex = reader.GetOrdinal("reseller_partner_id"); int reseller_agent_idColumnIndex = reader.GetOrdinal("reseller_agent_id"); int person_idColumnIndex = reader.GetOrdinal("person_id"); System.Collections.ArrayList recordList = new System.Collections.ArrayList(); int ri = -startIndex; while (reader.Read()) { ri++; if (ri > 0 && ri <= length) { InventoryHistoryRow record = new InventoryHistoryRow(); recordList.Add(record); record.Service_id = Convert.ToInt16(reader.GetValue(service_idColumnIndex)); record.Batch_id = Convert.ToInt32(reader.GetValue(batch_idColumnIndex)); record.Timestamp = Convert.ToDateTime(reader.GetValue(timestampColumnIndex)); record.Command = Convert.ToByte(reader.GetValue(commandColumnIndex)); record.Number_of_cards = Convert.ToInt32(reader.GetValue(number_of_cardsColumnIndex)); record.Denomination = Convert.ToDecimal(reader.GetValue(denominationColumnIndex)); if (!reader.IsDBNull(customer_acct_idColumnIndex)) { record.Customer_acct_id = Convert.ToInt16(reader.GetValue(customer_acct_idColumnIndex)); } if (!reader.IsDBNull(reseller_partner_idColumnIndex)) { record.Reseller_partner_id = Convert.ToInt32(reader.GetValue(reseller_partner_idColumnIndex)); } if (!reader.IsDBNull(reseller_agent_idColumnIndex)) { record.Reseller_agent_id = Convert.ToInt32(reader.GetValue(reseller_agent_idColumnIndex)); } record.Person_id = Convert.ToInt32(reader.GetValue(person_idColumnIndex)); if (ri == length && 0 != totalRecordCount) { break; } } } totalRecordCount = 0 == totalRecordCount ? ri + startIndex : -1; return((InventoryHistoryRow[])(recordList.ToArray(typeof(InventoryHistoryRow)))); }
/// <summary> /// Deletes the specified object from the <c>InventoryHistory</c> table. /// </summary> /// <param name="value">The <see cref="InventoryHistoryRow"/> object to delete.</param> /// <returns>true if the record was deleted; otherwise, false.</returns> public bool Delete(InventoryHistoryRow value) { return(DeleteByPrimaryKey(value.Service_id, value.Batch_id, value.Timestamp)); }