public void addTransmissionToTransmissionSet(TransmissionSet set, Transmission value)
{
using (AcaIrsDbEntities db = new AcaIrsDbEntities())
{
db.Entry(set).State = EntityState.Modified;
set.Transmissions.Add(value);
db.Entry(value).State = EntityState.Added;
db.SaveChanges();
}
}
public void deleteAllTransmissionSets()
{
using (AcaIrsDbEntities db = new AcaIrsDbEntities())
{
List<TransmissionSet> values = (from ts in db.TransmissionSet
select ts).ToList();
foreach (TransmissionSet value in values)
{
db.TransmissionSet.Remove(value);
}
db.SaveChanges();
}
}
public void saveTransmissionReceiptID(Transmission record)
{
using (AcaIrsDbEntities db = new AcaIrsDbEntities())
{
db.Transmission.Attach(record);
var entry = db.Entry(record);
entry.Property(e => e.ReceiptID).IsModified = true;
// other changed properties
db.SaveChanges();
}
}
public void saveTransmissionSet(TransmissionSet value)
{
using (AcaIrsDbEntities db = new AcaIrsDbEntities())
{
if (value.TransmissionSetID == default(int))
{
db.TransmissionSet.Add(value);
}
else
{
db.Entry(value).State = EntityState.Modified;
}
db.SaveChanges();
}
}
public IEnumerable<TransmissionSet> getTransmissionSet(string fiscalYear, int? month = null)
{
using (AcaIrsDbEntities db = new AcaIrsDbEntities())
{
IEnumerable<TransmissionSet> sets = (from ts in db.TransmissionSet
where ts.FiscalYear == fiscalYear
&& (ts.Month == month || month == null)
select ts);
return sets;
}
}
public void saveTransmission(Transmission record)
{
using (AcaIrsDbEntities db = new AcaIrsDbEntities())
{
db.Transmission.Attach(record);
db.Entry(record).State = EntityState.Modified;
db.SaveChanges();
}
}
public List<int> getTransmissionIDs(string fiscalYear, int? month = null)
{
using (AcaIrsDbEntities db = new AcaIrsDbEntities())
{
// Calling ToList() forces an eager load
List<int> listOfIDs = (from ts in db.TransmissionSet
join t in db.Transmission
on ts.TransmissionSetID equals t.TransmissionSet.TransmissionSetID
where ts.FiscalYear == fiscalYear
select t.TransmissionID).ToList();
return listOfIDs;
}
}
public Transmission getTransmissionByID(int id)
{
using (AcaIrsDbEntities db = new AcaIrsDbEntities())
{
Transmission record = null;
record = (from p in db.Transmission
where p.TransmissionID == id
select p)
// Call to grandchild objects forces an eager load of child and grandchild objects
.Include("Submissions.Record1094C.Employees.CoveredIndividuals")
.FirstOrDefault();
if (record == null)
{
throw new ApplicationException(String.Format("No transmission record found with ID {0}.", id));
}
return record;
}
}
public ApplicationParameter getApplicationParameter()
{
using (AcaIrsDbEntities db = new AcaIrsDbEntities())
{
ApplicationParameter ap = db.ApplicationParameter.FirstOrDefault();
if (ap == null)
{
throw new ApplicationException("No application parameters found.");
}
return ap;
}
}
public void deleteTransmissionSet(TransmissionSet value)
{
using (AcaIrsDbEntities db = new AcaIrsDbEntities())
{
db.TransmissionSet.Remove(value);
db.SaveChanges();
}
}
public void deleteTransmission(int id)
{
using (AcaIrsDbEntities db = new AcaIrsDbEntities())
{
var t = db.Transmission.Single(c => c.TransmissionID == id);
db.Transmission.Remove(t);
db.SaveChanges();
}
}
