public ActionResult login(string User_Email, string Password) { User_table user = ul.login(User_Email, Password); if (user != null) { var base64 = Convert.ToBase64String(user.ProfilePicture); var ImgSRC = string.Format("data:image/gif;base64,{0}", base64); Session.Add("user", user); Session.Add("User_Id", user.User_Id); Session.Add("UserFullname", user.FName + " " + user.LName); Session.Add("User_Email", user.User_Email); Session.Add("ProfilePicture", ImgSRC); Session.Add("Rating", user.Rating); Session.Add("Bio", user.Bio); Session.Add("Gender", user.Gender); if (user.Type_id == 2) { Session.Add("vendor", "vendor"); } if (Session["checkOutRequest"] != null) { return(RedirectToAction("cartDisplay", "Cart")); } else { return(RedirectToAction("Home", "User")); } } else { ViewBag.NotValidUser = "******"; return(View("login")); } }
public List <ProductModel> lastAdded() { User_table userSession = (User_table)HttpContext.Current.Session["user"]; var query = (from p in context.Product_table orderby p.Add_Date descending select p).ToList(); var x = (from p in query join f in context.Following_table on p.Vendor_id equals f.Vendor_id where f.User_id == userSession.User_Id && p.State == "approved" select new ProductModel { Product_Id = p.Product_Id, Product_Description = p.Product_Description, Product_Name = p.Product_Name, Image = p.Image, Product_Price = p.Product_Price, Vendor_id = p.Vendor_id }).ToList(); return(x); }
public void AdminDescision(int id, string status) { Request_table req = new Request_table(); req = context.Request_table.Where(x => x.Request_Id == id).FirstOrDefault(); req.reqState = status; int userid = req.User_Id; if (req.reqState.ToLower() == "approved") { User_table user = new User_table(); user = context.User_table.Where(x => x.User_Id == userid).FirstOrDefault(); user.Type_id = 2; } Admin_Req_App_table AdminApprove = new Admin_Req_App_table(); AdminApprove.Request_Id = id; AdminApprove.State = status; Admin_table admin = (Admin_table)HttpContext.Current.Session["admin"]; AdminApprove.Admin_Id = 1; // return VendorRequest; context.Admin_Req_App_table.Add(AdminApprove); context.SaveChanges(); }
public ActionResult DeleteConfirmed(int id) { User_table user_table = db.User_table.Find(id); db.User_table.Remove(user_table); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult VendorRegister(string FullName, int NationalId, string Bio) { User_table USer = (User_table)Session["user"]; int id = USer.User_Id; BL.User user = new BL.User(); ViewBag.message = user.Vendor_Register(FullName, NationalId, Bio, id); return(PartialView()); }
public int AddUser(User_table u) { var Pwd = u.UserPwd; var UserPwd = MD5Helper.MD5(Pwd); string sql = $"INSERT INTO User_table VALUES(NULL,'{u.UserPhone}', '{u.UserName}','{UserPwd}',{u.UserAge},'{u.UserID_card}','{u.User_Avatar}')"; return(DLH_DBHelper.CMD(sql)); }
public ActionResult Edit([Bind(Include = "Id,user_name,user_email,user_password")] User_table user_table) { if (ModelState.IsValid) { db.Entry(user_table).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(user_table)); }
public ActionResult Create([Bind(Include = "Id,user_name,user_email,user_password")] User_table user_table) { if (ModelState.IsValid) { db.User_table.Add(user_table); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(user_table)); }
public List <User_table> myFollowedVendor(int ID) { List <User_table> FollwedUsers = new List <User_table>(); List <int> FollowedIds = context.Following_table.Where(s => s.User_id == ID).Select(s => s.Vendor_id).ToList(); for (int i = 0; i < FollowedIds.Count; i++) { int followid = FollowedIds[i]; User_table FollwedUser = context.User_table.FirstOrDefault(s => s.User_Id == followid); FollwedUsers.Add(FollwedUser); } return(FollwedUsers); }
// GET: User_table/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } User_table user_table = db.User_table.Find(id); if (user_table == null) { return(HttpNotFound()); } return(View(user_table)); }
public ActionResult Login(User_table objUser) { if (ModelState.IsValid) { using (AuctionDBEntities db = new AuctionDBEntities()) { var obj = db.User_table.Where(a => a.user_name.Equals(objUser.user_name) && a.user_password.Equals(objUser.user_password)).FirstOrDefault(); if (obj != null) { Session["Id"] = objUser.Id.ToString(); Session["user_name"] = objUser.user_name.ToString(); Session["isActive"] = objUser.isActive.ToString(); return(RedirectToAction("Auction", "Home")); } } } return(View(objUser)); }
//User Register (Sign Up) public bool Sign_Up_As_User(UserModel newUser) { bool Check; byte[] fileData = null; var binaryReader = new BinaryReader(newUser.ProfilePicture.InputStream); fileData = binaryReader.ReadBytes(newUser.ProfilePicture.ContentLength); var RegistUser = (from RegUser in context.User_table where RegUser.User_Email.Equals(newUser.email) select RegUser.User_Email ).FirstOrDefault(); if (RegistUser == null) { User_table user = new User_table(); user.FName = newUser.fname; user.LName = newUser.lname; user.User_Name = newUser.username; user.User_Email = newUser.email; user.Password = newUser.password; user.PhoneNumber = newUser.phone; user.SSN = newUser.ssn; user.Type_id = 1; user.ProfilePicture = fileData; user.Gender = newUser.gender; user.Bio = newUser.Bio; user.Rating = 0; context.User_table.Add(user); context.SaveChanges(); Check = true; } else { Check = false; } return(Check); }
//Selected User public ActionResult SelectedUser(int id) { Session.Add("profileid", id); BL.User user = new BL.User(); User_table selecteduser = user.GetSelectedUser(id); ViewBag.user_id = selecteduser.User_Id; Product product = new Product(); ViewBag.VendorProducts = product.GetProductsOfvendor(id); ViewBag.BestSellingVendorProducts = product.BestSellingForVendor(id); if (Session["user"] != null) { ViewBag.substate = vendorlogic.checkfollow((int)Session["User_Id"], id); } return(View(selecteduser)); }
public List <ProductModel> topSellerSup() { User_table userSession = (User_table)HttpContext.Current.Session["user"]; int[] query = (from o in context.OrderDetails_table join p in context.Product_table on o.Pro_Id equals p.Product_Id group o.Quantity by p.Product_Id into g orderby g.Sum() descending select g.Key).ToArray(); // get the top 5 orders List <ProductModel> topSoldProducts = new List <ProductModel>(); ProductModel[] topSold = new ProductModel[query.Length]; for (int i = 0; i < query.Length; i++) { int pid = query[i]; var x = (from p in context.Product_table join s in context.Subscribtion_table on p.Cat_id equals s.Cat_Id where p.Product_Id == pid && s.User_Id == userSession.User_Id && p.State == "approved" select new ProductModel { Product_Id = p.Product_Id, Product_Description = p.Product_Description, Product_Name = p.Product_Name, Image = p.Image, Product_Price = p.Product_Price, Vendor_id = p.Vendor_id }).ToList(); topSoldProducts.AddRange((List <ProductModel>)x); } return(topSoldProducts); }
//Get User or Vendor Which is clicked on his profile public User_table GetSelectedUser(int id) { User_table SelectedUser = context.User_table.Where(x => x.User_Id == id).FirstOrDefault(); return(SelectedUser); }
public User_table login(string User_Email, string Password) { User_table user = context.User_table.Where(s => s.User_Email.Equals(User_Email) && s.Password.Equals(Password)).FirstOrDefault(); return(user); }
public IActionResult AddUser([FromForm] User_table u) { return(Ok(Ubll.AddUser(u))); }
public int AddUser(User_table u) { return(Udal.AddUser(u)); }