public DetailCategory GetbyId(int id) { AssetDBContext db = new AssetDBContext(); var detialCategory = db.DetailCategories.Include(c => c.SubCategory).FirstOrDefault(c => c.Id == id); return(detialCategory); }
public Vendor GetById(int id) { AssetDBContext db = new AssetDBContext(); var vendors = db.Vendors.FirstOrDefault(c => c.Id == id); return(vendors); }
public GeneralCategory GetById(int id) { AssetDBContext db = new AssetDBContext(); var gCategory = db.GeneralCategories.FirstOrDefault(c => c.Id == id); return(gCategory); }
public IList <Organization> GetAll() { AssetDBContext db = new AssetDBContext(); var organizations = db.Organizations.ToList(); return(organizations.ToList()); }
public IList <GeneralCategory> GetAll() { AssetDBContext db = new AssetDBContext(); var gCategory = db.GeneralCategories.ToList(); return(gCategory); }
public IList <Category> GetAll() { AssetDBContext db = new AssetDBContext(); var category = db.Categories.Include(c => c.GeneralCategory).ToList(); return(category); }
public Location GetById(int id) { AssetDBContext db = new AssetDBContext(); var location = db.Locations.Include(c => c.OrganizationBranch).FirstOrDefault(c => c.Id == id); return(location); }
public bool Add(Department department) { AssetDBContext db = new AssetDBContext(); db.Departments.Add(department); int rowAffected = db.SaveChanges(); return rowAffected > 0; }
public IList <Vendor> GetAll() { AssetDBContext db = new AssetDBContext(); var vendors = db.Vendors.ToList(); return(vendors); }
public SubCategory GetById(int id) { AssetDBContext db = new AssetDBContext(); var subCategory = db.SubCategories.Include(c => c.Category).FirstOrDefault(c => c.Id == id); return(subCategory); }
public IList <OrganizationBranch> GetAll() { AssetDBContext db = new AssetDBContext(); var organizationBranches = db.OrganizationBranches.Include(c => c.Organization).ToList(); return(organizationBranches); }
public IList <Employee> GetAll() { AssetDBContext db = new AssetDBContext(); var employee = db.Employees.Include(c => c.OrganizationBranch).ToList(); return(employee); }
public IList <SubCategory> GetAll() { AssetDBContext db = new AssetDBContext(); var subCategory = db.SubCategories.Include(c => c.Category).ToList(); return(subCategory); }
public IList <Location> GetAll() { AssetDBContext db = new AssetDBContext(); var location = db.Locations.Include(c => c.OrganizationBranch).ToList(); return(location); }
public Category GetbyId(int id) { AssetDBContext db = new AssetDBContext(); var category = db.Categories.Include(c => c.GeneralCategory).FirstOrDefault(c => c.Id == id); return(category); }
public Employee GetById(int id) { AssetDBContext db = new AssetDBContext(); var employee = db.Employees.Include(c => c.OrganizationBranch).FirstOrDefault(c => c.Id == id); return(employee); }
public IList <DetailCategory> GetAll() { AssetDBContext db = new AssetDBContext(); var detialCategory = db.DetailCategories.Include(c => c.SubCategory).ToList(); return(detialCategory); }
public OrganizationBranch GetById(int id) { AssetDBContext db = new AssetDBContext(); var organizationBranch = db.OrganizationBranches.Include(c => c.Organization) .FirstOrDefault(c => c.Id == id); return(organizationBranch); }
public Organization GetById(int id) { AssetDBContext db = new AssetDBContext(); var organization = db.Organizations.FirstOrDefault(c => c.Id == id); return(organization); }
public bool Update(Department department) { AssetDBContext db = new AssetDBContext(); db.Departments.Attach(department); db.Entry(department).State = EntityState.Modified; int rowAffected = db.SaveChanges(); return rowAffected > 0; }
public bool Add(Employee employee) { AssetDBContext db = new AssetDBContext(); db.Employees.Add(employee); int rowAffected = db.SaveChanges(); return(rowAffected > 0); }
public bool Add(GeneralCategory generalCategory) { AssetDBContext db = new AssetDBContext(); db.GeneralCategories.Add(generalCategory); int rowAffected = db.SaveChanges(); return(rowAffected > 0); }
public ActionResult Entry(OrganizationBranch organizationBranch) { AssetDBContext context = new AssetDBContext(); context.OrganizationBranches.Add(organizationBranch); int rowAffected = context.SaveChanges(); return(RedirectToAction("Entry")); }
public bool Add(Location location) { AssetDBContext db = new AssetDBContext(); db.Locations.Add(location); int rowAffected = db.SaveChanges(); return(rowAffected > 0); }
public bool Add(Category category) { AssetDBContext db = new AssetDBContext(); db.Categories.Add(category); int rowAffected = db.SaveChanges(); return(rowAffected > 0); }
public bool Add(Vendor vendor) { AssetDBContext db = new AssetDBContext(); db.Vendors.Add(vendor); int rowAffected = db.SaveChanges(); return(rowAffected > 0); }
public bool Add(OrganizationBranch organizationBranch) { AssetDBContext db = new AssetDBContext(); db.OrganizationBranches.Add(organizationBranch); int rowAffacted = db.SaveChanges(); return(rowAffacted > 0); }
public bool Update(Category category) { AssetDBContext db = new AssetDBContext(); db.Categories.Attach(category); db.Entry(category).State = EntityState.Modified; int rowAffacted = db.SaveChanges(); return(rowAffacted > 0); }
public bool Update(Vendor vendor) { AssetDBContext db = new AssetDBContext(); db.Vendors.Attach(vendor); db.Entry(vendor).State = EntityState.Modified; int rowAffacted = db.SaveChanges(); return(rowAffacted > 0); }
public bool Update(Employee employee) { AssetDBContext db = new AssetDBContext(); db.Employees.Attach(employee); db.Entry(employee).State = EntityState.Modified; int rowAffected = db.SaveChanges(); return(rowAffected > 0); }