/// <summary> /// Adds a new record into the <c>tblInvoice</c> table. /// </summary> /// <param name="value">The <see cref="tblInvoiceRow"/> object to be inserted.</param> public virtual void Insert(tblInvoiceRow value) { IDbCommand cmd = _db.CreateCommand("dbo._tblInvoice_Insert", true); AddParameter(cmd, "Invoice_No", value.Invoice_No); AddParameter(cmd, "Invoice_Date", value.Invoice_Date); AddParameter(cmd, "Vendor_Id", value.IsVendor_IdNull ? DBNull.Value : (object)value.Vendor_Id); AddParameter(cmd, "Reference", value.Reference); AddParameter(cmd, "Purchase_No", value.Purchase_No); AddParameter(cmd, "Gross_Total", value.Gross_Total); AddParameter(cmd, "Discount", value.Discount); AddParameter(cmd, "Net_Total", value.Net_Total); AddParameter(cmd, "Donor_Id", value.Donor_Id); AddParameter(cmd, "Company_Id", value.Company_Id); AddParameter(cmd, "Created_By", value.Created_By); AddParameter(cmd, "Created_Time", value.Created_Time); AddParameter(cmd, "Updated_By", value.Updated_By); AddParameter(cmd, "Updated_Time", value.Updated_Time); value.Invoice_Id = Convert.ToInt32(cmd.ExecuteScalar()); }
/// <summary> /// Updates a record in the <c>tblInvoice</c> table. /// </summary> /// <param name="value">The <see cref="tblInvoiceRow"/> /// object used to update the table record.</param> /// <returns>true if the record was updated; otherwise, false.</returns> public virtual bool Update(tblInvoiceRow value) { IDbCommand cmd = _db.CreateCommand("dbo._tblInvoice_Update", true); AddParameter(cmd, "Invoice_No", value.Invoice_No); AddParameter(cmd, "Invoice_Date", value.Invoice_Date); AddParameter(cmd, "Vendor_Id", value.IsVendor_IdNull ? DBNull.Value : (object)value.Vendor_Id); AddParameter(cmd, "Reference", value.Reference); AddParameter(cmd, "Purchase_No", value.Purchase_No); AddParameter(cmd, "Gross_Total", value.Gross_Total); AddParameter(cmd, "Discount", value.Discount); AddParameter(cmd, "Net_Total", value.Net_Total); AddParameter(cmd, "Donor_Id", value.Donor_Id); AddParameter(cmd, "Company_Id", value.Company_Id); AddParameter(cmd, "Created_By", value.Created_By); AddParameter(cmd, "Created_Time", value.Created_Time); AddParameter(cmd, "Updated_By", value.Updated_By); AddParameter(cmd, "Updated_Time", value.Updated_Time); AddParameter(cmd, "Invoice_Id", value.Invoice_Id); return(0 != cmd.ExecuteNonQuery()); }
/// <summary> /// Converts <see cref="System.Data.DataRow"/> to <see cref="tblInvoiceRow"/>. /// </summary> /// <param name="row">The <see cref="System.Data.DataRow"/> object to be mapped.</param> /// <returns>A reference to the <see cref="tblInvoiceRow"/> object.</returns> protected virtual tblInvoiceRow MapRow(DataRow row) { tblInvoiceRow mappedObject = new tblInvoiceRow(); DataTable dataTable = row.Table; DataColumn dataColumn; // Column "Invoice_Id" dataColumn = dataTable.Columns["Invoice_Id"]; if (!row.IsNull(dataColumn)) { mappedObject.Invoice_Id = (int)row[dataColumn]; } // Column "Invoice_No" dataColumn = dataTable.Columns["Invoice_No"]; if (!row.IsNull(dataColumn)) { mappedObject.Invoice_No = (string)row[dataColumn]; } // Column "Invoice_Date" dataColumn = dataTable.Columns["Invoice_Date"]; if (!row.IsNull(dataColumn)) { mappedObject.Invoice_Date = (System.DateTime)row[dataColumn]; } // Column "Vendor_Id" dataColumn = dataTable.Columns["Vendor_Id"]; if (!row.IsNull(dataColumn)) { mappedObject.Vendor_Id = (int)row[dataColumn]; } // Column "Reference" dataColumn = dataTable.Columns["Reference"]; if (!row.IsNull(dataColumn)) { mappedObject.Reference = (string)row[dataColumn]; } // Column "Purchase_No" dataColumn = dataTable.Columns["Purchase_No"]; if (!row.IsNull(dataColumn)) { mappedObject.Purchase_No = (string)row[dataColumn]; } // Column "Gross_Total" dataColumn = dataTable.Columns["Gross_Total"]; if (!row.IsNull(dataColumn)) { mappedObject.Gross_Total = (int)row[dataColumn]; } // Column "Discount" dataColumn = dataTable.Columns["Discount"]; if (!row.IsNull(dataColumn)) { mappedObject.Discount = (int)row[dataColumn]; } // Column "Net_Total" dataColumn = dataTable.Columns["Net_Total"]; if (!row.IsNull(dataColumn)) { mappedObject.Net_Total = (int)row[dataColumn]; } // Column "Donor_Id" dataColumn = dataTable.Columns["Donor_Id"]; if (!row.IsNull(dataColumn)) { mappedObject.Donor_Id = (int)row[dataColumn]; } // Column "Company_Id" dataColumn = dataTable.Columns["Company_Id"]; if (!row.IsNull(dataColumn)) { mappedObject.Company_Id = (int)row[dataColumn]; } // Column "Created_By" dataColumn = dataTable.Columns["Created_By"]; if (!row.IsNull(dataColumn)) { mappedObject.Created_By = (int)row[dataColumn]; } // Column "Created_Time" dataColumn = dataTable.Columns["Created_Time"]; if (!row.IsNull(dataColumn)) { mappedObject.Created_Time = (System.DateTime)row[dataColumn]; } // Column "Updated_By" dataColumn = dataTable.Columns["Updated_By"]; if (!row.IsNull(dataColumn)) { mappedObject.Updated_By = (int)row[dataColumn]; } // Column "Updated_Time" dataColumn = dataTable.Columns["Updated_Time"]; if (!row.IsNull(dataColumn)) { mappedObject.Updated_Time = (System.DateTime)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="tblInvoiceRow"/> objects.</returns> protected virtual tblInvoiceRow[] 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_IdColumnIndex = reader.GetOrdinal("Invoice_Id"); int invoice_NoColumnIndex = reader.GetOrdinal("Invoice_No"); int invoice_DateColumnIndex = reader.GetOrdinal("Invoice_Date"); int vendor_IdColumnIndex = reader.GetOrdinal("Vendor_Id"); int referenceColumnIndex = reader.GetOrdinal("Reference"); int purchase_NoColumnIndex = reader.GetOrdinal("Purchase_No"); int gross_TotalColumnIndex = reader.GetOrdinal("Gross_Total"); int discountColumnIndex = reader.GetOrdinal("Discount"); int net_TotalColumnIndex = reader.GetOrdinal("Net_Total"); int donor_IdColumnIndex = reader.GetOrdinal("Donor_Id"); int company_IdColumnIndex = reader.GetOrdinal("Company_Id"); int created_ByColumnIndex = reader.GetOrdinal("Created_By"); int created_TimeColumnIndex = reader.GetOrdinal("Created_Time"); int updated_ByColumnIndex = reader.GetOrdinal("Updated_By"); int updated_TimeColumnIndex = reader.GetOrdinal("Updated_Time"); System.Collections.ArrayList recordList = new System.Collections.ArrayList(); int ri = -startIndex; while (reader.Read()) { ri++; if (ri > 0 && ri <= length) { tblInvoiceRow record = new tblInvoiceRow(); recordList.Add(record); record.Invoice_Id = Convert.ToInt32(reader.GetValue(invoice_IdColumnIndex)); record.Invoice_No = Convert.ToString(reader.GetValue(invoice_NoColumnIndex)); record.Invoice_Date = Convert.ToDateTime(reader.GetValue(invoice_DateColumnIndex)); if (!reader.IsDBNull(vendor_IdColumnIndex)) { record.Vendor_Id = Convert.ToInt32(reader.GetValue(vendor_IdColumnIndex)); } if (!reader.IsDBNull(referenceColumnIndex)) { record.Reference = Convert.ToString(reader.GetValue(referenceColumnIndex)); } if (!reader.IsDBNull(purchase_NoColumnIndex)) { record.Purchase_No = Convert.ToString(reader.GetValue(purchase_NoColumnIndex)); } record.Gross_Total = Convert.ToInt32(reader.GetValue(gross_TotalColumnIndex)); record.Discount = Convert.ToInt32(reader.GetValue(discountColumnIndex)); record.Net_Total = Convert.ToInt32(reader.GetValue(net_TotalColumnIndex)); record.Donor_Id = Convert.ToInt32(reader.GetValue(donor_IdColumnIndex)); record.Company_Id = Convert.ToInt32(reader.GetValue(company_IdColumnIndex)); record.Created_By = Convert.ToInt32(reader.GetValue(created_ByColumnIndex)); record.Created_Time = Convert.ToDateTime(reader.GetValue(created_TimeColumnIndex)); record.Updated_By = Convert.ToInt32(reader.GetValue(updated_ByColumnIndex)); record.Updated_Time = Convert.ToDateTime(reader.GetValue(updated_TimeColumnIndex)); if (ri == length && 0 != totalRecordCount) { break; } } } totalRecordCount = 0 == totalRecordCount ? ri + startIndex : -1; return((tblInvoiceRow[])(recordList.ToArray(typeof(tblInvoiceRow)))); }
/// <summary> /// Deletes the specified object from the <c>tblInvoice</c> table. /// </summary> /// <param name="value">The <see cref="tblInvoiceRow"/> object to delete.</param> /// <returns>true if the record was deleted; otherwise, false.</returns> public bool Delete(tblInvoiceRow value) { return(DeleteByPrimaryKey(value.Invoice_Id)); }