コード例 #1
0
        public string Login(User data)
        {
            //bool isPasswordCorrect = false;
            string un       = data.Name;
            string Password = data.Password;

            using (UserEntities entity = new UserEntities())
            {
                var user = entity.Users.Where(u => u.Name == un).FirstOrDefault();
                if (user != null)
                {
                    if (Password == user.Password)
                    {
                        Session["LoginID"]  = user.UserId;
                        Session["Username"] = user.Name + ' ' + user.FullName;
                        return(user.UserId.ToString());
                    }
                    else
                    {
                        return("0");
                    }
                }
                else
                {
                    return("-1");
                }
            }
        }
コード例 #2
0
        //編輯會員頁面
        public ActionResult Edit(string id)
        {
            //抓取輸入id的資料
            ManageUser result = new ManageUser();

            using (UserEntities db = new UserEntities())
            {
                result = (from s in db.AspNetUsers where s.Id == id select new ManageUser
                {
                    Id = s.Id,
                    UserName = s.UserName,
                    Email = s.Email
                }).FirstOrDefault();
            }

            //判斷此id是否有資料
            if (result != default(ManageUser))
            {
                return(View(result));
            }
            else  //如果沒有資料
            {
                TempData["ResultMessage"] = "資料有誤,請檢查";
                return(RedirectToAction("Index"));
            }
        }
コード例 #3
0
 public User Get(int id)
 {
     using (UserEntities entities = new UserEntities())
     {
         return((User)entities.Users.ToList()[entities.Users.ToList().FindIndex(user => user.id == id)]);
     }
 }
コード例 #4
0
        // POST api/userentities/
        public HttpResponseMessage Post(int EntityId, [FromBody] User value)
        {
            ServerValidationInfo vi = null;

            value.CreateDate = DateTime.Now;
            value.UpdateDate = DateTime.Now;
            if (!ModelState.IsValid)
            {
                vi = new ServerValidationInfo(ModelState);
            }
            if (vi != null && vi.ContainsError)
            {
                return(Request.CreateResponse(HttpStatusCode.BadRequest, vi));
            }
            var rel = new UserEntities()
            {
                EntityId = EntityId, User = value
            };

            context.Entry(rel).State = System.Data.EntityState.Added;
            context.SaveChanges();
            value.UserEntitieses = null;

            return(Request.CreateResponse(HttpStatusCode.OK, value));
        }
コード例 #5
0
        public int InsertPhoneCode(PhoneCodeModel model)
        {
            using (UserEntities user = new UserEntities())
            {
                try
                {
                    //新增PhoneCode
                    U_PhoneCode newcode = new U_PhoneCode()
                    {
                        Phone      = model.Phone,
                        Code       = model.Code.ToString(),
                        StartTime  = model.StartTime,
                        EndTime    = model.EndTime,
                        ClientIp   = model.ClientIp.ToString(),
                        SmsType    = model.SmsType.ToString(),
                        SmsContent = model.SmsContent.ToString()
                    };
                    user.U_PhoneCode.Add(newcode);
                    user.SaveChanges();
                }
                catch (Exception e)
                {
                    return(0);
                }
            }

            return(1);
        }
コード例 #6
0
        public PhoneCodeModel GetPhoneCode(string Phone, int smstype)
        {
            PhoneCodeModel data = new PhoneCodeModel();

            using (UserEntities user = new UserEntities())
            {
                try
                {
                    var getinfo = user.U_PhoneCode.Where(s => s.Phone == Phone && s.EndTime > DateTime.Now && s.SmsType == smstype.ToString()).FirstOrDefault();
                    if (getinfo == null)
                    {
                        return(null);
                    }
                    if (getinfo != null)
                    {
                        data.Id         = getinfo.ID.ToString();
                        data.Phone      = getinfo.Phone;
                        data.Code       = getinfo.Code;
                        data.StartTime  = Convert.ToDateTime(getinfo.StartTime);
                        data.EndTime    = Convert.ToDateTime(getinfo.EndTime);
                        data.ClientIp   = getinfo.ClientIp;
                        data.SmsType    = getinfo.SmsType;
                        data.SmsContent = getinfo.SmsContent;
                        return(data);
                    }
                }
                catch (Exception e)
                {
                    return(null);
                }
            }
            return(data);
        }
