public virtual CloudAccountDA.InvoiceItemDetailDataTable GetData() { this.Adapter.SelectCommand = this.CommandCollection[0]; CloudAccountDA.InvoiceItemDetailDataTable dataTable = new CloudAccountDA.InvoiceItemDetailDataTable(); this.Adapter.Fill(dataTable); return(dataTable); }
public virtual int Fill(CloudAccountDA.InvoiceItemDetailDataTable dataTable) { this.Adapter.SelectCommand = this.CommandCollection[0]; if (this.ClearBeforeFill) { dataTable.Clear(); } return(this.Adapter.Fill(dataTable)); }
public virtual CloudAccountDA.InvoiceItemDetailDataTable DeleteByInvoiceID(int?InvoiceID) { this.Adapter.SelectCommand = this.CommandCollection[1]; if (InvoiceID.HasValue) { this.Adapter.SelectCommand.Parameters[1].Value = InvoiceID.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value; } CloudAccountDA.InvoiceItemDetailDataTable dataTable = new CloudAccountDA.InvoiceItemDetailDataTable(); this.Adapter.Fill(dataTable); return(dataTable); }
public virtual CloudAccountDA.InvoiceItemDetailDataTable InsertWithRecurring(ref int?InvoiceItemDetailID, int?InvoiceID, int?RecurringID) { this.Adapter.SelectCommand = this.CommandCollection[5]; if (InvoiceItemDetailID.HasValue) { this.Adapter.SelectCommand.Parameters[1].Value = InvoiceItemDetailID.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = DBNull.Value; } if (InvoiceID.HasValue) { this.Adapter.SelectCommand.Parameters[2].Value = InvoiceID.Value; } else { this.Adapter.SelectCommand.Parameters[2].Value = DBNull.Value; } if (RecurringID.HasValue) { this.Adapter.SelectCommand.Parameters[3].Value = RecurringID.Value; } else { this.Adapter.SelectCommand.Parameters[3].Value = DBNull.Value; } CloudAccountDA.InvoiceItemDetailDataTable dataTable = new CloudAccountDA.InvoiceItemDetailDataTable(); this.Adapter.Fill(dataTable); if ((this.Adapter.SelectCommand.Parameters[1].Value == null) || (this.Adapter.SelectCommand.Parameters[1].Value.GetType() == typeof(DBNull))) { InvoiceItemDetailID = 0; return(dataTable); } InvoiceItemDetailID = new int?((int)this.Adapter.SelectCommand.Parameters[1].Value); return(dataTable); }
public virtual int Update(CloudAccountDA.InvoiceItemDetailDataTable dataTable) { return(this.Adapter.Update(dataTable)); }