public async Task <IActionResult> Edit(int id, [Bind("PositionMajorID")] PositionMajor positionMajor)
{
if (id != positionMajor.PositionMajorID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(positionMajor);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!PositionMajorExists(positionMajor.PositionMajorID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(positionMajor));
}
public async Task <IActionResult> Create([Bind("PositionMajorID")] PositionMajor positionMajor)
{
if (ModelState.IsValid)
{
_context.Add(positionMajor);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(positionMajor));
}
public IActionResult Create([Bind("PositionID,Title,PositionType,Location,Deadline,Company,Description")] Position position, int SelectedCompany, int[] SelectedMajors)
{
//find company
Company pos_company = _context.Companies.Find(SelectedCompany);
position.Company = pos_company;
if (ModelState.IsValid)
{
_context.Add(position);
_context.SaveChanges();
//add navigational data
Position dbPosition = _context.Positions.FirstOrDefault(c => c.PositionID == position.PositionID);
//loop through the selected movies
if (SelectedMajors == null || SelectedMajors.Length == 0)
{
PositionMajor cd = new PositionMajor();
cd.Position = dbPosition;
cd.Major = _context.Majors.Find(7);
_context.PositionMajors.Add(cd);
_context.SaveChanges();
}
else
{
foreach (int d in SelectedMajors)
{
//find the movie specified by the int
Major maj = _context.Majors.Find(d);
//create a new instance of the bridge table class
PositionMajor cd = new PositionMajor();
cd.Position = dbPosition;
cd.Major = maj;
//add the new record to the database
_context.PositionMajors.Add(cd);
_context.SaveChanges();
}
}
return(RedirectToAction(nameof(Index)));
}
ViewBag.YourCompanies = new SelectList(Enum.GetValues(typeof(PositionDuration)));
ViewBag.AllMajors = GetMultiMajors();
ViewBag.AllCompanies = GetAllCompanies();
return(View(position));
}
public static void SeedAllPositions(AppDbContext db)
{
if (db.Positions.Count() == 16)
{
throw new NotSupportedException("The database already contains all 16 Positions!");
}
Int32 intPositionsAdded = 0;
String strPositionTitle = "Begin"; //helps to keep track of error on positions
List <Position> Positions = new List <Position>();
try
{
Position p1 = new Position()
{
Title = "Supply Chain Internship",
PositionType = PositionDuration.I,
Location = "Houston, Texas",
Deadline = new DateTime(2019, 5, 5),
Description = ""
};
p1.Company = db.Companies.FirstOrDefault(g => g.CompanyName == "Shell");
Positions.Add(p1);
PositionMajor pm1 = new PositionMajor();
pm1.Major = db.Majors.FirstOrDefault(g => g.MajorName == "Supply Chain Management");
pm1.Position = p1;
p1.PositionMajors.Add(pm1);
Position p2 = new Position()
{
Title = "Accounting Intern",
PositionType = PositionDuration.I,
Location = "Austin, Texas",
Deadline = new DateTime(2019, 5, 1),
Description = "Work in our audit group"
};
p2.Company = db.Companies.FirstOrDefault(g => g.CompanyName == "Deloitte");
Positions.Add(p2);
PositionMajor pm2 = new PositionMajor();
pm2.Major = db.Majors.FirstOrDefault(g => g.MajorName == "Accounting");
pm2.Position = p2;
p2.PositionMajors.Add(pm2);
Position p3 = new Position()
{
Title = "Web Development",
PositionType = PositionDuration.FT,
Location = "Richmond, Virginia",
Deadline = new DateTime(2019, 3, 14),
Description = "Developing a great new website for customer portfolio management"
};
p3.Company = db.Companies.FirstOrDefault(g => g.CompanyName == "Capital One");
Positions.Add(p3);
PositionMajor pm3 = new PositionMajor();
pm3.Major = db.Majors.FirstOrDefault(g => g.MajorName == "MIS");
pm3.Position = p3;
p3.PositionMajors.Add(pm3);
Position p4 = new Position()
{
Title = "Sales Associate",
PositionType = PositionDuration.FT,
Location = "Los Angeles, California",
Deadline = new DateTime(2019, 4, 1),
Description = ""
};
p4.Company = db.Companies.FirstOrDefault(g => g.CompanyName == "Aon");
Positions.Add(p4);
PositionMajor pm4 = new PositionMajor();
pm4.Major = db.Majors.FirstOrDefault(g => g.MajorName == "Accounting");
pm4.Position = p4;
p4.PositionMajors.Add(pm4);
PositionMajor pm5 = new PositionMajor();
pm5.Major = db.Majors.FirstOrDefault(g => g.MajorName == "Marketing");
pm5.Position = p4;
p4.PositionMajors.Add(pm5);
PositionMajor pm6 = new PositionMajor();
pm6.Major = db.Majors.FirstOrDefault(g => g.MajorName == "Finance");
pm6.Position = p4;
p4.PositionMajors.Add(pm6);
Position p5 = new Position()
{
Title = "Amenities Analytics Intern",
PositionType = PositionDuration.I,
Location = "New York, New York",
Deadline = new DateTime(2019, 3, 30),
Description = "Help analyze our amenities and customer rewards programs"
};
p5.Company = db.Companies.FirstOrDefault(g => g.CompanyName == "Hilton Worldwide");
Positions.Add(p5);
PositionMajor pm7 = new PositionMajor();
pm7.Major = db.Majors.FirstOrDefault(g => g.MajorName == "Finance");
pm7.Position = p5;
p5.PositionMajors.Add(pm7);
PositionMajor pm8 = new PositionMajor();
pm8.Major = db.Majors.FirstOrDefault(g => g.MajorName == "MIS");
pm8.Position = p5;
p5.PositionMajors.Add(pm8);
PositionMajor pm9 = new PositionMajor();
pm9.Major = db.Majors.FirstOrDefault(g => g.MajorName == "Marketing");
pm9.Position = p5;
p5.PositionMajors.Add(pm9);
PositionMajor pm10 = new PositionMajor();
pm10.Major = db.Majors.FirstOrDefault(g => g.MajorName == "Business Honors");
pm10.Position = p5;
p5.PositionMajors.Add(pm10);
Position p6 = new Position()
{
Title = "Junior Programmer",
PositionType = PositionDuration.I,
Location = "Redmond, Washington",
Deadline = new DateTime(2019, 4, 3),
Description = ""
};
p6.Company = db.Companies.FirstOrDefault(g => g.CompanyName == "Microsoft");
Positions.Add(p6);
PositionMajor pm11 = new PositionMajor();
pm11.Major = db.Majors.FirstOrDefault(g => g.MajorName == "MIS");
pm11.Position = p6;
p6.PositionMajors.Add(pm11);
Position p7 = new Position()
{
Title = "Consultant ",
PositionType = PositionDuration.I,
Location = "Houston, Texas",
Deadline = new DateTime(2019, 4, 15),
Description = "Full-time consultant position"
};
p7.Company = db.Companies.FirstOrDefault(g => g.CompanyName == "Accenture");
Positions.Add(p7);
PositionMajor pm12 = new PositionMajor();
pm12.Major = db.Majors.FirstOrDefault(g => g.MajorName == "MIS");
pm12.Position = p7;
p7.PositionMajors.Add(pm12);
PositionMajor pm13 = new PositionMajor();
pm13.Major = db.Majors.FirstOrDefault(g => g.MajorName == "Accounting");
pm13.Position = p7;
p7.PositionMajors.Add(pm13);
PositionMajor pm14 = new PositionMajor();
pm14.Major = db.Majors.FirstOrDefault(g => g.MajorName == "Business Honors");
pm14.Position = p7;
p7.PositionMajors.Add(pm14);
Position p8 = new Position()
{
Title = "Project Manager",
PositionType = PositionDuration.FT,
Location = "Chicago, Illinois",
Deadline = new DateTime(2019, 6, 1),
Description = ""
};
p8.Company = db.Companies.FirstOrDefault(g => g.CompanyName == "Aon");
Positions.Add(p8);
PositionMajor pm15 = new PositionMajor();
pm15.Major = db.Majors.FirstOrDefault(g => g.MajorName == "MIS");
pm15.Position = p8;
p8.PositionMajors.Add(pm15);
PositionMajor pm16 = new PositionMajor();
pm16.Major = db.Majors.FirstOrDefault(g => g.MajorName == "Supply Chain Management");
pm16.Position = p8;
p8.PositionMajors.Add(pm16);
PositionMajor pm17 = new PositionMajor();
pm17.Major = db.Majors.FirstOrDefault(g => g.MajorName == "Accounting");
pm17.Position = p8;
p8.PositionMajors.Add(pm17);
PositionMajor pm18 = new PositionMajor();
pm18.Major = db.Majors.FirstOrDefault(g => g.MajorName == "Marketing");
pm18.Position = p8;
p8.PositionMajors.Add(pm18);
Position p9 = new Position()
{
Title = "Account Manager",
PositionType = PositionDuration.FT,
Location = "Dallas, Texas",
Deadline = new DateTime(2019, 2, 28),
Description = ""
};
p9.Company = db.Companies.FirstOrDefault(g => g.CompanyName == "Deloitte");
Positions.Add(p9);
PositionMajor pm19 = new PositionMajor();
pm19.Major = db.Majors.FirstOrDefault(g => g.MajorName == "Accounting");
pm19.Position = p9;
p9.PositionMajors.Add(pm19);
PositionMajor pm20 = new PositionMajor();
pm20.Major = db.Majors.FirstOrDefault(g => g.MajorName == "Business Honors");
pm20.Position = p9;
p9.PositionMajors.Add(pm20);
Position p10 = new Position()
{
Title = "Marketing Intern",
PositionType = PositionDuration.I,
Location = "Austin, Texas",
Deadline = new DateTime(2019, 4, 30),
Description = "Help our marketing team develop new advertising strategies for local Austin businesses"
};
p10.Company = db.Companies.FirstOrDefault(g => g.CompanyName == "Adlucent");
Positions.Add(p10);
PositionMajor pm21 = new PositionMajor();
pm21.Major = db.Majors.FirstOrDefault(g => g.MajorName == "Marketing");
pm21.Position = p10;
p10.PositionMajors.Add(pm21);
Position p11 = new Position()
{
Title = "Financial Analyst",
PositionType = PositionDuration.FT,
Location = "Richmond, Virginia",
Deadline = new DateTime(2019, 4, 15),
Description = ""
};
p11.Company = db.Companies.FirstOrDefault(g => g.CompanyName == "Capital One");
Positions.Add(p11);
PositionMajor pm22 = new PositionMajor();
pm22.Major = db.Majors.FirstOrDefault(g => g.MajorName == "Finance");
pm22.Position = p11;
p11.PositionMajors.Add(pm22);
Position p12 = new Position()
{
Title = "Pilot",
PositionType = PositionDuration.FT,
Location = "Ft. Worth, Texas",
Deadline = new DateTime(2019, 10, 8),
Description = ""
};
p12.Company = db.Companies.FirstOrDefault(g => g.CompanyName == "United Airlines");
Positions.Add(p12);
PositionMajor pm23 = new PositionMajor();
pm23.Major = db.Majors.FirstOrDefault(g => g.MajorName == "MIS");
pm23.Position = p12;
p12.PositionMajors.Add(pm23);
PositionMajor pm24 = new PositionMajor();
pm24.Major = db.Majors.FirstOrDefault(g => g.MajorName == "Supply Chain Management");
pm24.Position = p12;
p12.PositionMajors.Add(pm24);
PositionMajor pm25 = new PositionMajor();
pm25.Major = db.Majors.FirstOrDefault(g => g.MajorName == "Accounting");
pm25.Position = p12;
p12.PositionMajors.Add(pm25);
PositionMajor pm26 = new PositionMajor();
pm26.Major = db.Majors.FirstOrDefault(g => g.MajorName == "Marketing");
pm26.Position = p12;
p12.PositionMajors.Add(pm26);
Position p13 = new Position()
{
Title = "Corporate Recruiting Intern",
PositionType = PositionDuration.I,
Location = "Redmond, Washington",
Deadline = new DateTime(2019, 4, 30),
Description = ""
};
p13.Company = db.Companies.FirstOrDefault(g => g.CompanyName == "Microsoft");
Positions.Add(p13);
PositionMajor pm27 = new PositionMajor();
pm27.Major = db.Majors.FirstOrDefault(g => g.MajorName == "Management");
pm27.Position = p13;
p13.PositionMajors.Add(pm27);
Position p14 = new Position()
{
Title = "Business Analyst",
PositionType = PositionDuration.FT,
Location = "Austin, Texas",
Deadline = new DateTime(2019, 5, 31),
Description = ""
};
p14.Company = db.Companies.FirstOrDefault(g => g.CompanyName == "Microsoft");
Positions.Add(p14);
PositionMajor pm28 = new PositionMajor();
pm28.Major = db.Majors.FirstOrDefault(g => g.MajorName == "MIS");
pm28.Position = p14;
p14.PositionMajors.Add(pm28);
Position p15 = new Position()
{
Title = "Programmer Analyst",
PositionType = PositionDuration.FT,
Location = "Minneapolis, Minnesota",
Deadline = new DateTime(2019, 5, 15),
Description = ""
};
p15.Company = db.Companies.FirstOrDefault(g => g.CompanyName == "Target");
Positions.Add(p15);
PositionMajor pm29 = new PositionMajor();
pm29.Major = db.Majors.FirstOrDefault(g => g.MajorName == "MIS");
pm29.Position = p15;
p15.PositionMajors.Add(pm29);
Position p16 = new Position()
{
Title = "Intern",
PositionType = PositionDuration.I,
Location = "Minneapolis, Minnesota",
Deadline = new DateTime(2019, 5, 15),
Description = ""
};
p16.Company = db.Companies.FirstOrDefault(g => g.CompanyName == "Target");
Positions.Add(p16);
PositionMajor pm30 = new PositionMajor();
pm30.Major = db.Majors.FirstOrDefault(g => g.MajorName == "MIS");
pm30.Position = p16;
p16.PositionMajors.Add(pm30);
PositionMajor pm31 = new PositionMajor();
pm31.Major = db.Majors.FirstOrDefault(g => g.MajorName == "International Business");
pm31.Position = p16;
p16.PositionMajors.Add(pm31);
PositionMajor pm32 = new PositionMajor();
pm32.Major = db.Majors.FirstOrDefault(g => g.MajorName == "Finance");
pm32.Position = p16;
p16.PositionMajors.Add(pm32);
PositionMajor pm33 = new PositionMajor();
pm33.Major = db.Majors.FirstOrDefault(g => g.MajorName == "Accounting");
pm33.Position = p16;
p16.PositionMajors.Add(pm33);
PositionMajor pm34 = new PositionMajor();
pm34.Major = db.Majors.FirstOrDefault(g => g.MajorName == "Marketing");
pm34.Position = p16;
p16.PositionMajors.Add(pm34);
PositionMajor pm35 = new PositionMajor();
pm35.Major = db.Majors.FirstOrDefault(g => g.MajorName == "Science and Technology Management");
pm35.Position = p16;
p16.PositionMajors.Add(pm35);
PositionMajor pm36 = new PositionMajor();
pm36.Major = db.Majors.FirstOrDefault(g => g.MajorName == "Business Honors");
pm36.Position = p16;
p16.PositionMajors.Add(pm36);
PositionMajor pm37 = new PositionMajor();
pm37.Major = db.Majors.FirstOrDefault(g => g.MajorName == "Supply Chain Management");
pm37.Position = p16;
p16.PositionMajors.Add(pm37);
PositionMajor pm38 = new PositionMajor();
pm38.Major = db.Majors.FirstOrDefault(g => g.MajorName == "Management");
pm38.Position = p16;
p16.PositionMajors.Add(pm38);
try
{
foreach (Position positionToAdd in Positions)
{
strPositionTitle = positionToAdd.Title;
Position dbPosition = db.Positions.FirstOrDefault(b => b.Title == positionToAdd.Title);
if (dbPosition == null) //this title doesn't exist
{
db.Positions.Add(positionToAdd);
db.SaveChanges();
intPositionsAdded += 1;
}
else //position exists - update values
{
dbPosition.Title = positionToAdd.Title;
dbPosition.PositionType = positionToAdd.PositionType;
dbPosition.Location = positionToAdd.Location;
dbPosition.Deadline = positionToAdd.Deadline;
dbPosition.Description = positionToAdd.Description;
dbPosition.Company = positionToAdd.Company;
db.Update(dbPosition);
db.SaveChanges();
intPositionsAdded += 1;
}
}
}
catch (Exception ex)
{
String msg = " Repositories added:" + intPositionsAdded + "; Error on " + strPositionTitle;
throw new InvalidOperationException(ex.Message + msg);
}
}
catch (Exception e)
{
throw new InvalidOperationException(e.Message);
}
}
public async Task <IActionResult> Edit(int id, [Bind("PositionID,Title,PositionType,Location,Deadline,Description")] Position position, int SelectedCompany, int[] SelectedMajors)
{
//find company
//Company pos_company = _context.Companies.Find(SelectedCompany);
//position.Company = pos_company;
if (ModelState.IsValid)
{
Company pos_company = _context.Companies.Find(SelectedCompany);
position.Company = pos_company;
//add navigational data
Position dbPosition = _context.Positions.Include(cd => cd.PositionMajors).ThenInclude(cd => cd.Major).FirstOrDefault(c => c.PositionID == position.PositionID);
//list of majors to remove
List <PositionMajor> MajorsToRemove = new List <PositionMajor>();
//find majors that should no longer be there
foreach (PositionMajor pm in dbPosition.PositionMajors)
{
if (SelectedMajors.Contains(pm.Major.MajorID) == false)
{
MajorsToRemove.Add(pm);
}
}
//remove majors from above list
foreach (PositionMajor pm in MajorsToRemove)
{
_context.PositionMajors.Remove(pm);
_context.SaveChanges();
}
//add majors not already there
foreach (int i in SelectedMajors)
{
if (dbPosition.PositionMajors.Any(d => d.Major.MajorID == i) == false)
{
PositionMajor pm = new PositionMajor();
pm.Major = _context.Majors.Find(i);
pm.Position = dbPosition;
//add new instance to database
_context.PositionMajors.Add(pm);
_context.SaveChanges();
}
}
//update scalar properties
dbPosition.Title = position.Title;
dbPosition.PositionType = position.PositionType;
dbPosition.Location = position.Location;
dbPosition.Deadline = position.Deadline;
dbPosition.Description = position.Description;
dbPosition.Company = position.Company;
//add new instance to database
_context.Positions.Update(dbPosition);
_context.SaveChanges();
return(RedirectToAction(nameof(Index)));
}
ViewBag.YourCompanies = new SelectList(Enum.GetValues(typeof(PositionDuration)));
ViewBag.AllMajors = GetMultiMajors(position.PositionID);
ViewBag.AllCompanies = GetAllCompanies();
return(View(position));
}