コード例 #7
0
        public ColumnGridDetailsDto GetGridInfo(string TableName)
        {
            ColumnGridDetailsDto gridDetailsDto = new ColumnGridDetailsDto();
            UserEntities         db             = new UserEntities();
            var checkUserTableExists            = db.ColumnUsersSettings.Where(x => x.GridName == TableName).ToList();

            if (checkUserTableExists.Count > 0)
            {
                gridDetailsDto.visibleColumns = db.ColumnUsersSettings.Where(x => x.GridName == TableName && x.IsVisible == true).AsEnumerable()
                                                .Select(x => new ColumnDto
                {
                    ColumnId       = x.Id,
                    ColumnText     = x.ColumnText,
                    GridName       = x.GridName,
                    ColumnFilterId = x.ColumnFilterId,
                    ColumnType     = x.ColumnType,
                    ColumnWidth    = x.ColumnWidth,
                    OrderBy        = x.ColumnOrder
                }).OrderBy(x => x.OrderBy).ToList();

                gridDetailsDto.hiddenColumns = db.ColumnUsersSettings.Where(x => x.GridName == TableName && x.IsVisible == false).AsEnumerable()
                                               .Select(x => new ColumnDto
                {
                    ColumnId       = x.Id,
                    ColumnText     = x.ColumnText,
                    GridName       = x.GridName,
                    ColumnFilterId = x.ColumnFilterId,
                    ColumnType     = x.ColumnType,
                    ColumnWidth    = x.ColumnWidth,
                    OrderBy        = x.ColumnOrder
                }).OrderBy(x => x.OrderBy).ToList();
            }
            else
            {
                gridDetailsDto.visibleColumns = db.ColumnUsersSettings.Where(x => x.GridName == TableName && x.IsVisible == true).AsEnumerable()
                                                .Select(x => new ColumnDto
                {
                    ColumnId       = x.Id,
                    ColumnText     = x.ColumnText,
                    GridName       = x.GridName,
                    ColumnFilterId = x.ColumnFilterId,
                    ColumnType     = x.ColumnType,
                    ColumnWidth    = x.ColumnWidth,
                    OrderBy        = x.ColumnOrder
                }).OrderBy(x => x.OrderBy).ToList();

                gridDetailsDto.hiddenColumns = db.ColumnUsersSettings.Where(x => x.GridName == TableName && x.IsVisible == false).AsEnumerable()
                                               .Select(x => new ColumnDto
                {
                    ColumnId       = x.Id,
                    ColumnText     = x.ColumnText,
                    GridName       = x.GridName,
                    ColumnFilterId = x.ColumnFilterId,
                    ColumnType     = x.ColumnType,
                    ColumnWidth    = x.ColumnWidth,
                    OrderBy        = x.ColumnOrder
                }).OrderBy(x => x.OrderBy).ToList();
            }
            return(gridDetailsDto);
        }
コード例 #8
0
        /// <summary>
        /// 查询设备图表名称是否存在
        /// </summary>
        public ReturnItem <RetHomeConfiguration> CheckDeviceInfoByChartName(HomeConfigurationModel parameter)
        {
            ReturnItem <RetHomeConfiguration> r = new ReturnItem <RetHomeConfiguration>();

            using (UserEntities user = new UserEntities())
            {
                try
                {
                    var OrgID      = Convert.ToInt32(parameter.OrgID);
                    var checkchart = user.U_HomeConfiguration.Where(s => s.ChartName == parameter.ChartName && s.OrgID == OrgID).FirstOrDefault();
                    if (checkchart == null)
                    {
                        r.Data = null;
                        r.Code = 1;
                        r.Msg  = "未找到设备图表";
                        return(r);
                    }
                    if (checkchart != null)
                    {
                        r.Msg  = "已存在设备图表";
                        r.Code = 0;
                    }
                }
                catch (Exception e)
                {
                    r.Msg = "内部错误请重试";
                    log.ErrorFormat("内部错误:{0},{1}", e.Message, e.StackTrace);
                    r.Code = -1;
                }
            }
            return(r);
        }
