public ActionResult Create(EducationDirectorate educationDirectorate)
        {
            if (ModelState.IsValid)
            {
                var data = db.EducationDirectorates.Where(a => a.Is_Deleted != true && a.DirectorateName == educationDirectorate.DirectorateName).SingleOrDefault();

                if (data != null)
                {
                    ViewBag.StateId = new SelectList(db.States.Where(a => a.state_isDeleted != true), "state_id", "state_name");
                    if (Session["lang"] != null)
                    {
                        if (Session["lang"].ToString().Equals("ar-EG"))
                        {
                            ViewBag.StateId = new SelectList(db.States.Where(a => a.state_isDeleted != true), "state_id", "state_arabic_name");
                        }
                    }
                    return(View(educationDirectorate));
                }


                db.EducationDirectorates.Add(educationDirectorate);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }
            ViewBag.StateId = new SelectList(db.States.Where(a => a.state_isDeleted != true), "state_id", "state_name");
            if (Session["lang"] != null)
            {
                if (Session["lang"].ToString().Equals("ar-EG"))
                {
                    ViewBag.StateId = new SelectList(db.States.Where(a => a.state_isDeleted != true), "state_id", "state_arabic_name");
                }
            }

            return(View(educationDirectorate));
        }
        public ActionResult DeleteConfirmed(int id)
        {
            EducationDirectorate educationDirectorate = db.EducationDirectorates.Find(id);

            db.EducationDirectorates.Remove(educationDirectorate);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
        // GET: EducationDirectorates/Delete/5
        public ActionResult Delete(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            EducationDirectorate educationDirectorate = db.EducationDirectorates.Find(id);

            if (educationDirectorate == null)
            {
                return(HttpNotFound());
            }
            return(View(educationDirectorate));
        }
        // GET: EducationDirectorates/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            EducationDirectorate educationDirectorate = db.EducationDirectorates.Find(id);

            if (educationDirectorate == null)
            {
                return(HttpNotFound());
            }
            ViewBag.StateId = new SelectList(db.States.Where(a => a.state_isDeleted != true), "state_id", "state_name");
            if (Session["lang"] != null)
            {
                if (Session["lang"].ToString().Equals("ar-EG"))
                {
                    ViewBag.StateId = new SelectList(db.States.Where(a => a.state_isDeleted != true), "state_id", "state_arabic_name");
                }
            }
            return(View(educationDirectorate));
        }
        public ActionResult Edit(EducationDirectorate educationDirectorate)
        {
            if (ModelState.IsValid)
            {
                var data = db.EducationDirectorates.Where(a => a.Is_Deleted != true && a.Id != educationDirectorate.Id);
                foreach (var item in data)
                {
                    if (item.DirectorateName == educationDirectorate.DirectorateName)
                    {
                        ViewBag.StateId = new SelectList(db.States.Where(a => a.state_isDeleted != true), "state_id", "state_name");
                        if (Session["lang"] != null)
                        {
                            if (Session["lang"].ToString().Equals("ar-EG"))
                            {
                                ViewBag.StateId = new SelectList(db.States.Where(a => a.state_isDeleted != true), "state_id", "state_arabic_name");
                            }
                        }
                        return(View(educationDirectorate));
                    }
                }


                var old = db.EducationDirectorates.Find(educationDirectorate.Id);
                old.DirectorateName       = educationDirectorate.DirectorateName;
                old.DirectorateNameArabic = educationDirectorate.DirectorateNameArabic;
                old.StateId = educationDirectorate.StateId;
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }
            ViewBag.StateId = new SelectList(db.States.Where(a => a.state_isDeleted != true), "state_id", "state_name");
            if (Session["lang"] != null)
            {
                if (Session["lang"].ToString().Equals("ar-EG"))
                {
                    ViewBag.StateId = new SelectList(db.States.Where(a => a.state_isDeleted != true), "state_id", "state_arabic_name");
                }
            }
            return(View(educationDirectorate));
        }