public ActionResult Index() { onlineEntities db = new onlineEntities(); List <Product> lists = new List <Product>(); lists = db.Products.ToList(); return(View(lists)); }
public ActionResult Allproducts() { onlineEntities db = new onlineEntities(); List <Product> list = new List <Product>(); list = db.Products.ToList(); return(View(list)); }
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")); }
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)); } }
private void DisconnectFromRemoteDB() { m_Entities?.Dispose(); m_Entities = null; }