public ActionResult Edit([Bind(Include = "Staff_ID,Skill_ID,Proficiency_ID,Created_On,Created_By,Modified_On,Modified_By")] Staff_Skill staff_Skill)
{
if (ModelState.IsValid)
{
db.Entry(staff_Skill).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Proficiency_ID = new SelectList(db.Adm_Proficiencies, "Proficiency_ID", "Proficiency", staff_Skill.Proficiency_ID);
ViewBag.Skill_ID = new SelectList(db.Ref_Skills, "ID", "Skill", staff_Skill.Skill_ID);
ViewBag.Staff_ID = new SelectList(db.Staffs, "ID", "Staff_Name", staff_Skill.Staff_ID);
return(View(staff_Skill));
}
public ActionResult Edit([Bind(Include = "ID,Status")] Adm_Resume_Status adm_Resume_Status)
{
if (ModelState.IsValid)
{
db.Entry(adm_Resume_Status).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(adm_Resume_Status));
}
public ActionResult Edit([Bind(Include = "ID,Telework_Agreement")] Ref_Telework_Agreement ref_Telework_Agreement)
{
if (ModelState.IsValid)
{
db.Entry(ref_Telework_Agreement).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ref_Telework_Agreement));
}
public ActionResult Edit([Bind(Include = "ID,Vehicle_Name")] Adm_Contract_Vehicle adm_Contract_Vehicle)
{
if (ModelState.IsValid)
{
db.Entry(adm_Contract_Vehicle).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(adm_Contract_Vehicle));
}
public ActionResult Edit([Bind(Include = "ID,Period__,Year,Month,Start,End")] Ref_Pay_Period ref_Pay_Period)
{
if (ModelState.IsValid)
{
db.Entry(ref_Pay_Period).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ref_Pay_Period));
}
public ActionResult Edit([Bind(Include = "ID,Asset_Type")] Adm_Asset_Type adm_Asset_Type)
{
if (ModelState.IsValid)
{
db.Entry(adm_Asset_Type).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(adm_Asset_Type));
}
public ActionResult Edit([Bind(Include = "Proficiency_ID,Proficiency")] Adm_Proficiency adm_Proficiency)
{
if (ModelState.IsValid)
{
db.Entry(adm_Proficiency).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(adm_Proficiency));
}
public ActionResult Edit([Bind(Include = "ID,Role")] Ref_Role ref_Role)
{
if (ModelState.IsValid)
{
db.Entry(ref_Role).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ref_Role));
}
public ActionResult Edit([Bind(Include = "ID,Security_Clearance,Security_Clearance_Abbreviation")] Adm_Security_Clearance adm_Security_Clearance)
{
if (ModelState.IsValid)
{
db.Entry(adm_Security_Clearance).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(adm_Security_Clearance));
}
public ActionResult Edit([Bind(Include = "ID,Contract_ID,Area,Level_1,Level_2,Level_3,Level_4,Level_5,Created_On,Created_By,Modified_On,Modified_By")] Contract_WB contract_WB)
{
if (ModelState.IsValid)
{
db.Entry(contract_WB).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(contract_WB));
}
public ActionResult Edit([Bind(Include = "ID,Asset_Name,Asset_Type_ID")] Ref_Asset ref_Asset)
{
if (ModelState.IsValid)
{
db.Entry(ref_Asset).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Asset_Type_ID = new SelectList(db.Adm_Asset_Types, "ID", "Asset_Type", ref_Asset.Asset_Type_ID);
return(View(ref_Asset));
}
public ActionResult Edit([Bind(Include = "ID,Customer,Agency_ID")] Ref_Customer ref_Customer)
{
if (ModelState.IsValid)
{
db.Entry(ref_Customer).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Agency_ID = new SelectList(db.Adm_Agencies, "ID", "Agency", ref_Customer.Agency_ID);
return(View(ref_Customer));
}
public ActionResult Edit([Bind(Include = "ID,Staff_ID,Certification1,Issuing_Agency,Certification_ID,Date_Issued,Expiration_Date,Created_On,Created_By,Modified_On,Modified_By")] Certification certification)
{
if (ModelState.IsValid)
{
db.Entry(certification).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Staff_ID = new SelectList(db.Staffs, "ID", "Staff_Name", certification.Staff_ID);
return(View(certification));
}
public ActionResult Edit([Bind(Include = "ID,Contract_ID,Training,Date_Due,Instructions")] Ref_Training ref_Training)
{
if (ModelState.IsValid)
{
db.Entry(ref_Training).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Contract_ID = new SelectList(db.Contracts, "ID", "Created_By", ref_Training.Contract_ID);
return(View(ref_Training));
}
public ActionResult Edit([Bind(Include = "ID,Contract_Vehicle_ID,LCAT,LCAT_Description,Years_of_Experience_with_Degree,Degree_ID")] Ref_Contract_Vehicle_LCAT ref_Contract_Vehicle_LCAT)
{
if (ModelState.IsValid)
{
db.Entry(ref_Contract_Vehicle_LCAT).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Contract_Vehicle_ID = new SelectList(db.Adm_Contract_Vehicles, "ID", "Vehicle_Name", ref_Contract_Vehicle_LCAT.Contract_Vehicle_ID);
ViewBag.Degree_ID = new SelectList(db.Adm_Degrees, "ID", "Degree", ref_Contract_Vehicle_LCAT.Degree_ID);
return(View(ref_Contract_Vehicle_LCAT));
}
public ActionResult Edit([Bind(Include = "ID,Exit_Reason")] Adm_Exit_Reason adm_Exit_Reason)
{
System.Diagnostics.Debug.WriteLine("Sent exit reason is: " + adm_Exit_Reason.Exit_Reason);
if (ModelState.IsValid)
{
db.Entry(adm_Exit_Reason).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(adm_Exit_Reason));
}
public ActionResult Edit([Bind(Include = "ID,Contract_ID,Vehicle_LCAT_ID,ESF_LCAT,Description,Years_of_Experience_with_Degree")] Ref_Contract_LCAT ref_Contract_LCAT)
{
if (ModelState.IsValid)
{
db.Entry(ref_Contract_LCAT).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Contract_ID = new SelectList(db.Contracts, "ID", "Created_By", ref_Contract_LCAT.Contract_ID);
ViewBag.Vehicle_LCAT_ID = new SelectList(db.Ref_Contract_Vehicle_LCATs, "ID", "LCAT", ref_Contract_LCAT.Vehicle_LCAT_ID);
return(View(ref_Contract_LCAT));
}
public ActionResult Edit([Bind(Include = "ID,Contract_Position_ID,Pay_Period_ID,FTE,Hours,Created_On,Created_By,Modified_On,Modified_By")] Position_Forecast position_Forecast)
{
if (ModelState.IsValid)
{
db.Entry(position_Forecast).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DateTime = DateTime.Now;
ViewBag.Contract_Position_ID = new SelectList(db.Contract_Positions, "ID", "Contract_WBS_ID", position_Forecast.Contract_Position_ID);
ViewBag.Pay_Period_ID = new SelectList(db.Ref_Pay_Periods, "ID", "ID", position_Forecast.Pay_Period_ID);
return(View(position_Forecast));
}
public ActionResult Edit([Bind(Include = "ID,Staff_Clearance_ID,Security_Workflow_ID,Is_Active,Entry_Date,Exit_Date,Created_On,Created_By,Modified_On,Modified_By")] Staff_Clearance_Workflow staff_Clearance_Workflow)
{
if (ModelState.IsValid)
{
db.Entry(staff_Clearance_Workflow).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DateTime = DateTime.Now;
ViewBag.Security_Workflow_ID = new SelectList(db.Security_Workflows, "ID", "Workflow", staff_Clearance_Workflow.Security_Workflow_ID);
ViewBag.Staff_Clearance_ID = new SelectList(db.Staff_Clearances, "ID", "Created_By", staff_Clearance_Workflow.Staff_Clearance_ID);
return(View(staff_Clearance_Workflow));
}
public ActionResult Edit([Bind(Include = "ID,Staff_ID,Training_ID,Date_Completed,Created_On,Created_By,Modified_On,Modified_By")] Staff_Training staff_Training)
{
if (ModelState.IsValid)
{
db.Entry(staff_Training).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DateTime = DateTime.Now;
ViewBag.Training_ID = new SelectList(db.Ref_Trainings, "ID", "Training", staff_Training.Training_ID);
ViewBag.Staff_ID = new SelectList(db.Staffs, "ID", "Staff_Name", staff_Training.Staff_ID);
return(View(staff_Training));
}
public ActionResult Edit([Bind(Include = "ID,Contract_Position_ID,Company_ID,Date_Released,IsPrimary,Created_On,Created_By,Modified_On,Modified_By")] Workshare workshare)
{
if (ModelState.IsValid)
{
db.Entry(workshare).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DateTime = DateTime.Now;
ViewBag.Contract_Position_ID = new SelectList(db.Contract_Positions, "ID", "Contract_WBS_ID", workshare.Contract_Position_ID);
ViewBag.Company_ID = new SelectList(db.Ref_Companies, "ID", "Company", workshare.Company_ID);
return(View(workshare));
}
public ActionResult Edit([Bind(Include = "ID,Customer_ID,POP_Start,POP_End,Program_Manager_ID,IsPrime,FillByDuration,Created_On,Created_By,Modified_On,Modified_By,Title")] Contract contract)
{
if (ModelState.IsValid)
{
db.Entry(contract).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DateTime = DateTime.Now;
ViewBag.Customer_ID = new SelectList(db.Ref_Customers, "ID", "Customer", contract.Customer_ID);
ViewBag.Program_Manager_ID = new SelectList(db.Staffs, "ID", "Staff_Name", contract.Program_Manager_ID);
return(View(contract));
}
public ActionResult Edit([Bind(Include = "ID,Contract_ID,Display_Order,Workflow,Always_Display,Clearance_Status_ID,Created_On,Created_By,Modified_On,Modified_By")] Security_Workflow security_Workflow)
{
if (ModelState.IsValid)
{
db.Entry(security_Workflow).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DateTime = DateTime.Now;
ViewBag.Clearance_Status_ID = new SelectList(db.Adm_Clearance_Status, "ID", "Clearance_Status", security_Workflow.Clearance_Status_ID);
ViewBag.Contract_ID = new SelectList(db.Contracts, "ID", "Title", security_Workflow.Contract_ID);
return(View(security_Workflow));
}
public ActionResult Edit([Bind(Include = "ID,Staff_ID,Contract_ID,Asset_ID,Item_Number,Date_Issued,Date_Returrned,Notes,Created_On,Created_By,Modified_On,Modified_By")] Staff_Asset staff_Asset)
{
if (ModelState.IsValid)
{
db.Entry(staff_Asset).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DateTime = DateTime.Now;
ViewBag.Contract_ID = new SelectList(db.Contracts, "ID", "Title", staff_Asset.Contract_ID);
ViewBag.Asset_ID = new SelectList(db.Ref_Assets, "ID", "Asset_Name", staff_Asset.Asset_ID);
ViewBag.Staff_ID = new SelectList(db.Staffs, "ID", "Staff_Name", staff_Asset.Staff_ID);
return(View(staff_Asset));
}
public ActionResult Edit([Bind(Include = "Staff_ID,Contract_Position_ID,IsActive,Planned_Start_Date,Active_Start_Date,Active_End_Date,Telework_Agreement_ID,Resume_Status_ID,Is_Resume_Compliant,Is_LCAT_Compliant,Compliance_Notes,Email_Address,Desk_Phone,Cell_Phone,Created_On,Created_By,Modified_On,Modified_By")] Staff_Position staff_Position)
{
if (ModelState.IsValid)
{
db.Entry(staff_Position).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DateTime = DateTime.Now;
ViewBag.Resume_Status_ID = new SelectList(db.Adm_Resume_Status, "ID", "Status", staff_Position.Resume_Status_ID);
ViewBag.Contract_Position_ID = new SelectList(db.Contract_Positions, "ID", "Contract_WBS_ID", staff_Position.Contract_Position_ID);
ViewBag.Telework_Agreement_ID = new SelectList(db.Ref_Telework_Agreements, "ID", "Telework_Agreement", staff_Position.Telework_Agreement_ID);
ViewBag.Staff_ID = new SelectList(db.Staffs, "ID", "Staff_Name", staff_Position.Staff_ID);
return(View(staff_Position));
}
public ActionResult Edit([Bind(Include = "ID,Person_Key,Company_ID,Staff_Name,Prefix,Last_Name,First_Name,Middle_Initial,Suffix,Alias,Location,Cell_Phone,Personal_Cell_Phone,Desk_Phone,Company_Email,IsForeign_National,IsBillable,Years_of_Experience,Hire_Date,Exit_Date,Exit_Note,Exit_Reason_ID,Is_Eligible_for_Rehire,Created_On,Created_By,Modified_On,Modified_By")] Staff staff)
{
if (ModelState.IsValid)
{
db.Entry(staff).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Exit_Reason_ID = new SelectList(db.Adm_Exit_Reasons, "ID", "Exit_Reason", staff.Exit_Reason_ID);
ViewBag.Prefix = new SelectList(db.Adm_Prefixes, "Prefix", "Prefix", staff.Prefix);
ViewBag.Suffix = new SelectList(db.Adm_Suffixes, "Suffix", "Suffix", staff.Suffix);
ViewBag.Company_ID = new SelectList(db.Ref_Companies, "ID", "Company", staff.Company_ID);
ViewBag.ID = new SelectList(db.Staff_Clearances, "ID", "Created_By", staff.ID);
return(View(staff));
}
public ActionResult Edit([Bind(Include = "ID,Staff_ID,Security_Clearance_ID,Date_Authorized,Contract_ID,Created_On,Created_By,Modified_On,Modified_By")] Staff_Clearance staff_Clearance)
{
if (ModelState.IsValid)
{
db.Entry(staff_Clearance).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DateTime = DateTime.Now;
ViewBag.Staff_ID = new SelectList(db.Staffs, "ID", "Staff_Name", staff_Clearance.Staff_ID);
ViewBag.Security_Clearance_ID = new SelectList(db.Adm_Security_Clearances, "ID", "Security_Clearance", staff_Clearance.Security_Clearance_ID);
ViewBag.Contract_ID = new SelectList(db.Contracts, "ID", "Title", staff_Clearance.Contract_ID);
ViewBag.ID = new SelectList(db.Staffs, "ID", "Staff_Name", staff_Clearance.ID);
return(View(staff_Clearance));
}
public ActionResult Edit([Bind(Include = "ID,Contract_ID,Role_ID,Contract_WBS_ID,Position__,Info_Risk_ID,LCAT_ID,DateNeeded,Requisition_Status_ID,Required_Security_Clearance_ID,Created_On,Created_By,Modified_On,Modified_By")] Contract_Position contract_Position)
{
if (ModelState.IsValid)
{
db.Entry(contract_Position).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DateTime = DateTime.Now;
ViewBag.Info_Risk_ID = new SelectList(db.Adm_Info_Risks, "ID", "Info_Risk", contract_Position.Info_Risk_ID);
ViewBag.Requisition_Status_ID = new SelectList(db.Adm_Requisition_Status, "ID", "Status", contract_Position.Requisition_Status_ID);
ViewBag.Required_Security_Clearance_ID = new SelectList(db.Adm_Security_Clearances, "ID", "Security_Clearance", contract_Position.Required_Security_Clearance_ID);
ViewBag.Contract_ID = new SelectList(db.Contracts, "ID", "Title", contract_Position.Contract_ID);
ViewBag.Contract_WBS_ID = new SelectList(db.Contract_WBS, "ID", "Area", contract_Position.Contract_WBS_ID);
//ViewBag.Contract_ID = new SelectList(db.Contract_WBS, "ID", "Area", contract_Position.Contract_ID);
ViewBag.LCAT_ID = new SelectList(db.Ref_Contract_LCATs, "ID", "ESF_LCAT", contract_Position.LCAT_ID);
ViewBag.Role_ID = new SelectList(db.Ref_Roles, "ID", "Role", contract_Position.Role_ID);
return(View(contract_Position));
}
public ActionResult ManageStaffEducationsModal(StaffDashboardViewModel model)
{
string currentUserName = getCurrentUserFullName();
DateTime currentTime = System.DateTime.Now;
DateTime nullDateTimeValue = new DateTime(0001, 1, 1, 12, 0, 0);
if (ModelState.IsValid)
{
//create copy of data while we enumerate through the model
List <ManageStaffEducationsViewModel> postIteratorCopy = model.ManageEducationsDataList;
foreach (var editedEducation in model.ManageEducationsDataList)
{
//User wants to delete education
if (editedEducation.RemoveEducation == true)
{
if (editedEducation.HasEducation == true)
{
Education educationToFind = new Education();
educationToFind = db.Educations.Where(x => x.ID == editedEducation.EducationID).SingleOrDefault();
db.Educations.Attach(educationToFind);
db.Educations.Remove(educationToFind);
}
else if (editedEducation.IsNewSkill == true)
{
postIteratorCopy.Remove(editedEducation);
}
}
//Check if user edited education
else if (editedEducation.HasEducation == true && editedEducation.RemoveEducation == false)
{
Education educationFoundFromDb = new Education();
educationFoundFromDb = db.Educations.Where(x => x.ID == editedEducation.EducationID).SingleOrDefault();
//User modified a field in their existing Educations
if (editedEducation.DegreeID != educationFoundFromDb.Degree_ID ||
editedEducation.School != educationFoundFromDb.School ||
editedEducation.CompletedDate != educationFoundFromDb.Completed_Date)
{
educationFoundFromDb.Degree_ID = editedEducation.DegreeID;
educationFoundFromDb.School = editedEducation.School;
educationFoundFromDb.Completed_Date = editedEducation.CompletedDate;
educationFoundFromDb.Staff_ID = editedEducation.StaffID;
educationFoundFromDb.Modified_By = currentUserName;
educationFoundFromDb.Modified_On = currentTime;
db.Educations.Attach(educationFoundFromDb);
var entry = db.Entry(educationFoundFromDb);
entry.State = EntityState.Modified;
}
}
else if (editedEducation.HasEducation == false)
{
//User added new Education
Education newEducation = new Education();
newEducation.Staff_ID = editedEducation.StaffID;
newEducation.Degree_ID = editedEducation.DegreeID;
newEducation.School = editedEducation.School;
newEducation.Completed_Date = editedEducation.CompletedDate;
newEducation.Created_By = currentUserName;
newEducation.Created_On = currentTime;
newEducation.Modified_By = currentUserName;
newEducation.Modified_On = currentTime;
db.Educations.Add(newEducation);
}
}
}
else
{
List <string> modelStateErrors = new List <string>();
foreach (ModelState modelState in ViewData.ModelState.Values)
{
foreach (ModelError error in modelState.Errors)
{
modelStateErrors.Add(error.ErrorMessage);
}
}
}
db.SaveChanges();
return(RedirectToAction("Index", "Staff"));
}