コード例 #9
0
        public void GameRestart()
        {
            UserEntities playerEntity = new UserEntities();
            Player       player1      = new Player();
            var          pl           = (from player in playerEntity.Players
                                         where player.P_State == true
                                         select player).SingleOrDefault();

            if (pl != null)
            {
                if (pl.P_Score < (int)gameBoard.GetScore)
                {
                    pl.P_Score = (int)gameBoard.GetScore;
                    mainWindowControl.lb_name_score.Text = gameBoard.GetScore.ToString();
                    playerEntity.SaveChanges();
                }
            }

            board.GetMainGrid.Clear();
            board.GetExtraGrid.Clear();
            level = 1;
            mainWindowControl.btnStartStop.Enabled = true;
            mainWindowControl.pnGameOver.Visible   = false;
            gameBoard = new GameBoard(board);
            SetLevel(level);
            Timer.Start();
        }
コード例 #10
0
        public ActionResult AddComment(int id, string Content, int rating)
        {
            //取得使用者Id
            var UserId = HttpContext.User.Identity.Name;

            var currentDateTime = DateTime.Now;

            using (UserEntities Userdb = new UserEntities())
            {
                var NickName = (from s in Userdb.AspNetUsers where s.UserName == UserId select s.Name).FirstOrDefault();
                var ImgUrl   = (from s in Userdb.AspNetUsers where s.UserName == UserId select s.ImgUrl).FirstOrDefault();
                rating = (rating <= 0) ? 1
                    :(rating >= 5) ? 5
                    : rating;


                var comment = new ProductCommet()
                {
                    ProductId  = id,
                    UserId     = NickName,
                    Content    = Content,
                    CreateDate = currentDateTime,
                    ImgUrl     = ImgUrl,
                    Stars      = rating
                };
                using (CartsEntities db = new CartsEntities())
                {
                    db.ProductCommets.Add(comment);
                    db.SaveChanges();
                }
            }
            return(RedirectToAction("Detail", new { id = id }));
        }
コード例 #11
0
ファイル: Session.cs プロジェクト: jtruty/semantria-sdk
        private object GetStub <T>(List <T> items)
        {
            object data = null;

            if (typeof(T).Equals(typeof(Configuration)))
            {
                data = new Configurations(items as List <Configuration>);
            }
            else if (typeof(T).Equals(typeof(Category)))
            {
                data = new Categories(items as List <Category>);
            }
            else if (typeof(T).Equals(typeof(String)))
            {
                data = new Blacklists(items as List <string>);
            }
            else if (typeof(T).Equals(typeof(Query)))
            {
                data = new Queries(items as List <Query>);
            }
            else if (typeof(T).Equals(typeof(UserEntity)))
            {
                data = new UserEntities(items as List <UserEntity>);
            }
            else if (typeof(T).Equals(typeof(SentimentPhrase)))
            {
                data = new SentimentPhrases(items as List <SentimentPhrase>);
            }
            else
            {
                throw new ArgumentOutOfRangeException();
            }

            return(data);
        }
