public BMS_DAL.DS.BMSDS GetFixtureWithRelation()
{
BMS_DAL.DS.BMSDS ds = new BMS_DAL.DS.BMSDS();
using (BMS_DAL.DS.BMSDSTableAdapters.TFixturesTableAdapter ta = new BMS_DAL.DS.BMSDSTableAdapters.TFixturesTableAdapter())
{
try
{
ds.TFixtures.Merge(ta.GetData());
}
catch (Exception ex) { throw ex; }
}
using (BMS_DAL.DS.BMSDSTableAdapters.TInvoicesTableAdapter ta = new BMS_DAL.DS.BMSDSTableAdapters.TInvoicesTableAdapter())
{
try
{
ds.TInvoices.Merge(ta.GetData());
}
catch (Exception ex) { throw ex; }
}
using (BMS_DAL.DS.BMSDSTableAdapters.TInvoiceDetailsTableAdapter ta = new BMS_DAL.DS.BMSDSTableAdapters.TInvoiceDetailsTableAdapter())
{
try
{
ds.TInvoiceDetails.Merge(ta.GetData());
}
catch (Exception ex) { throw ex; }
}
return(ds);
}
public BMS_DAL.DS.BMSDS.TInvoiceDetailsDataTable GetInvoiceDetail()
{
using (BMS_DAL.DS.BMSDSTableAdapters.TInvoiceDetailsTableAdapter ta = new BMS_DAL.DS.BMSDSTableAdapters.TInvoiceDetailsTableAdapter())
{
try
{
return(ta.GetData());
}
catch (Exception ex) { throw ex; }
}
}