/// <summary> /// Adds a new record into the <c>tblInvoice_Detail</c> table. /// </summary> /// <param name="value">The <see cref="tblInvoice_DetailRow"/> object to be inserted.</param> public virtual void Insert(tblInvoice_DetailRow value) { IDbCommand cmd = _db.CreateCommand("dbo._tblInvoice_Detail_Insert", true); AddParameter(cmd, "Invoice_Id", value.Invoice_Id); AddParameter(cmd, "Item_Id", value.Item_Id); AddParameter(cmd, "Price", value.Price); AddParameter(cmd, "Quantity", value.Quantity); AddParameter(cmd, "Total", value.Total); AddParameter(cmd, "GL_Act_Id", value.GL_Act_Id); value.Invoice_Det_Id = Convert.ToInt32(cmd.ExecuteScalar()); }
/// <summary> /// Updates a record in the <c>tblInvoice_Detail</c> table. /// </summary> /// <param name="value">The <see cref="tblInvoice_DetailRow"/> /// object used to update the table record.</param> /// <returns>true if the record was updated; otherwise, false.</returns> public virtual bool Update(tblInvoice_DetailRow value) { IDbCommand cmd = _db.CreateCommand("dbo._tblInvoice_Detail_Update", true); AddParameter(cmd, "Invoice_Id", value.Invoice_Id); AddParameter(cmd, "Item_Id", value.Item_Id); AddParameter(cmd, "Price", value.Price); AddParameter(cmd, "Quantity", value.Quantity); AddParameter(cmd, "Total", value.Total); AddParameter(cmd, "GL_Act_Id", value.GL_Act_Id); AddParameter(cmd, "Invoice_Det_Id", value.Invoice_Det_Id); return(0 != cmd.ExecuteNonQuery()); }
/// <summary> /// Converts <see cref="System.Data.DataRow"/> to <see cref="tblInvoice_DetailRow"/>. /// </summary> /// <param name="row">The <see cref="System.Data.DataRow"/> object to be mapped.</param> /// <returns>A reference to the <see cref="tblInvoice_DetailRow"/> object.</returns> protected virtual tblInvoice_DetailRow MapRow(DataRow row) { tblInvoice_DetailRow mappedObject = new tblInvoice_DetailRow(); DataTable dataTable = row.Table; DataColumn dataColumn; // Column "Invoice_Det_Id" dataColumn = dataTable.Columns["Invoice_Det_Id"]; if (!row.IsNull(dataColumn)) { mappedObject.Invoice_Det_Id = (int)row[dataColumn]; } // Column "Invoice_Id" dataColumn = dataTable.Columns["Invoice_Id"]; if (!row.IsNull(dataColumn)) { mappedObject.Invoice_Id = (int)row[dataColumn]; } // Column "Item_Id" dataColumn = dataTable.Columns["Item_Id"]; if (!row.IsNull(dataColumn)) { mappedObject.Item_Id = (int)row[dataColumn]; } // Column "Price" dataColumn = dataTable.Columns["Price"]; if (!row.IsNull(dataColumn)) { mappedObject.Price = (int)row[dataColumn]; } // Column "Quantity" dataColumn = dataTable.Columns["Quantity"]; if (!row.IsNull(dataColumn)) { mappedObject.Quantity = (int)row[dataColumn]; } // Column "Total" dataColumn = dataTable.Columns["Total"]; if (!row.IsNull(dataColumn)) { mappedObject.Total = (int)row[dataColumn]; } // Column "GL_Act_Id" dataColumn = dataTable.Columns["GL_Act_Id"]; if (!row.IsNull(dataColumn)) { mappedObject.GL_Act_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="tblInvoice_DetailRow"/> objects.</returns> protected virtual tblInvoice_DetailRow[] 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 invoice_Det_IdColumnIndex = reader.GetOrdinal("Invoice_Det_Id"); int invoice_IdColumnIndex = reader.GetOrdinal("Invoice_Id"); int item_IdColumnIndex = reader.GetOrdinal("Item_Id"); int priceColumnIndex = reader.GetOrdinal("Price"); int quantityColumnIndex = reader.GetOrdinal("Quantity"); int totalColumnIndex = reader.GetOrdinal("Total"); int gL_Act_IdColumnIndex = reader.GetOrdinal("GL_Act_Id"); System.Collections.ArrayList recordList = new System.Collections.ArrayList(); int ri = -startIndex; while (reader.Read()) { ri++; if (ri > 0 && ri <= length) { tblInvoice_DetailRow record = new tblInvoice_DetailRow(); recordList.Add(record); record.Invoice_Det_Id = Convert.ToInt32(reader.GetValue(invoice_Det_IdColumnIndex)); record.Invoice_Id = Convert.ToInt32(reader.GetValue(invoice_IdColumnIndex)); record.Item_Id = Convert.ToInt32(reader.GetValue(item_IdColumnIndex)); record.Price = Convert.ToInt32(reader.GetValue(priceColumnIndex)); record.Quantity = Convert.ToInt32(reader.GetValue(quantityColumnIndex)); record.Total = Convert.ToInt32(reader.GetValue(totalColumnIndex)); record.GL_Act_Id = Convert.ToInt32(reader.GetValue(gL_Act_IdColumnIndex)); if (ri == length && 0 != totalRecordCount) { break; } } } totalRecordCount = 0 == totalRecordCount ? ri + startIndex : -1; return((tblInvoice_DetailRow[])(recordList.ToArray(typeof(tblInvoice_DetailRow)))); }
/// <summary> /// Deletes the specified object from the <c>tblInvoice_Detail</c> table. /// </summary> /// <param name="value">The <see cref="tblInvoice_DetailRow"/> object to delete.</param> /// <returns>true if the record was deleted; otherwise, false.</returns> public bool Delete(tblInvoice_DetailRow value) { return(DeleteByPrimaryKey(value.Invoice_Det_Id)); }