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