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