public Billerdata getSingle(int i) { Biller a = e.Billers.Find(i); if (a != null) { Billerdata d = new Billerdata(); d.Id = a.Id; d.Branch_ID = a.Branch_ID; d.Contact = a.Contact; d.DOB = a.DOB; d.Email = a.Email; d.Password = a.Password; d.Location = a.Branch.Location; return(d); } return(null); }
public List <Billerdata> selectBillerperBranch(int id) { var a = e.Billers.Where(m => m.Branch_ID == id).ToList(); List <Billerdata> l = new List <Billerdata>(); foreach (Biller i in a) { Billerdata d = new Billerdata(); d.Id = i.Id; d.Branch_ID = i.Branch_ID; d.Contact = i.Contact; d.DOB = i.DOB; d.Email = i.Email; d.Password = i.Password; d.Location = i.Branch.Location; l.Add(d); } return(l); }
public Billerdata deleteBiller(int id) { Biller a = e.Billers.Find(id); if (a != null) { e.Billers.Remove(a); e.SaveChanges(); Billerdata d = new Billerdata(); d.Id = a.Id; d.Branch_ID = a.Branch_ID; d.Contact = a.Contact; d.DOB = a.DOB; d.Email = a.Email; d.Password = a.Password; d.Location = ""; return(d); } return(null); }
public Billerdata updateBiller(Biller a) { Biller old = e.Billers.Where( x => x.Id == a.Id).SingleOrDefault(); if (old != null) { e.Entry(old).CurrentValues.SetValues(a); e.SaveChanges(); Billerdata d = new Billerdata(); d.Id = a.Id; d.Branch_ID = a.Branch_ID; d.Contact = a.Contact; d.DOB = a.DOB; d.Email = a.Email; d.Password = a.Password; d.Location = ""; return(d); } return(null); }