コード例 #12
0
ファイル: Session.cs プロジェクト: jtruty/semantria-sdk
        public List <UserEntity> GetEntities(string configId = null)
        {
            AuthResponse      authResponse = this.Get <UserEntity>(configId);
            List <UserEntity> obj          = new List <UserEntity>();

            switch (_format)
            {
            case "json":
            {
                List <UserEntity> result = this.ProcessGetResponse <List <UserEntity> >(authResponse);
                if (result != null)
                {
                    obj = result;
                }
            }
            break;

            case "xml":
            {
                UserEntities result = this.ProcessGetResponse <UserEntities>(authResponse);
                if (result != null)
                {
                    obj = result.Data;
                }
            }
            break;

            default:
                throw new ArgumentOutOfRangeException();
            }

            return(obj);
        }
コード例 #13
0
        // PUT api/userentities/
        public HttpResponseMessage Put([FromBody] UserEntities value, string filter = null)
        {
            ServerValidationInfo vi = null;

            if (!ModelState.IsValid)
            {
                vi = new ServerValidationInfo(ModelState);
            }
            if (filter == null)
            {
                context.Entry(value).State = System.Data.EntityState.Modified;
            }
            else
            {
                var old = context.UserEntitieses.SingleOrDefault(queryBuider.CreateWhere(filter));
                old.UserId   = value.UserId;
                old.EntityId = value.EntityId;
            }
            if (vi != null && vi.ContainsError)
            {
                return(Request.CreateResponse(HttpStatusCode.BadRequest, vi));
            }
            var result = context.SaveChanges() > 0;

            return(Request.CreateResponse(HttpStatusCode.OK, result));
        }
コード例 #14
0
        public ActionResult SearchByUserName(string UserName)
        {
            //儲存查出來的UserId
            string SearchUserId = null;

            using (UserEntities db = new UserEntities())
            {
                SearchUserId = (from s in db.AspNetUsers where s.UserName == UserName select s.UserName).FirstOrDefault();
            }
            //如果有找到
            if (!string.IsNullOrEmpty(SearchUserId))
            {
                using (CartsEntities db = new CartsEntities())
                {
                    var result = (from s in db.OrderSet where s.UserId == SearchUserId select s).ToList();


                    return(View("Index", result));
                }
            }
            else
            {
                return(View("Index", new List <Order>()));
            }
        }
コード例 #15
0
        public ColumnGridDetailsDto GetDefaultGridInfo(string TableName)
        {
            UserEntities         db = new UserEntities();
            ColumnGridDetailsDto gridColumnsInfo = new ColumnGridDetailsDto();

            gridColumnsInfo.visibleColumns = db.ColumnSettings.Where(x => x.GridName == TableName && x.IsVisible == true).Select(x => new ColumnDto
            {
                ColumnId       = x.Id,
                ColumnText     = x.ColumnText,
                GridName       = x.GridName,
                ColumnFilterId = x.ColumnFilterId,
                ColumnType     = x.ColumnType,
                ColumnWidth    = x.ColumnWidth,
                OrderBy        = x.ColumnOrder
            }).OrderBy(x => x.OrderBy).ToList();

            gridColumnsInfo.hiddenColumns = db.ColumnSettings.Where(x => x.GridName == TableName && x.IsVisible == false).Select(x => new ColumnDto
            {
                ColumnId       = x.Id,
                ColumnText     = x.ColumnText,
                GridName       = x.GridName,
                ColumnFilterId = x.ColumnFilterId,
                ColumnType     = x.ColumnType,
                ColumnWidth    = x.ColumnWidth,
                OrderBy        = x.ColumnOrder
            }).OrderBy(x => x.OrderBy).ToList();
            return(gridColumnsInfo);
        }
コード例 #16
0
        public ActionResult Login(UserLogin aUserlogin)
        {
            if (ModelState.IsValid)
            {
                using (UserEntities db = new UserEntities())
                {
                    var obj =
                        db.Users.Where(a => a.UserName.Equals(aUserlogin.userName) && a.Password.Equals(aUserlogin.Password))
                        .FirstOrDefault();
                    if (obj != null)
                    {
                        Session["UserID"]   = obj.Id.ToString();
                        Session["UserName"] = obj.UserName.ToString();
                        Session["UserRole"] = obj.UserRole.ToString();
                        return(RedirectToAction("Index", "Home"));
                    }
                    else
                    {
                        //  ViewBag.Message = "invalid user name or password";
                        ModelState.AddModelError("", "Invalid User Name or Password");
                    }
                }
            }

            return(View(aUserlogin));
        }
