public ActionResult Create(Live_Status live_Status)
        {
            ViewBag.live_satus_type_id = new SelectList(db.Live_Status_Type.Where(a => a.live_status_type_isDeleted != true), "live_status_type_id", "live_status_type_name");
            ViewBag.citizen_citizen_id = new SelectList(db.Citizens.Where(a => a.citizen_isDeleted != true), "citizen_id", "citizen_national_id");
            var data = db.Live_Status.Where(a => a.citizen_citizen_id == live_Status.citizen_citizen_id && a.live_satus_isDeleted != true).SingleOrDefault();

            if (Session["lang"] != null)
            {
                if (Session["lang"].ToString().Equals("ar-EG"))
                {
                    ViewBag.live_satus_type_id = new SelectList(db.Live_Status_Type.Where(a => a.live_status_type_isDeleted != true), "live_status_type_id", "live_status_type_name_arabic");
                }
            }
            if (data != null)
            {
                ViewBag.id           = data.live_satus_id;
                ViewBag.edit         = "Edit Page";
                ViewBag.errMsgStatus = Servicely.Languages.Language.already_exist_go_to_edit_page_to_make_changes;
                return(View(live_Status));
            }

            db.Live_Status.Add(live_Status);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
        // GET: Live_Status/Edit/5
        public ActionResult Edit(int id)
        {
            Live_Status live_Status = db.Live_Status.Find(id);

            ViewBag.live_satus_type_id = new SelectList(db.Live_Status_Type, "live_status_type_id", "live_status_type_name", live_Status.live_satus_type_id);
            ViewBag.citizen_citizen_id = new SelectList(db.Citizens, "citizen_id", "citizen_national_id", live_Status.citizen_citizen_id);

            if (Session["lang"] != null)
            {
                if (Session["lang"].ToString().Equals("ar-EG"))
                {
                    ViewBag.live_satus_type_id = new SelectList(db.Live_Status_Type, "live_status_type_id", "live_status_type_name_arabic", live_Status.live_satus_type_id);
                }
            }

            return(View(live_Status));
        }
        public ActionResult Edit(Live_Status live_Status)
        {
            ViewBag.live_satus_type_id = new SelectList(db.Live_Status_Type.Where(a => a.live_status_type_isDeleted != true), "live_status_type_id", "live_status_type_name");
            ViewBag.citizen_citizen_id = new SelectList(db.Citizens.Where(a => a.citizen_isDeleted != true), "citizen_id", "citizen_national_id");
            var data = db.Live_Status.Where(a => a.citizen_citizen_id == live_Status.citizen_citizen_id && a.live_satus_isDeleted != true).SingleOrDefault();


            if (Session["lang"] != null)
            {
                if (Session["lang"].ToString().Equals("ar-EG"))
                {
                    ViewBag.live_satus_type_id = new SelectList(db.Live_Status_Type.Where(a => a.live_status_type_isDeleted != true), "live_status_type_id", "live_status_type_name_arabic");
                }
            }
            if (data != null)
            {
                if (data.live_satus_type_id == live_Status.live_satus_type_id)
                {
                    ViewBag.errMsgStatus = Languages.Language.already + data.Live_Status_Type.live_status_type_name;
                    return(View(live_Status));
                }
                else
                {
                    data.live_satus_type_id = live_Status.live_satus_type_id;
                    db.SaveChanges();
                    return(RedirectToAction("Index"));
                }
            }



            var old = db.Live_Status.Find(live_Status.live_satus_id);

            old.live_satus_type_id = live_Status.live_satus_type_id;
            old.citizen_citizen_id = live_Status.citizen_citizen_id;
            // db.Entry(live_Status).State = EntityState.Modified;
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
        public ActionResult ConfirmIndex()
        {
            string www      = Session["Nai"].ToString();
            var    validate = db.Citizens.Where(a => a.citizen_national_id == www).SingleOrDefault();

            if (validate != null)
            {
                Session["success"] = Languages.Language.CitizenAlreadExist;
                return(RedirectToAction("Index", "home"));
            }



            Citizen c = new Citizen();

            //-----------------citizen infooo----------------------------
            if (Session["second"] != null)
            {
                c.citizen_second_name = Session["second"].ToString();
            }
            //third
            if (Session["third"] != null)
            {
                c.citizen_third_name = Session["third"].ToString();
            }
            //fourth
            if (Session["fourth"] != null)
            {
                c.citizen_fourth_name = Session["fourth"].ToString();
            }

            if (Session["secondArabic"] != null)
            {
                c.citizen_second_name_arabic = Session["secondArabic"].ToString();
            }


            if (Session["thirdArabic"] != null)
            {
                c.citizen_third_name_arabic = Session["thirdArabic"].ToString();
            }

            if (Session["fourthArabic"] != null)
            {
                c.citizen_fourth_name_arabic = Session["fourthArabic"].ToString();
            }


            if (Session["FirstName"] != null)
            {
                c.citizen_first_name = Session["FirstName"].ToString();
            }

            if (Session["FirstNameArabic"] != null)
            {
                c.citizen_first_name_arabic = Session["FirstNameArabic"].ToString();
            }

            if (Session["FId"] != null)
            {
                c.citizen_father_id = Convert.ToInt32(Session["FId"]);
            }

            if (Session["MId"] != null)
            {
                c.citizen_mother_id = Convert.ToInt32(Session["MId"]);
            }



            c.citizen_birthDate = Convert.ToDateTime(Session["BirthDate"]);


            c.citizen_relegion = Session["relegion"].ToString();
            if (Session["gender"] != null)

            {
                if (Session["gender"].ToString().Equals("Male") || Session["gender"].ToString().Equals("ذكر"))

                {
                    Session["gender"] = "Male";
                }
                else if (Session["gender"].ToString().Equals("Female") || Session["gender"].ToString().Equals("انثى"))

                {
                    Session["gender"] = "Female";
                }
            }


            if (Session["relegion"] != null)
            {
                if (Session["relegion"].ToString() == "Muslim" || Session["relegion"].ToString() == "مسلم")
                {
                    Session["relegion"] = "Muslim";
                }
                else if (Session["relegion"].ToString() == "Cristian" || Session["relegion"].ToString() == "مسيحي")
                {
                    Session["relegion"] = "Cristian";
                }
                else if (Session["relegion"].ToString() == "Jewish" || Session["relegion"].ToString() == "يهودي")
                {
                    Session["relegion"] = "Jewish";
                }
            }

            c.citizen_relegion          = Session["relegion"].ToString();
            c.citizen_gender            = Session["gender"].ToString();
            c.citizen_birthPlace        = Session["BirthPlace"].ToString();
            c.citizen_birthPlace_arabic = Session["BirthPlaceArabic"].ToString();
            c.citizen_national_id       = Session["Nai"].ToString();

            db.Citizens.Add(c);
            db.SaveChanges();
            //----------------------Addresses------------------------------
            string  aa = Session["asas"].ToString();
            Address ad = new Address();

            if (aa == "WithF")
            {
                ad.address_district_id   = Convert.ToInt32(Session["AddressDistrictIdFF"]);
                ad.address_isBirthPlace  = Convert.ToBoolean(Session["AddressIsBirthPlaceFF"]);
                ad.address_isCurrent     = Convert.ToBoolean(Session["AddressIsCurrentFF"]);
                ad.address_street        = Session["AddresStreetFF"].ToString();
                ad.address_street_arabic = Session["AddresStreetFFArabic"].ToString();
                db.Addresses.Add(ad);
                db.SaveChanges();
            }
            if (aa == "WithM")
            {
                ad.address_district_id   = Convert.ToInt32(Session["AddressDistrictIdMM"]);
                ad.address_isBirthPlace  = Convert.ToBoolean(Session["AddressIsBirthPlaceMM"]);
                ad.address_isCurrent     = Convert.ToBoolean(Session["AddressIsCurrentMM"]);
                ad.address_street_arabic = Session["AddresStreetMMArabic"].ToString();
                db.Addresses.Add(ad);
                db.SaveChanges();
            }
            if (aa == "other")
            {
                ad.address_street        = Session["AddresStreetOO"].ToString();
                ad.address_street_arabic = Session["AddresStreetOOArabic"].ToString();
                ad.address_isCurrent     = Convert.ToBoolean(Session["IsCurrenOO"]);
                ad.address_district_id   = Convert.ToInt32(Session["disId"]);
                db.Addresses.Add(ad);
                db.SaveChanges();
            }
            //-------------------Address citizen m To m ----------------------
            AddressCitizen cc = new AddressCitizen();

            cc.CA_AddressId = ad.address_id;
            cc.CA_CitizenId = c.citizen_id;
            db.AddressCitizens.Add(cc);
            db.SaveChanges();


            //----------------------------Documents--------------------------
            Document doc = new Document();

            doc.document_name            = Session["filename"].ToString();
            doc.document_extensions      = Session["extension"].ToString();
            doc.document_documentType_id = Convert.ToInt32(Session["documentTypeName"]);
            doc.document_data            = Session["docData"].ToString();
            doc.document_citizen_id      = c.citizen_id;
            doc.document_date_upload     = Session["uploadDate"].ToString();
            db.Documents.Add(doc);
            db.SaveChanges();

            //---------------------- Login Citizen table ---------------------
            LoginCitizen log = new LoginCitizen();

            // qr code consist of datetime now , datetime seconds , datetime milliseconds , first name and national id
            log.Login_CitizenNId = c.citizen_national_id;
            string pass = Encrypt.enc(c.citizen_national_id);

            log.Login_Password  = pass;
            log.Login_PinNumber = "1234";
            log.Login_CitizenId = c.citizen_id;
            string qr = Encrypt.enc(DateTime.Now.ToString() + "_" + DateTime.Now.Second + "_" + DateTime.Now.Millisecond + "_" + c.citizen_first_name + "_" + c.citizen_national_id);

            log.Login_QRcode = qr;
            db.LoginCitizens.Add(log);
            db.SaveChanges();

            //--------------------------------------- Live Status -------------------------
            Live_Status live = new Live_Status();

            live.live_satus_type_id = 1;
            live.citizen_citizen_id = c.citizen_id;
            db.Live_Status.Add(live);
            db.SaveChanges();


            Session["success"] = Languages.Language.CitizenAddedSuccessfully;
            return(RedirectToAction("Index", "home"));
        }
        // GET: Live_Status/Delete/5
        public ActionResult Delete(int id)
        {
            Live_Status live_Status = db.Live_Status.Find(id);

            return(View(live_Status));
        }