public ActionResult SignUp(string Username, string Email, string Password)
        {
            alaparSql2Entities db = new alaparSql2Entities();

            foreach (var item in db.Profiles)
            {
                if (item.Username == Username)
                {
                    Session["UsernameTutulub"] = true;
                    return(RedirectToAction("SignUp"));
                }
                if (item.Email == Email)
                {
                    Session["EmailTutulub"] = true;
                    return(RedirectToAction("SignUp"));
                }
            }
            Profile YeniProfile = new Profile();

            YeniProfile.Username = Username;
            YeniProfile.Email    = Email;

            string Pass = Crypto.HashPassword(Password);

            YeniProfile.Password = Pass;
            db.Profiles.Add(YeniProfile);
            db.SaveChanges();



            return(RedirectToAction("Index"));
        }
        public ActionResult LogIn(string Username, string Password)
        {
            alaparSql2Entities db = new alaparSql2Entities();

            foreach (var a in db.Profiles)
            {
                if (a.Username == Username && Crypto.VerifyHashedPassword(a.Password, Password))
                {
                    Session["DaxilOlundu"] = a.Username;
                    Session["DaxilOlanID"] = a.Id;
                    return(RedirectToAction("Index", "Home"));
                }
            }

            foreach (var b in db.Agents)
            {
                if (b.Username == Username && b.Password == Password)
                {
                    Session["AgentIcerde"] = b.Username;
                    Session["AgentId"]     = b.Id;
                    return(RedirectToAction("Index", "Home"));
                }
            }

            Session["MelumatSehvi"] = true;

            return(RedirectToAction("Index", "Sign"));
        }
        public ActionResult SendEmail(string Email)
        {
            alaparSql2Entities db = new alaparSql2Entities();

            foreach (var item in db.Profiles)
            {
                if (item.Email == Email)
                {
                    SmtpClient smtpClient = new SmtpClient("mail.alapar.az", 25);

                    smtpClient.Credentials           = new System.Net.NetworkCredential("*****@*****.**", "5591980Super");
                    smtpClient.UseDefaultCredentials = true;
                    smtpClient.DeliveryMethod        = SmtpDeliveryMethod.Network;
                    smtpClient.EnableSsl             = true;
                    MailMessage mail = new MailMessage();

                    //Setting From , To and CC
                    mail.From = new MailAddress("info@alapar", "Alapar.az");
                    mail.To.Add(new MailAddress(Email));
                    mail.Subject = "Şifrə Yenilənməsi";
                    mail.Body    = "Şifrənizi Yeniləmək Üçün: www.alapar.az/Sign/ChangePage/" + item.Id + "     istifadəçi Adınız: " + item.Username;


                    smtpClient.Send(mail);

                    Session["EmailSent"] = true;
                    return(RedirectToAction("Forgot"));
                }
            }

            Session["WrongEmail"] = true;
            return(RedirectToAction("Forgot"));
        }
        public ActionResult ChangePage(int id)
        {
            alaparSql2Entities db   = new alaparSql2Entities();
            Profile            Sexs = db.Profiles.Find(id);

            ViewBag.Sexs = Sexs.Id;

            return(View());
        }
        public ActionResult CompChange(int id, string Pass)
        {
            alaparSql2Entities db = new alaparSql2Entities();


            string pa = Crypto.HashPassword(Pass);

            db.Profiles.Find(id).Password = pa;
            db.SaveChanges();

            return(RedirectToAction("Index", "Sign"));
        }
        public ActionResult Vip()
        {
            alaparSql2Entities db = new alaparSql2Entities();

            DataBaseForHome data = new DataBaseForHome();

            if (db.Ads.Where(w => w.VIP == true && w.StartDate < DateTime.Now && w.EndDate > DateTime.Now).Count() >= 20)
            {
                data.Elanler = db.Ads.Where(w => w.VIP == true && w.StartDate <DateTime.Now && w.EndDate> DateTime.Now).Take(20).ToList();
            }
            else
            {
                data.Elanler = db.Ads.Where(w => w.VIP == true && w.StartDate <DateTime.Now && w.EndDate> DateTime.Now).ToList();
            }

            data.Sekiller  = db.Images.ToList();
            data.TamSiyahi = db.Ads.Where(w => w.VIP == true && w.StartDate <DateTime.Now && w.EndDate> DateTime.Now).ToList();

            return(View(data));
        }