Example #1
0
        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"));
        }
Example #2
0
        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");
            }
        }
Example #3
0
        // 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());
             */
        }
Example #4
0
        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>()));
            }
        }
Example #5
0
        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"));
        }
Example #6
0
        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>()));
        }
Example #9
0
        //取得訂單中的使用者暱稱
        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());
 }
Example #11
0
        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));
            }
        }
Example #12
0
 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));
     }
 }
Example #14
0
 // 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"));
 }
Example #17
0
        //
        // 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"));
 }
Example #21
0
 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");
 }
Example #22
0
 //編輯會員資訊
 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>()));
            }
        }
Example #24
0
 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"));
 }
Example #25
0
        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));
                  } }
            }
        }
Example #27
0
 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));
        }
Example #29
0
        //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>()));
            }
        }
Example #30
0
        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"));
        }