public int SavePersonalData(personal_data personalParam)
        {
            int id;

            using (PersonalDataRepository personalRepo = new PersonalDataRepository())
            {
                if (personalRepo.Exist(personalParam))
                {
                    try
                    {
                        personalRepo.Update(personalParam);
                        personalRepo.Save();
                    }
                    catch (Exception ex)
                    {
                        Debug.WriteLine(ex.Message);
                    }
                }
                else
                {
                    try
                    {
                        personalRepo.Insert(personalParam);
                        personalRepo.Save();
                        Debug.WriteLine("userPresenter: personal data insert kész");
                    }
                    catch (Exception ex)
                    {
                        Debug.WriteLine(ex.Message);
                    }
                }
                id = personalRepo.GetPersonalDataId(personalParam);
            }
            return(id);
        }
 public void Insert(personal_data param)
 {
     if (db.personal_data.Any(x => x.id == param.id))
     {
         throw new Exception("Már létezik ilyen id!");
     }
     db.personal_data.Add(param);
 }
        public ActionResult DeleteConfirmed(int id)
        {
            personal_data personal_data = db.personal_data.Find(id);

            db.personal_data.Remove(personal_data);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
        public void Update(personal_data param)
        {
            var personal = db.personal_data.Find(param.id);

            if (personal != null)
            {
                db.Entry(personal).CurrentValues.SetValues(param);
            }
        }
 public ActionResult Edit([Bind(Include = "id,address,passport_info,birthday,sex")] personal_data personal_data)
 {
     if (ModelState.IsValid)
     {
         db.Entry(personal_data).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     return(View(personal_data));
 }
        public ActionResult Create([Bind(Include = "id,address,passport_info,birthday,sex")] personal_data personal_data)
        {
            if (ModelState.IsValid)
            {
                db.personal_data.Add(personal_data);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

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

            if (personal_data == null)
            {
                return(HttpNotFound());
            }
            return(View(personal_data));
        }
 public bool Exist(personal_data peronal)
 {
     return(db.personal_data.Any(x => x.id == peronal.id));
 }
        public int GetPersonalDataId(personal_data param)
        {
            var pd = db.personal_data.SingleOrDefault(x => x.mother == param.mother && x.phone == param.phone && x.location == param.location);

            return(pd.id);
        }
        public bool ValidateData(personal_data personalParam, user_data user)
        {
            view.errorFirstName = null;
            view.errorLastName  = null;
            view.errorMother    = null;
            view.errorPhone     = null;
            view.errorLocation  = null;

            view.errorUserName = null;
            view.errorPassword = null;

            bool valid = true;

            if (string.IsNullOrEmpty(personalParam.first_name))
            {
                view.errorFirstName = Resources.errorRequired;
                valid = false;
            }
            if (string.IsNullOrEmpty(personalParam.last_name))
            {
                view.errorLastName = Resources.errorRequired;
                valid = false;
            }
            if (string.IsNullOrEmpty(personalParam.mother))
            {
                view.errorMother = Resources.errorRequired;
                valid            = false;
            }
            if (string.IsNullOrEmpty(personalParam.phone))
            {
                view.errorPhone = Resources.errorRequired;
                valid           = false;
            }
            if (string.IsNullOrEmpty(personalParam.location))
            {
                view.errorLocation = Resources.errorRequired;
                valid = false;
            }



            if (string.IsNullOrEmpty(user.user_name))
            {
                view.errorUserName = Resources.errorRequired;
                valid = false;
            }
            else
            {
                using (UserDataRepository userRepo = new UserDataRepository())
                {
                    if (user.id > 0)//Már létező user
                    {
                        var oldUser = userRepo.GetUserData(user.id);
                        if (oldUser.user_name != user.user_name)//csak akkor kell ellenőrizni ha történt változás a userName ben
                        {
                            if (userRepo.UserNameExist(user.user_name))
                            {
                                view.errorUserName = Resources.errorExist;
                                valid = false;
                            }
                        }
                    }
                    else// Új user
                    {
                        if (userRepo.UserNameExist(user.user_name))
                        {
                            view.errorUserName = Resources.errorExist;
                            valid = false;
                        }
                    }
                }
            }
            if (string.IsNullOrEmpty(user.password))
            {
                view.errorPassword = Resources.errorRequired;
                valid = false;
            }

            return(valid);
        }