public Branchdata getSingle(int i) { Branch a = e.Branches.Find(i); if (a != null) { Branchdata d = new Branchdata(); d.Id = a.Id; d.Br_Admin_ID = a.Br_Admin_ID; d.Location = a.Location; d.Br_Admin_Name = a.Branch_Admin.Name; return(d); } return(null); }
public List <Branchdata> selectBranchperAdmin(int id) { var a = e.Branches.Where(m => m.Br_Admin_ID == id).ToList(); List <Branchdata> l = new List <Branchdata>(); foreach (Branch i in a) { Branchdata d = new Branchdata(); d.Id = i.Id; d.Br_Admin_ID = i.Br_Admin_ID; d.Location = i.Location; d.Br_Admin_Name = i.Branch_Admin.Name; l.Add(d); } return(l); }
public Branchdata deleteBranch(int id) { Branch a = e.Branches.Find(id); if (a != null) { e.Branches.Remove(a); e.SaveChanges(); Branchdata d = new Branchdata(); d.Id = a.Id; d.Br_Admin_ID = a.Br_Admin_ID; d.Location = a.Location; d.Br_Admin_Name = ""; return(d); } return(null); }
public Branchdata updateBranch(Branch a) { Branch old = e.Branches.Where( x => x.Id == a.Id).SingleOrDefault(); if (old != null) { e.Entry(old).CurrentValues.SetValues(a); e.SaveChanges(); Branchdata d = new Branchdata(); d.Id = a.Id; d.Br_Admin_ID = a.Br_Admin_ID; d.Location = a.Location; d.Br_Admin_Name = ""; return(d); } return(null); }