示例#1
0
        public ActionResult Index()
        {
            onlineEntities db    = new onlineEntities();
            List <Product> lists = new List <Product>();

            lists = db.Products.ToList();
            return(View(lists));
        }
示例#2
0
        public ActionResult Allproducts()
        {
            onlineEntities db   = new onlineEntities();
            List <Product> list = new List <Product>();

            list = db.Products.ToList();
            return(View(list));
        }
示例#3
0
        public async Task <ActionResult> Register(RegisterViewModel model)
        {
            if (ModelState.IsValid)
            {
                var user = new ApplicationUser {
                    UserName = model.Email, Email = model.Email
                };
                var result = await UserManager.CreateAsync(user, model.Password);

                if (result.Succeeded)
                {
                    await SignInManager.SignInAsync(user, isPersistent : false, rememberBrowser : false);

                    // For more information on how to enable account confirmation and password reset please visit https://go.microsoft.com/fwlink/?LinkID=320771
                    // Send an email with this link
                    // string code = await UserManager.GenerateEmailConfirmationTokenAsync(user.Id);
                    // var callbackUrl = Url.Action("ConfirmEmail", "Account", new { userId = user.Id, code = code }, protocol: Request.Url.Scheme);
                    // await UserManager.SendEmailAsync(user.Id, "Confirm your account", "Please confirm your account by clicking <a href=\"" + callbackUrl + "\">here</a>");

                    onlineEntities db          = new onlineEntities();
                    RegisteredUser user4       = new RegisteredUser();
                    var            userdbmodel = db.AspNetUsers.Where(a => a.Email.Equals(model.Email)).FirstOrDefault();
                    user4.Id       = model.Id;
                    user4.Name     = model.Name;
                    user4.Email    = model.Email;
                    user4.CNIC     = model.CNIC;
                    user4.Adress   = model.Address;
                    user4.Password = model.Password;

                    //user4.FK_R_ID = userdbmodel.Id;
                    db.RegisteredUsers.Add(user4);
                    db.SaveChanges();



                    return(RedirectToAction("Index", "Home"));
                }
                AddErrors(result);
            }

            // If we got this far, something failed, redisplay for
            return(View(model));
        }
        public ActionResult Create(ProductViewModel productss)
        {
            try
            {
                string filename  = Path.GetFileNameWithoutExtension(productss.ImageFile.FileName);
                string extension = Path.GetExtension(productss.ImageFile.FileName);
                filename         = filename + DateTime.Now.ToString("yymmssfff") + extension;
                productss.Images = "~/images/" + filename;
                filename         = Path.Combine(Server.MapPath("~/images/"), filename);
                productss.ImageFile.SaveAs(filename);

                using (onlineEntities db = new onlineEntities())
                {
                    if (db.Products.Any(x => x.ProductName == productss.ProductName))
                    {
                        ViewBag.DuplicateMessage = "Product Already exists";
                        return(View(productss));
                    }
                    Product p = new Product();
                    p.ProductName  = productss.ProductName;
                    p.ProductDescp = productss.ProductDescp;
                    p.ImageId      = productss.ImageId;
                    p.Images       = productss.Images;
                    p.Category     = productss.Category;
                    p.BidAmount    = productss.BidAmount;
                    p.AuctionDate  = productss.AuctionDate;
                    p.Id           = 12;

                    db.Products.Add(p);
                    db.SaveChanges();
                }
                //var user = new ApplicationUser { UserName = model.Email, Email = model.Email };
                //var result = await UserManager.CreateAsync(user, model.Password);
            }
            catch (Exception ex)
            {
                return(View(ex));
            }
            ModelState.Clear();
            ViewBag.SuccessMessage = "Successful";
            return(RedirectToAction("Index2"));
        }
示例#5
0
        public bool ConnectToRemoteDB()
        {
            if (IsConnectedToRemoteDB)
            {
                return(true);
            }

            m_Entities = new onlineEntities();

            try
            {
                if (!m_Entities.Database.Exists())
                {
                    throw new InvalidOperationException();
                }
            }
            catch
            {   // Невозможно подключиться к БД
                m_Entities = null;
                return(false);
            }

            return(true);
        }
        public ActionResult Login(LoginViewModel model)
        {
            int            i  = 1;
            int            j  = 0;
            onlineEntities db = new onlineEntities();

            try
            {
                RegisteredUser o = new RegisteredUser();
                foreach (var a in db.RegisteredUsers)
                {
                    if (a.Email == model.Email && a.Password == model.Password)
                    {
                        i    = 0;
                        myid = a.Id;
                        if (a.Id == 3)
                        {
                            return(RedirectToAction("IndexAdmin", "Products"));
                        }
                    }
                }
                if (i == 0)
                {
                    return(RedirectToAction("Index2", "Products"));
                }
                else
                {
                    return(View(model));
                }
            }
            catch (Exception ex)
            {
                ModelState.AddModelError("", "Invalid login attempt.");
                return(View(model));
            }
        }
示例#7
0
 private void DisconnectFromRemoteDB()
 {
     m_Entities?.Dispose();
     m_Entities = null;
 }