public ICollection<Employee> GetOrgEmp(int ClientId) { var context = new ubietydbEntities(); context.Configuration.ProxyCreationEnabled = false; var empclients = context.Employees.Where(b => b.CompanyId == ClientId).ToList(); return empclients; }
public ICollection<Client> GetOrgEmpClients(int EmpId) { List<Client> clientCollection = new List<Client>(); using (var context = new ubietydbEntities()) { var empclients = context.EmpClients.Where(b => b.EmpId == EmpId); foreach (var client in empclients) { clientCollection.Add(db.Clients.Find(client.ClientId)); } } return clientCollection; }
public ActionResult Index() { ubietydbEntities dbcontext = new ubietydbEntities(); using (var context = new ubietydbEntities()) { var allRows = from b in context.EmpStatus select new SelectListItem { Value = b.EmpStatusId.ToString(), Text = b.StatusName }; var model = new EmpStatu { //EmpStatuses = allRows }; } return View(); }