public List <ExtendedWarranty> getAllExtendedWarrantysList() { SonnenDBEntities db = new SonnenDBEntities(); List <ExtendedWarranty> ExtendedWarrantys = db.ExtendedWarranties.ToList(); return(ExtendedWarrantys); }
public List <Installer> getInstallersList() { SonnenDBEntities db = new SonnenDBEntities(); List <Installer> Installers = db.Installers.ToList(); return(Installers); }
public void DeleteExtendedWarranty(int _id) { using (SonnenDBEntities db = new SonnenDBEntities()) { db.ExtendedWarranties.Remove(db.ExtendedWarranties.FirstOrDefault(x => x.Id == _id)); db.SaveChanges(); } }
public bool AddInstaller(Installer _Installer) { using (SonnenDBEntities db = new SonnenDBEntities()) { db.Installers.Add(_Installer); db.SaveChanges(); } return(true); }
public bool UpdateExtendedWarranty(ExtendedWarranty _ExtendedWarranty) { using (SonnenDBEntities db = new SonnenDBEntities()) { db.Entry(_ExtendedWarranty).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } return(true); }
public bool AddExtendedWarranty(ExtendedWarranty _ExtendedWarranty) { using (SonnenDBEntities db = new SonnenDBEntities()) { db.ExtendedWarranties.Add(_ExtendedWarranty); db.SaveChanges(); } return(true); }
public bool UpdateInstaller(Installer _Installer) { using (SonnenDBEntities db = new SonnenDBEntities()) { db.Entry(_Installer).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } return(true); }
public Installer getInstallerById(int _Id) { Installer Installer; using (SonnenDBEntities db = new SonnenDBEntities()) { Installer = db.Installers.FirstOrDefault(x => x.Id == _Id); } return(Installer); }
public ExtendedWarranty getExtendedWarrantyById(int _Id) { ExtendedWarranty ExtendedWarranty; using (SonnenDBEntities db = new SonnenDBEntities()) { ExtendedWarranty = db.ExtendedWarranties.FirstOrDefault(x => x.Id == _Id); } return(ExtendedWarranty); }