コード例 #17
0
        public ActionResult Create([Bind(Include = "ProductId, ReturnDate, Price, TypeReturnId")] Return newReturn)
        {
            if (ModelState.IsValid)
            {
                User user = UserEntities.GetUserByName(User.Identity.Name);

                newReturn.CreateDate = DateTime.Now;
                if (user != null)
                {
                    newReturn.UserId = user.Id;
                }
                else
                {
                    return(HttpNotFound());
                }

                Product product = db.Products.Where(i => i.Id == newReturn.ProductId).FirstOrDefault();
                if (product != null)
                {
                    product.Count = product.Count + 1;
                }
                else
                {
                    return(HttpNotFound());
                }

                db.Returns.Add(newReturn);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(RedirectToAction("Create"));
        }
コード例 #18
0
        /// <summary>
        /// 删除实时监测数据位置信息
        /// </summary>
        public ReturnItem <RetRealTimeMonitor> DeleteData(RealTimeMonitorModel parameter)
        {
            ReturnItem <RetRealTimeMonitor> r = new ReturnItem <RetRealTimeMonitor>();

            using (UserEntities user = new UserEntities())
            {
                try
                {
                    var deletechart = user.U_HomeConfiguration.Where(s => s.ID == parameter.ID).FirstOrDefault();
                    if (deletechart != null)
                    {
                        var entry = user.Entry(deletechart);
                        //设置该对象的状态为删除
                        entry.State = EntityState.Deleted;
                        user.SaveChanges();
                        //保存修改
                    }
                    r.Msg  = "图表删除成功";
                    r.Code = 0;
                }
                catch (Exception e)
                {
                    r.Msg = "内部错误请重试";
                    log.ErrorFormat("内部错误:{0},{1}", e.Message, e.StackTrace);
                    r.Code = -1;
                }
            }
            return(r);
        }
コード例 #19
0
        public ActionResult ResetPassword(ResetPassword model)
        {
            var message = "";

            if (ModelState.IsValid)
            {
                using (UserEntities dc = new UserEntities())
                {
                    var user = dc.Users.Where(a => a.ResetPasswordCode == model.ResetCode).FirstOrDefault();
                    if (user != null)
                    {
                        user.Password          = model.NewPassword;
                        user.ResetPasswordCode = "";
                        dc.Configuration.ValidateOnSaveEnabled = false;
                        dc.SaveChanges();
                        message = "Password wurde geändert ";
                    }
                }
            }
            else
            {
                message = "Etwas fehlt noch !";
            }
            ViewBag.message = message;
            return(View(model));
        }
コード例 #20
0
 /// <summary>
 /// Code作废
 /// </summary>
 /// <param name="Phone"></param>
 /// <returns></returns>
 public int UpdatePhoneCode(string Phone)
 {
     using (UserEntities user = new UserEntities())
     {
         try
         {
             var getinfo = user.U_PhoneCode.Where(s => s.Phone == Phone && s.EndTime > DateTime.Now).FirstOrDefault();
             if (getinfo == null)
             {
                 return(0);
             }
             if (getinfo != null)
             {
                 getinfo.EndTime = DateTime.Now;
                 user.SaveChanges();
                 return(1);
             }
         }
         catch (Exception e)
         {
             return(0);
         }
     }
     return(0);
 }
コード例 #21
0
        public ActionResult ForgotPassword(string Email)
        {
            //Überprüfen Email
            // Gererate Reset Password link
            // send Email
            string message = "";
            bool   status  = false;

            using (UserEntities db = new UserEntities())
            {
                var account = db.Users.Where(a => a.Email == Email).FirstOrDefault();
                if (account != null)
                {
                    // senden Email für Reset Password
                    string resetCode = Guid.NewGuid().ToString();
                    SendVerificationLinkEmail(account.Email, resetCode);
                    account.ResetPasswordCode = resetCode;
                    db.Configuration.ValidateOnSaveEnabled = false;
                    db.SaveChanges();
                    message = " Die link für neues Password wurde an Ihre Email gesendet";
                }
                else
                {
                    message = "Konto wurde nicht gefunden !";
                }
            }
            return(View());
        }
コード例 #22
0
 public IEnumerable <User> Get()
 {
     using (UserEntities entities = new UserEntities())
     {
         return(entities.Users.ToList());
     }
 }
コード例 #23
0
        public AddUserResultCode AddUser(string emailId, string password, string firstName, string lastName, string designation, int roleId, string profilePicPath, bool enabled)
        {
            AddUserResultCode addUserResult = AddUserResultCode.Other;

            UserEntities user = DAO.GetUser(emailId);

            if (user.EmailId != null)
            {
                addUserResult = AddUserResultCode.UserAlreadyExists;
            }
            else
            {
                user                = new UserEntities();
                user.EmailId        = emailId.Trim();
                user.Password       = new HashHelper().CreateHashWithSalt(password);
                user.FirstName      = firstName.Trim();
                user.LastName       = lastName.Trim();
                user.Designation    = designation.Trim();
                user.RoleId         = roleId;
                user.ProfilePicPath = profilePicPath;
                user.Enabled        = enabled;
                if (DAO.AddUser(user))
                {
                    addUserResult = AddUserResultCode.Success;
                }
            }
            return(addUserResult);
        }
コード例 #24
0
        public ActionResult Edit(string id, ManageUser editData)
        {
            if (ModelState.IsValid)
            {
                using (UserEntities db = new UserEntities())
                {
                    var data = db.AspNetUsers.FirstOrDefault(p => p.Id == id);

                    if (data != default(AspNetUsers))
                    {
                        data.UserName = editData.UserName;
                        data.Email    = editData.Email;
                        db.SaveChanges();

                        TempData["ResultMessage"] = $"使用者{editData.UserName}編輯成功!";

                        return(RedirectToAction("Index"));
                    }
                }
            }

            TempData["ResultMessage"] = $"資料輸入有誤,請重新輸入!";

            return(View(editData));
        }
コード例 #25
0
        public ActionResult Forgot(SignUp model)
        {
            var    context          = new UserEntities();
            int    portNumber       = 587;
            bool   enableSSL        = true;
            string emailFromAddress = "*****@*****.**"; //Sender Email Address
            string emailPassword    = "******";             //Sender Password
            string smtpAddress      = "smtp.gmail.com";
            string emailToAddress   = model.Email;             //Receiver Email Address
            var    password         = context.Users.Where(x => x.Email == model.Email).FirstOrDefault();

            if (password == null)
            {
                ModelState.AddModelError("", "You Enter Wrong Email");
            }
            string subject = "Hello " + password.UserName;
            string body    = "Email : " + emailToAddress + "\n"
                             + "password : "******"login"));
        }
