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(); } }