public ActionResult Edit(Models.ManageUser model) { using (Models.UserEntities db = new Models.UserEntities()) { var result = (from s in db.AspNetUsers where s.Id == model.Id select s).FirstOrDefault(); if (result != default(Models.AspNetUsers)) { result.UserName = model.UserName; result.Email = model.Email; db.SaveChanges(); // 設定成功訊息 TempData["ResultMessage"] = $"使用者 {model.UserName} 成功編輯。"; return(RedirectToAction("Index")); } } // 設定錯誤訊息 TempData["ResultMessage"] = $"使用者 {model.UserName} 不存在,請重新操作。"; return(RedirectToAction("Index")); }
public ActionResult Index() { ViewBag.ResultMessage = TempData["ResultMessage"]; var userName = User.Identity.GetUserName(); if (userName == "Admin") { using (Models.UserEntities db = new Models.UserEntities()) { //抓取所有AspNetUsers中的資料並放入Models.ManageUser中 var result = (from s in db.AspNetUsers select new Models.ManageUser { Id = s.Id, UserName = s.UserName, Email = s.Email }).ToList(); return(View(result)); } } else { return(Content("<script>alert('權限不足 滾啦!');history.go(-1);</script>")); //return Content("<script>alert('權限不足 滾啦!');window.location.href='../Home/Index';</script>"); //return Redirect("/Home/Index"); } }
// GET: ManageUser public ActionResult Index() { ViewBag.ResultMessage = TempData["ResultMessage"]; using (Models.UserEntities db = new Models.UserEntities()) { //抓取所有AspNetUsers中的資料,並且放入Models.ManageUser模型中 var result = (from s in db.AspNetUsers select new Models.ManageUser { Id = s.Id, UserName = s.UserName, Email = s.Email }). ToList(); return(View(result)); } /*或寫作 * var result = db.AspNetUsers.Select( * s => new Models.ManageUser * { * Id = s.Id, * UserName = s.UserName, * Email = s.Email * }); * return View(result.ToList()); */ }
public ActionResult SerachByUserName(string name) { string searchUserId = null; using (Models.UserEntities db = new Models.UserEntities()) //查詢目前網站使用者暱稱符合UserName的UserId { searchUserId = (from s in db.AspNetUsers where s.UserName == name select s.Id).FirstOrDefault(); } if (!String.IsNullOrEmpty(searchUserId)) { using (Models.ItemEntities db = new Models.ItemEntities()) //如果有存在UserId則將此UserId的所有訂單找出 { var result = (from s in db.Orders where s.UserId == searchUserId select s).ToList(); return(View("Index", result)); } } else { return(View("Index", new List <Models.Order>())); } }
public ActionResult Edit(string id) { using (Models.UserEntities db = new Models.UserEntities()) { var result = (from s in db.AspNetUsers where s.Id == id select new Models.ManageUser /*或寫為 * var result = db.AspNetUsers.Where(w => w.Id == id) * .Select(s => new Models.ManageUser */ { Id = s.Id, UserName = s.UserName, Email = s.Email }).FirstOrDefault(); if (result != default(Models.ManageUser)) { return(View(result)); } } //設定錯誤訊息 TempData["ResultMessage"] = $"使用者 {id} 不存在,請重新操作。"; return(RedirectToAction("Index")); }
public ActionResult Edit(string id) { using (Models.UserEntities db = new Models.UserEntities()) { var result = ( from s in db.AspNetUsers where s.Id == id select new Models.ManageUser { Id = s.Id, NickName = s.Name, Email = s.Email } ).FirstOrDefault(); if (result != default(Models.ManageUser)) { return(View(result)); } } //設定錯誤訊息 TempData["ResultMessage"] = String.Format("使用者[{0}]不存在,請重新操作", id); return(RedirectToAction("Index")); }
public ActionResult SerachByUserName(string UserName) { //儲存查詢出來的UserId string searchUserId = null; using (Models.UserEntities db = new Models.UserEntities()) { //查詢目前網站使用者暱稱符合UserName的UserId searchUserId = (from s in db.AspNetUsers where s.UserName == UserName select s.Id).FirstOrDefault(); } //如果有存在UserId if (!String.IsNullOrEmpty(searchUserId)) { //則將此UserId的所有訂單找出 using (Models.CartsEntities db = new Models.CartsEntities()) { var result = (from s in db.Orders where s.UserId == searchUserId select s).ToList(); //回傳 結果 至Index()的View return(View("Index", result)); } } else { //回傳 空結果 至Index()的View return(View("Index", new List <Models.Order>())); } }
public ActionResult SearchByUserName(string userName) { // 儲存查詢出來的 UserId string SearchUserId = null; using (Models.UserEntities db = new Models.UserEntities()) { SearchUserId = db.AspNetUsers .Where(w => w.UserName == userName) .Select(s => s.Id).FirstOrDefault(); } // 如果有存在 UserId if (!string.IsNullOrEmpty(SearchUserId)) { // 將該 UserId 的所有訂單找出 using (Models.CartsEntities db = new Models.CartsEntities()) { var result = db.Orders .Where(w => w.UserId == SearchUserId) .Select(s => s).ToList(); // 回傳 結果 至 Index 頁面 return(View("Index", result)); } } // 回傳 空結果 至 Index View return(View("Index", new List <Models.Order>())); }
//取得訂單中的使用者暱稱 public string GetUrderName() { //使用Order類別中的UserId到AspNetUsers資料表搜尋出UserName using (Models.UserEntities db = new Models.UserEntities()) { var result = (from s in db.AspNetUsers where s.Id == this.UserId select s.UserName).FirstOrDefault(); //回傳找到的UserName return(result); } }
public ActionResult Edit(string id) { using (Models.UserEntities db = new Models.UserEntities()) { var result = (from s in db.AspNetUsers select new Models.ManageUser { Id = s.Id, UserName = s.UserName, Email = s.Email }).FirstOrDefault(); } return(View()); }
public ActionResult Details(string id) { if (string.IsNullOrWhiteSpace(id)) { // 設定錯誤訊息 TempData["ResultMessage"] = $"使用者 {id} 不存在,請重新操作。"; return(RedirectToAction("Index")); } using (Models.UserEntities db = new Models.UserEntities()) { var result = db.AspNetUsers.Find(id); return(View(result)); } }
public ActionResult Index() { ViewBag.ResultMessage = TempData["ResultMessage"]; using (Models.UserEntities db = new Models.UserEntities()) {//抓所有AspNetUsers中的資料,並放入model.ManagerUser中 var result = (from s in db.AspNetUsers select new Models.ManageUser { Id = s.Id, UserName = s.UserName, Email = s.Email }).ToList(); return View(result); } }
// GET: ManageUser public ActionResult Index() { ViewBag.ResultMessage = TempData["ResultMessage"]; using (Models.UserEntities db = new Models.UserEntities()) { var result = (from s in db.AspNetUsers select new Models.ManageUser { Id = s.Id, UserName = s.UserName, Email = s.Email }).ToList(); return(View(result)); } }
// GET: ManageUser public ActionResult Index() { ViewBag.ResultMessage = TempData["ResultMessage"]; using (Models.UserEntities db = new Models.UserEntities()) { // 取得所有 AspNetUsers 的資料,並放入 Models.ManageUser 模式中 var result = db.AspNetUsers.Select( s => new Models.ManageUser { Id = s.Id, UserName = s.UserName, Email = s.Email }); return(View(result.ToList())); } }
//會員資料 public ActionResult UserView(string UserName) { var getName = HttpContext.User.Identity.GetUserName().ToString(); using (Models.UserEntities db = new Models.UserEntities()) { //抓取指定AspNetUsers中的資料,並且放入Models.ManageUser模型中 var result = (from s in db.AspNetUsers where s.UserName == getName //抓取暱稱 select new Models.ManageUser { Id = s.Id, UserName = s.UserName, Email = s.Email }).ToString(); return(View(result)); } }
public ActionResult Edit(Models.ManageUser postback) { using (Models.UserEntities db = new Models.UserEntities()) { var result = (from s in db.AspNetUsers where s.Id == postback.Id select s).FirstOrDefault(); if (result != default(Models.AspNetUsers)) { result.UserName = postback.UserName; result.Email = postback.Email; db.SaveChanges(); TempData["ResultMessage"] = String.Format("使用者[{0}]編輯成功", postback.UserName); return(RedirectToAction("Index")); } } //Error Message TempData["ResultMessage"] = String.Format("使用者[{0}]不存在,請重新操作", postback.UserName); return(RedirectToAction("Index")); }
// // GET: /Manage/Index public async Task <ActionResult> Index(ManageMessageId?message) { ViewBag.StatusMessage = message == ManageMessageId.ChangePasswordSuccess ? "已變更您的密碼。" : message == ManageMessageId.SetPasswordSuccess ? "已設定您的密碼。" : message == ManageMessageId.SetTwoFactorSuccess ? "已設定您的雙因素驗證。" : message == ManageMessageId.Error ? "發生錯誤。" : message == ManageMessageId.AddPhoneSuccess ? "已新增您的電話號碼。" : message == ManageMessageId.RemovePhoneSuccess ? "已移除您的電話號碼。" : ""; ManagerAndMemberViewModel viewModel = new ManagerAndMemberViewModel(); var userId = User.Identity.GetUserId(); using (Models.UserEntities db = new Models.UserEntities()) { var result = (from s in db.AspNetUsers where s.Id == userId select new ManageUser { Id = s.Id, Email = s.Email, ImgUrl = s.ImgUrl, NickName = s.Name } ).FirstOrDefault(); var model = new IndexViewModel { HasPassword = HasPassword(), PhoneNumber = await UserManager.GetPhoneNumberAsync(userId), TwoFactor = await UserManager.GetTwoFactorEnabledAsync(userId), Logins = await UserManager.GetLoginsAsync(userId), BrowserRemembered = await AuthenticationManager.TwoFactorBrowserRememberedAsync(userId) }; viewModel.IndexViewModels = model; viewModel.ManageUsers = result; return(View(viewModel)); }; }
// GET: Product public ActionResult Index() { //宣告回傳商品列表result List <Models.Product> result = new List <Models.Product>(); //接收轉導的成功訊息 ViewBag.ResultMessage = TempData["ResultMessage"]; //使用CartsEntities類別,名稱為db using (Models.CartsEntities db = new Models.CartsEntities()) { var userName = HttpContext.User.Identity.GetUserName(); var userId = HttpContext.User.Identity.GetUserId(); using (Models.UserEntities dbs = new Models.UserEntities()) { var limits = ""; var limit = (from s in dbs.AspNetUsers where s.Id == userId select new Models.ManageUser { Limit = s.Limit }).FirstOrDefault(); foreach (var item in limit.Limit.ToString()) { limits = item.ToString(); } if (limits != "1") { result = (from s in db.Products where s.UserName == userName select s).ToList(); //將result傳送給檢視 return(View(result)); } else { //使用LinQ語法抓取目前Products資料庫中所有資料 result = (from s in db.Products select s).ToList(); //將result傳送給檢視 return(View(result)); } } } }
public ActionResult Edit(Models.ManageUser postback) { using (Models.UserEntities db = new Models.UserEntities()) { var result = (from s in db.AspNetUsers where s.Id == postback.Id select s).FirstOrDefault(); if (result != default(Models.AspNetUsers)) { result.UserName = postback.UserName; result.Email = postback.Email; db.SaveChanges(); TempData["ResultMessage"] = String.Format("User {0} has been sucessfully edited.", postback.UserName); return(RedirectToAction("Index")); } } TempData["ResultMessage"] = String.Format("User {0} not exist, please try again.", postback.UserName); return(RedirectToAction("Index")); }
public ActionResult Edit(string id) { using (Models.UserEntities db = new Models.UserEntities()) { var result = (from s in db.AspNetUsers where s.Id == id select new Models.ManageUser { Id = s.Id, UserName = s.UserName, Email = s.Email }).FirstOrDefault(); if (result != default(Models.ManageUser)) { return(View(result)); } } TempData["ResultMessage"] = String.Format("User {0}] not exist, please try again.", id); return(RedirectToAction("Index")); }
public ActionResult Edit(Models.ManageUser postback) { using (Models.UserEntities db = new Models.UserEntities()) { var result = (from s in db.AspNetUsers where s.Id == postback.Id select s).FirstOrDefault(); if (result != default(Models.AspNetUsers)) { result.UserName = postback.UserName; result.Email = postback.Email; db.SaveChanges(); //設定成功訊息 TempData["ResultMessage"] = String.Format("使用者[{0}]成功編輯", postback.UserName); return RedirectToAction("Index"); } } //設定錯誤訊息 TempData["ResultMessage"] = String.Format("使用者[{0}]不存在,請重新操作", postback.UserName); return RedirectToAction("Index"); }
//編輯會員資訊 public ActionResult Edit(string id) { using (Models.UserEntities db = new Models.UserEntities()) { var result = (from s in db.AspNetUsers where s.Id == id select new Models.ManageUser { Id = s.Id, UserName = s.UserName, Email = s.Email }).FirstOrDefault(); if( result != default(Models.ManageUser)) { return View(result); } } //Error Message TempData["ResultMessage"] = String.Format("使用者[{0}]不存在,請重新操作", id); return RedirectToAction("Index"); }
public ActionResult SearchByUserName(string UserName) { string searchId = null; using (Models.UserEntities db = new Models.UserEntities()) { searchId = (from s in db.AspNetUsers where s.UserName == UserName select s.Id).FirstOrDefault(); } if (!String.IsNullOrEmpty(searchId)) { using (Models.mainEntities db = new Models.mainEntities()) { var result = (from s in db.OrderSet where s.UserId == searchId select s).ToList(); return(View("Index", result)); } } else { return(View("Index", new List <Models.Order>())); } }
public ActionResult Edit(Models.ManageUser postback) { using (Models.UserEntities db = new Models.UserEntities()) { var result = (from s in db.AspNetUsers where s.Id == postback.Id select s).FirstOrDefault(); if (result != default(Models.AspNetUser)) { result.UserName = postback.UserName; result.Email = postback.Email; db.SaveChanges(); //設定成功訊息 TempData["ResultMessage"] = String.Format("Succeed to edit user [{0}]", postback.UserName); return(RedirectToAction("Index")); } } //設定錯誤訊息 TempData["ResultMessage"] = String.Format("User [{0}] does not exist,please try again", postback.UserName); return(RedirectToAction("Index")); }
public ActionResult Delete(string id) { using (Models.UserEntities db = new Models.UserEntities()) { var result = db.AspNetUsers.Find(id); if (result != default(Models.AspNetUsers)) { db.AspNetUsers.Remove(result); // 儲存所有變更 db.SaveChanges(); // 設定成功訊息,並導回 Index 頁面 TempData["ResultMessage"] = $"使用者 {result.UserName} 已成功刪除"; return(RedirectToAction("Index")); } // 如果沒有資料,顯示錯誤訊息,並將頁面導回 Index 頁面。 TempData["ResultMessage"] = $"使用者 {id} 不存在,無法刪除,請重新操作。"; return(RedirectToAction("Index")); } }
// GET: ManageOrder //public ActionResult Index() //{ // using( Models.CartsEntities db = new Models.CartsEntities() ) // { // //取得Order中所有資料 // var result = (from s in db.Orders // select s).ToList(); // return View(result); // } //} public ActionResult Index() { using (Models.CartsEntities db = new Models.CartsEntities()) { var userId = HttpContext.User.Identity.GetUserId(); using (Models.UserEntities dbs = new Models.UserEntities()) { var limits = ""; var limit = (from s in dbs.AspNetUsers where s.Id == userId select new Models.ManageUser { Limit = s.Limit }).FirstOrDefault(); foreach (var item in limit.Limit.ToString()) { limits = item.ToString(); } if (limits != "1") { //取得Order中所有資料 var result = (from s in db.Orders where s.UserId == userId select s ).ToList(); return(View(result)); } else { //取得Order中所有資料 var result = (from s in db.Orders select s).ToList(); return(View(result)); } } } }
public ActionResult Edit(Models.ManageUser postback) { if (this.ModelState.IsValid) //判斷使用者輸入資料是否正確 { using (Models.UserEntities db = new Models.UserEntities()) { var result = (from s in db.AspNetUsers where s.Id == postback.Id select s).FirstOrDefault(); if (result != default(Models.AspNetUser)) { result.UserName = postback.UserName; result.Email = postback.Email; db.SaveChanges(); //設定成功訊息 TempData["ResultMessage"] = String.Format("使用者[{0}]成功編輯", postback.UserName); return(RedirectToAction("Index")); } } } //設定錯誤訊息 TempData["ResultMessage"] = String.Format("使用者[{0}]不存在,請重新操作", postback.UserName); return(RedirectToAction("Index")); }
public async Task <ActionResult> Register(RegisterViewModel model, HttpPostedFileBase photoFile) { var user = new ApplicationUser { UserName = model.Email, Email = model.Email, ImgUrl = model.ImgUrl, Name = model.Name }; var result = await UserManager.CreateAsync(user, model.Password); //上傳大頭照 using (Models.UserEntities db = new Models.UserEntities()) { var Idresult = (from s in db.AspNetUsers where s.Email == model.Email select s).FirstOrDefault(); if (Idresult != default(Models.AspNetUsers)) { var UserId = Idresult.Id; var fileName = "photo.jpg"; //路徑 var path = Path.Combine(Server.MapPath("~/FileUploads/" + UserId)); //路徑加檔案名 var pathName = Path.Combine(Server.MapPath("~/FileUploads/" + UserId), fileName); if (photoFile != null) { if (!isPicture(photoFile.FileName)) { TempData["ErrorMessage"] = "您所上傳的檔案類型並不是圖片"; return(RedirectToAction("Register")); } if (IsImage(photoFile) == null) { TempData["ErrorMessage"] = "您所上傳的檔案內容並不是圖片"; return(RedirectToAction("Register")); } if (photoFile.ContentLength > 0) { //資料夾不存在的話創一個 if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } //有此檔名的話把他刪了 if (System.IO.File.Exists(pathName)) { System.IO.File.Delete(pathName); } Image photo = Image.FromStream(photoFile.InputStream); photo.Save(pathName, System.Drawing.Imaging.ImageFormat.Jpeg); } Idresult.ImgUrl = "~/FileUploads/" + UserId + "/photo.jpg"; } //沒上傳大頭照的話就給他一張預設的大頭照 else { Idresult.ImgUrl = "~/FileUploads/NoPhoto/no-photo.jpg"; } db.SaveChanges(); } } if (result.Succeeded) { //這裡我讓他在註冊的第一個帳號為Admin // var roleName = "Admin"; // if (HttpContext.GetOwinContext().Get<ApplicationRoleManager>().RoleExists(roleName) == false) // { // //角色不存在,建立角色 //var role = new Microsoft.AspNet.Identity.EntityFramework.IdentityRole(roleName); //await HttpContext.GetOwinContext().Get<ApplicationRoleManager>().CreateAsync(role); // } // //將使用者加入該角色 // await UserManager.AddToRoleAsync(user.Id, roleName); //await SignInManager.SignInAsync(user, isPersistent:false, rememberBrowser:false); // 如需如何啟用帳戶確認和密碼重設的詳細資訊,請造訪 http://go.microsoft.com/fwlink/?LinkID=320771 // 傳送包含此連結的電子郵件 // 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, "確認您的帳戶", "請按一下此連結確認您的帳戶 <a href=\"" + callbackUrl + "\">這裏</a>"); //return RedirectToAction("Index", "Home"); var 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, "確認您的帳戶", "請按一下此連結確認您的帳戶 " + callbackUrl); ViewBag.Link = callbackUrl; return(View("DisplayEmail")); } AddErrors(result); // 如果執行到這裡,發生某項失敗,則重新顯示表單 return(View(model)); }
//public ActionResult SearchByUserName(string UserName) //{ // //儲存查詢出來的UserId // string searchUserId = null; // using (Models.UserEntities db = new Models.UserEntities()) // { // searchUserId = (from s in db.AspNetUsers // where s.UserName == UserName // select s.Id).FirstOrDefault(); // } // //如果有存在UserId // if(!String.IsNullOrEmpty(searchUserId)) // { // //則將此UserId的所有訂單找出 // using (Models.ShoppingCartsEntities db = new Models.ShoppingCartsEntities()) // { // var result = (from s in db.Orders // where s.UserId == searchUserId // select s).ToList(); // //回傳 結果 至Index()的View // return View("Index", result); // } // } // else // { // //回傳空結果 // return View("Index", new List<Models.Order>()); // } //} public ActionResult SearchByUserName(string SearchType, string SearchString) { //判斷為查詢使用者 if (SearchType == "UserId") { //儲存查詢出來的UserId string searchUserId = null; using (Models.UserEntities db = new Models.UserEntities()) { searchUserId = (from s in db.AspNetUsers where s.UserName == SearchString select s.Id).FirstOrDefault(); } //如果有存在UserId if (!String.IsNullOrEmpty(searchUserId)) { //則將此UserId的所有訂單找出 using (Models.ShoppingCartsEntities db = new Models.ShoppingCartsEntities()) { var result = (from s in db.Orders where s.UserId == searchUserId select s).ToList(); //回傳 結果 至Index()的View return(View("Index", result)); } } else { //回傳空結果 return(View("Index", new List <Models.Order>())); } } //判斷為查詢收件人電話 else if (SearchType == "ReceiverPhone") { using (Models.ShoppingCartsEntities db = new Models.ShoppingCartsEntities()) { var result = (from s in db.Orders where s.ReceiverName == SearchString select s).ToList(); //回傳 結果 至Index()的View return(View("Index", result)); } } //判斷為查詢收件人地址 else if (SearchType == "ReceiverAddress") { using (Models.ShoppingCartsEntities db = new Models.ShoppingCartsEntities()) { var result = (from s in db.Orders where s.ReceiverAddress == SearchString select s).ToList(); //回傳 結果 至Index()的View return(View("Index", result)); } } //判斷為查詢收件人名稱 else if (SearchType == "ReceiverName") { using (Models.ShoppingCartsEntities db = new Models.ShoppingCartsEntities()) { var result = (from s in db.Orders where s.ReceiverPhone == SearchString select s).ToList(); //回傳 結果 至Index()的View return(View("Index", result)); } } else { //回傳空結果 return(View("Index", new List <Models.Order>())); } }
public ActionResult Edit(Models.ManageUser postback, HttpPostedFileBase photoFile) { ViewBag.path = TempData["id"]; //檔案名 var fileName = "photo.jpg"; //路徑 var path = Path.Combine(Server.MapPath("~/FileUploads/" + postback.Id)); //路徑加檔案名 var pathName = Path.Combine(Server.MapPath("~/FileUploads/" + postback.Id), fileName); using (Models.UserEntities db = new Models.UserEntities()) { TempData["id"] = postback.Id; if (photoFile != null) { if (!IsPicture(photoFile.FileName)) { TempData["ErrorMessage"] = "您所上傳的檔案類型並不是圖片"; return(RedirectToAction("Edit")); } if (IsImage(photoFile) == null) { TempData["ErrorMessage"] = "您所上傳的檔案內容並不是圖片"; return(RedirectToAction("Edit")); } if (photoFile.ContentLength > 0) { //資料夾不存在的話創一個 if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } //有此檔名的話把他刪了 if (System.IO.File.Exists(pathName)) { System.IO.File.Delete(pathName); } Image photo = Image.FromStream(photoFile.InputStream); photo.Save(pathName, System.Drawing.Imaging.ImageFormat.Jpeg); //photo.Save(@"D:\Newproject\ASP_Identity\ASP_Identity\FileUploads\" + id + @"\photo.jpg", System.Drawing.Imaging.ImageFormat.Jpeg); } } var result = (from s in db.AspNetUsers where s.Id == postback.Id select s).FirstOrDefault(); if (result != default(Models.AspNetUsers)) { result.Name = postback.NickName; result.Email = postback.Email; result.ImgUrl = "~/FileUploads/" + postback.Id + "/photo.jpg"; db.SaveChanges(); //設定成功訊息 TempData["ResultMessage"] = String.Format("使用者[{0}]成功編輯", postback.NickName); return(RedirectToAction("Index")); } } //設定錯誤訊息 TempData["ResultMessage"] = String.Format("使用者[{0}]不存在,請重新操作", postback.NickName); return(RedirectToAction("Index")); }