public ActionResult EditAssistantCompany(int?id)
        {
            if (id == null)
            {
                //return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
                return(RedirectToAction("Index", "Home"));
            }
            Assistant assistant = db.Assistants.Find(id);

            if (assistant == null)
            {
                return(HttpNotFound());
            }
            AssistantCompanyEditVM assistantEditVM = new AssistantCompanyEditVM
            {
                FirstName               = assistant.FirstName,
                LastName                = assistant.LastName,
                AssistantSSN            = assistant.AssistantSSN,
                PhoneNumber             = assistant.PhoneNumber,
                Email                   = assistant.Email,
                HourlySalary            = assistant.HourlySalary,
                HolidayPayRate          = assistant.HolidayPayRate,
                PayrollTaxRate          = assistant.PayrollTaxRate,
                PensionAndInsuranceRate = assistant.PensionAndInsuranceRate,
                Id        = (int)id,
                CompanyId = assistant.CareCompanyId
            };

            CareCompany company = db.CareCompanies.Find(assistant.CareCompanyId);

            if (company != null)
            {
                assistantEditVM.CompanyId   = assistant.CareCompanyId;
                assistantEditVM.CompanyName = company.CompanyName;
            }


            return(View(assistantEditVM));
        }
        public ActionResult EditAssistantCompany([Bind(Include = "Id,CompanyId,FirstName,LastName,AssistantSSN,Email,PhoneNumber,HourlySalary,HolidayPayRate,PayrollTaxRate,PensionAndInsuranceRate")] AssistantCompanyEditVM assistantEditVM)
        {
            bool errorFound = false;

            //Check that the SSN has the correct format
            if (!string.IsNullOrWhiteSpace(assistantEditVM.AssistantSSN))
            {
                assistantEditVM.AssistantSSN = assistantEditVM.AssistantSSN.Trim();
                Regex regex = new Regex(@"^([1-9][0-9]{3})(((0[13578]|1[02])(0[1-9]|[12][0-9]|3[01]))|((0[469]|11)(0[1-9]|[12][0-9]|30))|(02(0[1-9]|[12][0-9])))[-]?\d{4}$");
                Match match = regex.Match(assistantEditVM.AssistantSSN);
                if (!match.Success)
                {
                    ModelState.AddModelError("AssistantSSN", "Ej giltigt personnummer. Formaten YYYYMMDD-NNNN och YYYYMMDDNNNN är giltiga.");
                    errorFound = true;
                }
            }
            else
            {
                errorFound = true;
            }

            //Check that the assistant is born in the 20th or 21st century
            if (!errorFound)
            {
                if (int.Parse(assistantEditVM.AssistantSSN.Substring(0, 2)) != 19 && int.Parse(assistantEditVM.AssistantSSN.Substring(0, 2)) != 20)
                {
                    ModelState.AddModelError("AssistantSSN", "Assistenten måste vara född på 1900- eller 2000-talet.");
                    errorFound = true;
                }
            }

            //Check that the assistant is at least 18 years old and was not born in the future:-)
            if (!errorFound)
            {
                DateTime assistantBirthday = new DateTime(int.Parse(assistantEditVM.AssistantSSN.Substring(0, 4)), int.Parse(assistantEditVM.AssistantSSN.Substring(4, 2)), int.Parse(assistantEditVM.AssistantSSN.Substring(6, 2)));
                if (assistantBirthday.Date > DateTime.Now.Date)
                {
                    ModelState.AddModelError("AssistantSSN", "Födelsedatumet får inte vara senare än idag.");
                    errorFound = true;
                }
                else if (assistantBirthday > DateTime.Now.AddYears(-18))
                {
                    ModelState.AddModelError("AssistantSSN", "Assistenten måste vara minst 18 år.");
                    errorFound = true;
                }
            }

            //Check if there is an assistant with the same SSN already in the company. The same assistant is allowed in another company.
            if (!errorFound)
            {
                var twinAssistant = db.Assistants.Where(a => (a.AssistantSSN == assistantEditVM.AssistantSSN) && (a.CareCompanyId == assistantEditVM.CompanyId)).Where(a => a.Id != assistantEditVM.Id).FirstOrDefault();
                if (twinAssistant != null)
                {
                    ModelState.AddModelError("AssistantSSN", "Det finns redan en assistent med detta personnummer");
                    errorFound = true;
                }
            }

            if (!errorFound)
            {
                if (assistantEditVM.AssistantSSN.Length == 12)
                {
                    assistantEditVM.AssistantSSN = assistantEditVM.AssistantSSN.Insert(8, "-");
                }
            }

            if (ModelState.IsValid)
            {
                var assistant = db.Assistants.Where(a => a.Id == assistantEditVM.Id).FirstOrDefault();
                if (assistant != null)
                {
                    assistant.FirstName               = assistantEditVM.FirstName;
                    assistant.LastName                = assistantEditVM.LastName;
                    assistant.AssistantSSN            = assistantEditVM.AssistantSSN;
                    assistant.PhoneNumber             = assistantEditVM.PhoneNumber;
                    assistant.Email                   = assistantEditVM.Email;
                    assistant.HourlySalary            = assistantEditVM.HourlySalary;
                    assistant.HolidayPayRate          = assistantEditVM.HolidayPayRate;
                    assistant.PayrollTaxRate          = assistantEditVM.PayrollTaxRate;
                    assistant.PensionAndInsuranceRate = assistantEditVM.PensionAndInsuranceRate;
                    assistant.CareCompanyId           = assistantEditVM.CompanyId;
                    db.Entry(assistant).State         = EntityState.Modified;
                    db.SaveChanges();
                    return(RedirectToAction("IndexAllCompanies"));
                }
            }
            return(View(assistantEditVM));
        }