コード例 #26
0
            public UserEntities withOutPassword()
            {
                UserEntities temp = this;

                temp.account.Password = null;
                return(temp);
            }
コード例 #27
0
 ///作废TokenId用于注销登录
 public ReturnItem <bool> DisableTokenId(DisableTokenIdParameter parameter)
 {
     if (parameter.TokenId == null || parameter.TokenId == "")
     {
         return(new ReturnItem <bool>()
         {
             Code = -1, Msg = "无TokenId", Data = false
         });
     }
     if (parameter.UserId == null || parameter.UserId == "")
     {
         return(new ReturnItem <bool>()
         {
             Code = -1, Msg = "无user", Data = false
         });
     }
     using (UserEntities user = new UserEntities())
     {
         long temp = Convert.ToInt32(parameter.UserId);
         user.U_Token.Where(t => t.TokenID == parameter.TokenId && !t.IsDisabled == true && t.UserID == temp).ToList().ForEach(t => { t.IsDisabled = true; t.DisabledTime = DateTime.Now; });
         user.SaveChanges();
         if (CustomConfigParam.IsUseRedis)
         {
             new RedisClient(CustomConfigParam.RedisDbNumber).KeyDelete("Token:" + parameter.TokenId.Replace("-", ""));
         }
         return(new ReturnItem <bool>()
         {
             Code = 0, Msg = "欢迎再来", Data = true
         });
     }
 }
