public ActionResult TeamSponsorRegistration(TblTeamSponsor model, string city, string Category)
        {
            var userid = Session["UserId"].ToString();

            List <TblCountry> countries = db.Country_tbl.ToList();

            ViewBag.CountryList = new SelectList(countries, "CountryId", "Country");

            List <TblUser> user = db.User_tbl.ToList();

            ViewBag.UserList = new SelectList(user, "UserId", "UserId");

            if (ModelState.IsValid)
            {
                db.TeamSponsor_tbl.Add(new TblTeamSponsor
                {
                    TeamSponsorReferenceNumber = "1",

                    Name      = model.Name,
                    Category  = model.Category,
                    Confirmed = 1,

                    RegistrationDate = DateTime.Now,
                    ExpirationDate   = DateTime.Now,

                    Mobile = model.Mobile,
                    UserId = Convert.ToInt32(userid),
                    CityId = Convert.ToInt32(city),

                    CreatedId   = 1,
                    CreatedDate = DateTime.Now,

                    ModifiedId   = 0,
                    ModifiedDate = DateTime.Now
                });


                db.SaveChanges();



                return(RedirectToAction("TeamSponsor"));
            }
            return(View());
        }
        public ActionResult EditProfile(int id, TblTeamSponsor model, string city)
        {
            List <TblCountry> countries = db.Country_tbl.ToList();

            ViewBag.CountryList = new SelectList(countries, "CountryId", "Country");

            var EditTeamSponsorList = db.TeamSponsor_tbl.Where(x => x.TeamSponsorId == id).FirstOrDefault();

            if (EditTeamSponsorList != null)
            {
                EditTeamSponsorList.Name     = model.Name;
                EditTeamSponsorList.Category = model.Category;
                EditTeamSponsorList.Mobile   = model.Mobile;

                db.SaveChanges();
            }
            return(Content("<script>alert('Updated Successfully');location.href='TeamSponsorView';</script>"));
        }