public ActionResult Employees(int id)
{
using (WiredHackEntities context = new WiredHackEntities())
{
List<EmployeeProfileThumb> employees = new List<EmployeeProfileThumb>();
foreach (var item in context.GetCareerClusterEmployees(id).ToList())
{
var t = context.EmployeeJobConnections.FirstOrDefault(o => o.EmployeeID == item.Id);
t.Jobs = context.Jobs.Where(o => o.JobID == t.JobId).ToList();
EmployeeProfileThumb i = new EmployeeProfileThumb();
i.EmployeeID = context.Users.FirstOrDefault(o => o.EmployeeId.Value == item.Id).Id;
i.Name = item.FirstName + ' ' + item.LastName;
i.Image = item.Image;
i.Bio = item.Bio != null ? item.Bio : "";
i.EmployerID = context.Users.FirstOrDefault(o => o.EmployeeId.Value == item.Id).EmployerId.Value;
i.Employer = context.Employers.FirstOrDefault(o => o.EmployerID == i.EmployerID).Name + ": " + context.Employers.FirstOrDefault(o => o.EmployerID == i.EmployerID).NumEmployees;
i.Major = context.Majors.FirstOrDefault(o => o.Id == item.MajorID).Description;
i.College = context.Universities.FirstOrDefault(o => o.Id == item.UniversityID).Name;
i.JobTitle = t.Jobs.FirstOrDefault().Name;
employees.Add(i);
}
return View(employees);
}
return View();
}
public ActionResult Employers(int id)
{
using (WiredHackEntities context = new WiredHackEntities())
{
List<EmployerDetails> employers = new List<EmployerDetails>();
foreach (var item in context.Employers.ToList())
{
EmployerDetails blank = new EmployerDetails();
blank.EmployerName = item.Name;
blank.NumOfEmployees = item.NumEmployees;
blank.Industry = context.Industries.FirstOrDefault(o => o.IndustryId.ToString() == item.IndustryID).Description;
blank.Id = item.EmployerID;
employers.Add(blank);
}
return View(employers);
}
return View();
}
// GET: CareerCluster
public ActionResult Index()
{
using(WiredHackEntities context = new WiredHackEntities())
{
var clusters = context.CareerClusters;
CareerClustersModel model = new CareerClustersModel();
foreach(var c in clusters)
{
List<ChartStatistic> Jobs = new List<ChartStatistic>();
List<ChartStatistic> Schools = new List<ChartStatistic>();
foreach (var item in context.GetCareerClusterJobChart(c.CCId))
{
Jobs.Add(new ChartStatistic()
{
Name = item.Name,
Count = item.count.Value
});
}
foreach (var item in context.GetCareerClusterSchoolChart(c.CCId))
{
Schools.Add(new ChartStatistic()
{
Name = item.Name,
Count = item.count.Value
});
}
model.Clusters.Add(new Models.CareerCluster()
{
Id = c.CCId,
Name = c.Name,
Description = c.Description,
Jobs = Jobs,
Schools = Schools
});
}
return View(model);
}
}
public ActionResult CareerClusterDisplay(int id)
{
AccountDisplayViewModel model = new AccountDisplayViewModel();
using (var db = new WiredHackEntities())
{
var item = db.CareerClusters.Where(cc => cc.CCId == id);
model.ClustClusterName = item.FirstOrDefault().Name;
model.ClustClusterDescription = item.FirstOrDefault().Description;
}
return View(model);
}
public ActionResult SchoolDisplay(int Id)
{
using (var db = new WiredHackEntities())
{
var model = new AccountDisplayViewModel();
var itemUniversity = db.Universities.Where(cc => cc.Id == Id);
if (itemUniversity.Any())
{
model.UniAddress = itemUniversity.FirstOrDefault().Address;
model.UniName = itemUniversity.FirstOrDefault().Name;
model.UniState = itemUniversity.FirstOrDefault().State;
model.UniCity = itemUniversity.FirstOrDefault().City;
model.UniZip = itemUniversity.FirstOrDefault().Zip;
model.UniDescription = itemUniversity.FirstOrDefault().Description;
model.UniCounty = itemUniversity.FirstOrDefault().County;
model.UniLogo = itemUniversity.FirstOrDefault().Logo;
}
return View(model);
}
}
public ActionResult EmployerDisplay(int Id)
{
using (var db = new WiredHackEntities())
{
var model = new AccountDisplayViewModel();
var itemEmployer =
db.Employers.Where(cc => cc.EmployerID == Id);
if (itemEmployer.Any())
{
model.EmployerName = itemEmployer.FirstOrDefault().Name;
model.EmployerDescription = itemEmployer.FirstOrDefault().Description;
model.EmployerId = itemEmployer.FirstOrDefault().EmployerID;
model.EmployerAddress = itemEmployer.FirstOrDefault().Address + "</br>" +
itemEmployer.FirstOrDefault().Address2;
model.EmployerCity = itemEmployer.FirstOrDefault().City;
model.EmployerState = itemEmployer.FirstOrDefault().State;
model.EmployerZip = itemEmployer.FirstOrDefault().Zip;
model.EmployerCounty = itemEmployer.FirstOrDefault().County;
model.EmployerPhone = itemEmployer.FirstOrDefault().Phone;
model.EmployerAmtOfEmployees = itemEmployer.FirstOrDefault().NumEmployees;
model.EmployerLogo = itemEmployer.FirstOrDefault().Logo;
}
return View(model);
}
}
public ActionResult JobDisplay(int Id)
{
using (var db = new WiredHackEntities())
{
var model = new AccountDisplayViewModel();
var itemEmployeeJonCon = db.EmployeeJobConnections.Where(cc => cc.JobId == Id);
if (itemEmployeeJonCon.Any())
{
model.JobPayRate = itemEmployeeJonCon.FirstOrDefault().PayRate;
model.JobStartDate = itemEmployeeJonCon.FirstOrDefault().StartDate;
model.JobEndDate = itemEmployeeJonCon.FirstOrDefault().EndDate.HasValue
? itemEmployeeJonCon.FirstOrDefault().EndDate.Value
: new DateTime(1, 1, 1);
var itemJob = db.Jobs.Where(cc => cc.JobID == itemEmployeeJonCon.FirstOrDefault().JobId);
if (itemJob.Any())
{
model.JobName = itemJob.FirstOrDefault().Name;
model.JobBaseSalary = itemJob.FirstOrDefault().BaseSalary;
}
var itemJobCCConnect =
db.JobCCConnections.Where(cc => cc.JobID == itemJob.FirstOrDefault().JobID);
if (itemJobCCConnect.Any())
{
var itemCareerCluster =
db.CareerClusters.Where(
cc => cc.CCId == itemJobCCConnect.FirstOrDefault().CCID);
if (itemCareerCluster.Any())
{
model.ClustClusterDescription =
itemCareerCluster.FirstOrDefault().Description;
model.ClustClusterName = itemCareerCluster.FirstOrDefault().Name;
model.CCID = itemCareerCluster.FirstOrDefault().CCId;
}
}
}
return View(model);
}
}
public ActionResult AccountDisplay(int Id)
{
AccountDisplayViewModel model = new AccountDisplayViewModel();
using (var db = new WiredHackEntities())
{
var itemUsers = db.Users.Where(cc => cc.Id == Id);
model.AccFirstName = itemUsers.FirstOrDefault().FirstName;
model.AccLastName = itemUsers.FirstOrDefault().LastName;
if (itemUsers.FirstOrDefault().EmployerId.HasValue)
{
var itemEmployer =
db.Employers.Where(cc => cc.EmployerID == itemUsers.FirstOrDefault().EmployerId.Value);
if (itemEmployer.Any())
{
model.EmployerName = itemEmployer.FirstOrDefault().Name;
model.EmployerDescription = itemEmployer.FirstOrDefault().Description;
model.EmployerId = itemEmployer.FirstOrDefault().EmployerID;
model.EmployerAddress = itemEmployer.FirstOrDefault().Address + "</br>" +
itemEmployer.FirstOrDefault().Address2;
model.EmployerCity = itemEmployer.FirstOrDefault().City;
model.EmployerState = itemEmployer.FirstOrDefault().State;
model.EmployerZip = itemEmployer.FirstOrDefault().Zip;
model.EmployerCounty = itemEmployer.FirstOrDefault().County;
model.EmployerPhone = itemEmployer.FirstOrDefault().Phone;
model.EmployerAmtOfEmployees = itemEmployer.FirstOrDefault().NumEmployees;
model.EmployerLogo = itemEmployer.FirstOrDefault().Logo;
}
}
if (itemUsers.FirstOrDefault().EmployeeId.HasValue)
{
model.AccEmployeeId = itemUsers.FirstOrDefault().EmployeeId.Value;
var itemEmployee = db.Employees.Where(cc => cc.Id == itemUsers.FirstOrDefault().Id);
if (itemEmployee.Any())
{
model.AccAddress = itemEmployee.FirstOrDefault().Address;
model.AccCity = itemEmployee.FirstOrDefault().City;
model.AccState = itemEmployee.FirstOrDefault().State;
model.AccZip = itemEmployee.FirstOrDefault().Zip;
model.AccCounty = itemEmployee.FirstOrDefault().County;
model.AccImage = itemEmployee.FirstOrDefault().Image;
model.AccJobId = itemEmployee.FirstOrDefault().JobID.HasValue
? itemEmployee.FirstOrDefault().JobID.Value
: 0;
model.AccBio = itemEmployee.FirstOrDefault().Bio;
model.UniID = itemEmployee.FirstOrDefault().UniversityID;
model.MajorID = itemEmployee.FirstOrDefault().MajorID;
var itemEmployeeJonCon = db.EmployeeJobConnections.Where(cc => cc.JobId == model.AccJobId);
if (itemEmployeeJonCon.Any())
{
model.JobPayRate = itemEmployeeJonCon.FirstOrDefault().PayRate;
model.JobStartDate = itemEmployeeJonCon.FirstOrDefault().StartDate;
model.JobEndDate = itemEmployeeJonCon.FirstOrDefault().EndDate.HasValue
? itemEmployeeJonCon.FirstOrDefault().EndDate.Value
: new DateTime(1, 1, 1);
var itemJob = db.Jobs.Where(cc => cc.JobID == itemEmployeeJonCon.FirstOrDefault().JobId);
if (itemJob.Any())
{
model.JobName = itemJob.FirstOrDefault().Name;
model.JobBaseSalary = itemJob.FirstOrDefault().BaseSalary;
var itemJobCCConnect =
db.JobCCConnections.Where(cc => cc.JobID == itemJob.FirstOrDefault().JobID);
if (itemJobCCConnect.Any())
{
var itemCareerCluster =
db.CareerClusters.Where(
cc => cc.CCId == itemJobCCConnect.FirstOrDefault().CCID);
if (itemCareerCluster.Any())
{
model.ClustClusterDescription =
itemCareerCluster.FirstOrDefault().Description;
model.ClustClusterName = itemCareerCluster.FirstOrDefault().Name;
model.CCID = itemCareerCluster.FirstOrDefault().CCId;
}
}
}
}
var itemUniversity = db.Universities.Where(cc => cc.Id == model.UniID);
if (itemUniversity.Any())
{
model.UniAddress = itemUniversity.FirstOrDefault().Address;
model.UniName = itemUniversity.FirstOrDefault().Name;
model.UniState = itemUniversity.FirstOrDefault().State;
model.UniCity = itemUniversity.FirstOrDefault().City;
model.UniZip = itemUniversity.FirstOrDefault().Zip;
model.UniDescription = itemUniversity.FirstOrDefault().Description;
model.UniCounty = itemUniversity.FirstOrDefault().County;
model.UniLogo = itemUniversity.FirstOrDefault().Logo;
}
var itemMajor = db.Majors.Where(cc => cc.Id == model.MajorID);
if (itemMajor.Any())
{
model.MajorDescription = itemMajor.FirstOrDefault().Description;
}
}
}
}
return View(model);
}
public ActionResult Register(User model)
{
if (ModelState.IsValid)
{
using (var context = new WiredHackEntities())
{
context.CreateAccount(model.FirstName, model.LastName, null, model.Username, model.PasswordHash, model.Email);
//context.Users.Add(model);
//context.SaveChanges();
}
return RedirectToAction("Index", "Home");
//AddErrors(result);
}
// If we got this far, something failed, redisplay form
return View(model);
}