コード例 #28
0
        public ActionResult Delete(string id)
        {
            using (UserEntities db = new UserEntities())
            {
                //抓取對應id的資料
                AspNetUsers result = (from s in db.AspNetUsers where s.Id == id select s).FirstOrDefault();

                if (result != default(AspNetUsers)) //判斷是否有資料
                {
                    db.AspNetUsers.Remove(result);

                    //儲存變更
                    db.SaveChanges();

                    //設定成功訊息
                    TempData["ResultMessage"] = String.Format("會員[{0}]刪除成功", result.UserName);

                    //導向Index頁面
                    return(RedirectToAction("Index"));
                }
                else
                {
                    TempData["ResultMessage"] = "指定資料不存在";

                    //導向Index頁面
                    return(RedirectToAction("Index"));
                }
            }
        }
コード例 #29
0
 public ActionResult Manage(ManageModel u)
 {
     if (ModelState.IsValid)
     {
         if (Session["LogedUserID"] != null)
         {
             using (UserEntities dc = new UserEntities())
             {
                 u.password = HashPassword(u.password);
                 if (u.password.ToString().Equals((String)Session["LogedPassword"]))
                 {
                     int id = Convert.ToInt32(Session["LogedUserId"]);
                     var oldUser = dc.Users.Where(model => model.id.Equals(id)).FirstOrDefault();
                     u.NewPassword = HashPassword(u.NewPassword);
                     oldUser.password = u.NewPassword.ToString();
                     dc.SaveChanges();
                     ModelState.Clear();
                     u = null;
                     ViewBag.Message = "Your password has been updated.";
                     return View();
                 }
                 else
                 {
                     ViewBag.Message = "Wrong password for user " + Session["LogedUsername"];
                 }
             }
         }
         else
         {
             return RedirectToAction("Index");
         }
     }
     return View(u);
 }
コード例 #30
0
        [HttpPost] //刪除方法為POST
        public ActionResult Delete(string id)
        {
            using (UserEntities db = new UserEntities())
            {
                //ProductSet內的Id = 輸入的Id 的值
                var result = (from s in db.AspNetUsers
                              where s.Id == id
                              select s).FirstOrDefault();

                if (result != default(AspNetUsers)) //如果Result有抓到資料
                {
                    db.AspNetUsers.Remove(result);
                    db.SaveChanges();


                    TempData["DeleteMessage"] = String.Format("會員{0}已刪除", result.UserName);
                    return(RedirectToAction("Index")); //回傳Result的View
                }
                else
                {
                    TempData["DeleteMessage"] = "資料有誤,無法刪除,請重新操作";
                    return(RedirectToAction("Index"));
                }
            }
        }
コード例 #31
0
ファイル: PatialClass.cs プロジェクト: apple13121/Shop
        //取得訂單中的 使用者暱稱
        public string GetUserName()
        {
            //使用Order類別中的UserId到AspNetUsers資料表中搜尋出UserName
            using (Models.UserEntities db = new UserEntities())
            {
                var result = (from s in db.AspNetUsers
                              where s.Id == this.UserId
                              select s.UserName).FirstOrDefault();

                //回傳找到的UserName
                return result;
            }
        }