示例#1
0
        public ActionResult Edit(int id)
        {
            UserWeb userWeb = new UserWeb();

            Library.User user = userWeb.Users.Single(g => g.Id == id);
            return(View(user));
        }
示例#2
0
        public ActionResult Index()
        {
            UserWeb             userWeb = new UserWeb();
            List <Library.User> users   = userWeb.Users.ToList();

            return(View(users));
        }
示例#3
0
 ///<summary>Inserts one UserWeb into the database.  Returns the new priKey.</summary>
 public static long Insert(UserWeb userWeb)
 {
     if (DataConnection.DBtype == DatabaseType.Oracle)
     {
         userWeb.UserWebNum = DbHelper.GetNextOracleKey("userweb", "UserWebNum");
         int loopcount = 0;
         while (loopcount < 100)
         {
             try {
                 return(Insert(userWeb, true));
             }
             catch (Oracle.ManagedDataAccess.Client.OracleException ex) {
                 if (ex.Number == 1 && ex.Message.ToLower().Contains("unique constraint") && ex.Message.ToLower().Contains("violated"))
                 {
                     userWeb.UserWebNum++;
                     loopcount++;
                 }
                 else
                 {
                     throw ex;
                 }
             }
         }
         throw new ApplicationException("Insert failed.  Could not generate primary key.");
     }
     else
     {
         return(Insert(userWeb, false));
     }
 }
 public ActionResult ExistingUser(UserWeb user)
 {
     try
     {
         var libUser   = MapperWeb.Map(user);
         var checkUser = Repo.FindUserId(libUser.FirstName, libUser.LastName);
         if (checkUser > 0)
         {
             TempData["id"]        = checkUser;
             TempData["FirstName"] = libUser.FirstName;
             TempData["MID"]       = Repo.FindManagerFlagById(checkUser);
             return(RedirectToAction("Index", "Home"));
         }
         else
         {
             ModelState.AddModelError(string.Empty, "User doesn't exist. Please login as a new user or try again");
             return(View(user));
         }
         // TODO: Add insert logic
     }
     catch
     {
         return(View());
     }
 }
示例#5
0
 public IEnumerable <UserWeb> GetAll()
 {
     using (var con = new SqlConnection(_con_str))
     {
         con.Open();
         var cmd = new SqlCommand("procedure_GetAllWebUsers", con);
         cmd.CommandType = CommandType.StoredProcedure;
         var            res      = cmd.ExecuteReader();
         List <UserWeb> usersWeb = new List <UserWeb>();
         bool           next     = res.Read();
         while (next)
         {
             var webUser = new UserWeb
             {
                 Login    = (string)res["Login"],
                 Password = (string)res["Password"],
                 Roles    = new string[] { }
             };
             while ((string)res["Login"] == webUser.Login)
             {
                 webUser.Roles = new string[] { (string)res["Name"] };
                 if (!res.Read())
                 {
                     next = false;
                     break;
                 }
             }
             usersWeb.Add(webUser);
         }
         return(usersWeb);
     }
 }
示例#6
0
 public bool Add(UserWeb user)
 {
     using (var connect = new SqlConnection(_con_str))
     {
         connect.Open();
         var cmd = new SqlCommand("procedure_InsertWebUser", connect);
         cmd.CommandType = CommandType.StoredProcedure;
         var LoginParam = new SqlParameter()
         {
             DbType        = DbType.String,
             ParameterName = "@Login",
             Value         = user.Login,
         };
         var PasswordParam = new SqlParameter()
         {
             DbType        = System.Data.DbType.String,
             ParameterName = "@Password",
             Value         = user.Password,
         };
         cmd.Parameters.Add(LoginParam);
         cmd.Parameters.Add(PasswordParam);
         cmd.ExecuteNonQuery();
     }
     return(true);
 }
示例#7
0
        public ActionResult Create(Library.User user, string UserAccount)
        {
            UserWeb userWeb = new UserWeb();


            if (!ModelState.IsValid)
            {
                return(View("Create"));
            }

            bool isSuccess = userWeb.AddUser(user);

            if (isSuccess)
            {
                ViewBag.Msg = "帳號已註冊過";
                return(View());
            }
            else
            {
                byte UserClass = 0;

                if (Session["Id"] != null)
                {
                    byte.TryParse(Session["UserClass"].ToString(), out UserClass);
                }
                if (UserClass == 2)
                {
                    return(RedirectToAction("Index", "User"));
                }
                else
                {
                    return(RedirectToAction("Login", "User"));
                }
            }
        }
示例#8
0
        public IActionResult Edit(UserWeb user, string editAction)
        {
            if (this.ModelState.IsValid && user != null)
            {
                this.TempData["editResult"] = "Edit Fail";
                if (editAction == "AddNew")
                {
                    this.logic.AddUser(user.UserFullName, user.UserEmail, user.UserUsername, user.UserPassword, user.UserType);
                    this.TempData["editResult"] = "Edit OK";
                }
                else
                {
                    if (this.logic.ChangeUser(user.UserId, user.UserFullName, user.UserEmail, user.UserUsername, user.UserPassword, user.UserType))
                    {
                        this.TempData["editResult"] = "Edit OK";
                    }
                }

                return(this.RedirectToAction(nameof(this.Index)));
            }
            else
            {
                this.ViewData["editAction"] = "Edit";
                this.vm.EditedUser          = user;
                return(this.View("UsersIndex", this.vm));
            }
        }
        public ActionResult NewUser(UserWeb user)
        {
            try
            {
                var libUser   = MapperWeb.Map(user);
                var checkUser = Repo.FindUserId(libUser.FirstName, libUser.LastName);
                if (checkUser == 0)
                {
                    Repo.AddUser(libUser);
                    Repo.Save();
                    checkUser             = Repo.FindUserId(libUser.FirstName, libUser.LastName);
                    TempData["id"]        = checkUser;
                    TempData["FirstName"] = libUser.FirstName;
                    TempData["MID"]       = false;

                    return(RedirectToAction("Index", "Home"));
                }
                else
                {
                    ModelState.AddModelError(string.Empty, "User already exists.");
                    return(View(user));
                }
                // TODO: Add insert logic
            }
            catch
            {
                return(View(user));
            }
        }
示例#10
0
        public ActionResult Delete(int id)
        {
            UserWeb userWeb = new UserWeb();

            userWeb.DeleteUser(id);
            return(RedirectToAction("Index"));
        }
示例#11
0
 private void FormPatientPortal_Load(object sender, EventArgs e)
 {
     _userWebCur = UserWebs.GetByFKeyAndType(_patCur.PatNum, UserWebFKeyType.PatientPortal);
     if (_userWebCur == null)
     {
         _isNew               = true;
         _userWebCur          = new UserWeb();
         _userWebCur.UserName = UserWebs.CreateUserNameFromPat(_patCur, UserWebFKeyType.PatientPortal);
         _userWebCur.FKey     = _patCur.PatNum;
         _userWebCur.FKeyType = UserWebFKeyType.PatientPortal;
         _userWebCur.RequireUserNameChange = true;
         _userWebCur.Password = "";
         UserWebs.Insert(_userWebCur);
     }
     _userWebOld             = _userWebCur.Copy();
     textOnlineUsername.Text = _userWebCur.UserName;
     textOnlinePassword.Text = "";
     if (_userWebCur.Password != "")           //if a password was already filled in
     {
         butGiveAccess.Text = "Remove Online Access";
         //We do not want to show the password hash that is stored in the database so we will fill the online password with asterisks.
         textOnlinePassword.Text     = "********";
         textOnlinePassword.ReadOnly = false;
         textOnlineUsername.ReadOnly = false;
     }
     textPatientPortalURL.Text = PrefC.GetString(PrefName.PatientPortalURL);
 }
示例#12
0
        // GET: User
        public ActionResult Index()
        {
            UserWeb user = new UserWeb();

            //var libUsers = Repo.Get(search);
            //var webRests = libRests.Select(x => new Restaurant
            return(View(user));
        }
示例#13
0
 ///<summary>Inserts many UserWebs into the database.  Provides option to use the existing priKey.</summary>
 public static void InsertMany(List <UserWeb> listUserWebs)
 {
     if (DataConnection.DBtype == DatabaseType.Oracle || PrefC.RandomKeys)
     {
         foreach (UserWeb userWeb in listUserWebs)
         {
             Insert(userWeb);
         }
     }
     else
     {
         StringBuilder sbCommands = null;
         int           index      = 0;
         while (index < listUserWebs.Count)
         {
             UserWeb       userWeb  = listUserWebs[index];
             StringBuilder sbRow    = new StringBuilder("(");
             bool          hasComma = false;
             if (sbCommands == null)
             {
                 sbCommands = new StringBuilder();
                 sbCommands.Append("INSERT INTO userweb (");
                 sbCommands.Append("FKey,FKeyType,UserName,Password,PasswordResetCode,RequireUserNameChange,DateTimeLastLogin,RequirePasswordChange) VALUES ");
             }
             else
             {
                 hasComma = true;
             }
             sbRow.Append(POut.Long(userWeb.FKey)); sbRow.Append(",");
             sbRow.Append(POut.Int((int)userWeb.FKeyType)); sbRow.Append(",");
             sbRow.Append("'" + POut.String(userWeb.UserName) + "'"); sbRow.Append(",");
             sbRow.Append("'" + POut.String(userWeb.Password) + "'"); sbRow.Append(",");
             sbRow.Append("'" + POut.String(userWeb.PasswordResetCode) + "'"); sbRow.Append(",");
             sbRow.Append(POut.Bool(userWeb.RequireUserNameChange)); sbRow.Append(",");
             sbRow.Append(POut.DateT(userWeb.DateTimeLastLogin)); sbRow.Append(",");
             sbRow.Append(POut.Bool(userWeb.RequirePasswordChange)); sbRow.Append(")");
             if (sbCommands.Length + sbRow.Length + 1 > TableBase.MaxAllowedPacketCount)
             {
                 Db.NonQ(sbCommands.ToString());
                 sbCommands = null;
             }
             else
             {
                 if (hasComma)
                 {
                     sbCommands.Append(",");
                 }
                 sbCommands.Append(sbRow.ToString());
                 if (index == listUserWebs.Count - 1)
                 {
                     Db.NonQ(sbCommands.ToString());
                 }
                 index++;
             }
         }
     }
 }
示例#14
0
        public ActionResult Create(Library.User user)
        {
            if (!ModelState.IsValid)
            {
                return(View("Create"));
            }

            UserWeb userWeb = new UserWeb();

            userWeb.AddUser(user);
            return(RedirectToAction("Index"));
        }
示例#15
0
        public UserWeb AddUser(string login, string password)
        {
            UserWeb user = new UserWeb {
                Login = login, Password = password
            };

            if (_userWebDao.Add(user))
            {
                return(user);
            }
            throw new ArgumentException("Error. User can't be added.");
        }
示例#16
0
        public async Task <ActionResult <UserWeb> > FindAllUsersWeb(int limit)
        {
            UserWeb userWeb = new UserWeb();

            userWeb.Users = _userBuilder.ListBuild(_adminUseCases.FindAllUsers(limit));
            foreach (var user in userWeb.Users)
            {
                user.Provinces = _provinceBuilder.Build(_adminUseCases.FindProvinceById(user.ProvincesId));
            }
            userWeb.Count = _adminUseCases.UsersCount();

            return(userWeb);
        }
示例#17
0
        public async Task <ActionResult <UserWeb> > UserSearchByUserName(string username, int limit)
        {
            UserWeb userWeb = new UserWeb();

            userWeb.Users = _userBuilder.ListBuild(_adminUseCases.UserSearchByUserName(username, limit));
            foreach (var user in userWeb.Users)
            {
                user.Provinces = _provinceBuilder.Build(_adminUseCases.FindProvinceById(user.ProvincesId));
            }
            userWeb.Count = _adminUseCases.UserSearchByUserNameCount(username);

            return(userWeb);
        }
示例#18
0
        public async Task <IActionResult> Index(int id, string passw)
        {
            var findUser = new UserWeb().GetUsers().FirstOrDefault(x => x.Id == id && x.Password == passw);

            if (findUser == null)
            {
                return(View());
            }

            await AddClaimsLogin(findUser);

            return(RedirectToAction("Index", "Home"));
        }
示例#19
0
        ///<summary>Updates one UserWeb in the database.</summary>
        public static void Update(UserWeb userWeb)
        {
            string command = "UPDATE userweb SET "
                             + "FKey                 =  " + POut.Long(userWeb.FKey) + ", "
                             + "FKeyType             =  " + POut.Int((int)userWeb.FKeyType) + ", "
                             + "UserName             = '******', "
                             + "Password             = '******', "
                             + "PasswordResetCode    = '" + POut.String(userWeb.PasswordResetCode) + "', "
                             + "RequireUserNameChange=  " + POut.Bool(userWeb.RequireUserNameChange) + ", "
                             + "DateTimeLastLogin    =  "******", "
                             + "RequirePasswordChange=  " + POut.Bool(userWeb.RequirePasswordChange) + " "
                             + "WHERE UserWebNum = " + POut.Long(userWeb.UserWebNum);

            Db.NonQ(command);
        }
示例#20
0
 ///<summary>Inserts one UserWeb into the database.  Returns the new priKey.  Doesn't use the cache.</summary>
 public static long InsertNoCache(UserWeb userWeb)
 {
     if (DataConnection.DBtype == DatabaseType.MySql)
     {
         return(InsertNoCache(userWeb, false));
     }
     else
     {
         if (DataConnection.DBtype == DatabaseType.Oracle)
         {
             userWeb.UserWebNum = DbHelper.GetNextOracleKey("userweb", "UserWebNum");                  //Cacheless method
         }
         return(InsertNoCache(userWeb, true));
     }
 }
        public ApiResult ModOneCar(UserWeb user)
        {
            if (user == null)
            {
                return(new ApiResult()
                {
                    OperationResult = false
                });
            }

            return(new ApiResult()
            {
                OperationResult = this.logic.ChangeUser(user.UserId, user.UserFullName, user.UserEmail, user.UserUsername, user.UserPassword, user.UserType)
            });
        }
示例#22
0
        public ActionResult Edit([Bind(Include = "UserAccount, UserClass, Email, Password, UserName")] Library.User user)
        {
            UserWeb userWeb = new UserWeb();

            user.Id = userWeb.Users.Single(g => g.Id == user.Id).Id;

            if (!ModelState.IsValid)
            {
                return(View("Edit", user));
            }

            userWeb.SaveUser(user);

            return(RedirectToAction("Index"));
        }
示例#23
0
        public ActionResult Usersearchpage(string myTextBox)
        {
            User   w = Lur.Unub(myTextBox);
            string f = Lur.Unub(myTextBox).username;

            var otm = new UserWeb
            {
                Firstname         = w.Firstname,
                Lastname          = w.Lastname,
                defaultlocationID = w.defaultlocationID,
                userorderhistory  = w.userorderhistory,
                username          = w.username
            };


            return(View(nameof(Details), otm));
        }
示例#24
0
        private async Task AddClaimsLogin(UserWeb user)
        {
            var identity = new ClaimsIdentity(CookieAuthenticationDefaults.AuthenticationScheme, ClaimTypes.Name, ClaimTypes.Role);

            // Adds the values to the claims we create.
            identity.AddClaim(new Claim(IdentityExtensions.CustomClaimTypes.Id, user.Id.ToString()));
            identity.AddClaim(new Claim(IdentityExtensions.CustomClaimTypes.Name, user.Name));
            identity.AddClaim(new Claim(IdentityExtensions.CustomClaimTypes.Job, user.Job));

            // Creates the context of user authentication.
            var principal = new ClaimsPrincipal(identity);
            await HttpContext.SignInAsync(CookieAuthenticationDefaults.AuthenticationScheme, principal,
                                          new AuthenticationProperties
            {
                IsPersistent = true
            });
        }
示例#25
0
 public bool update(UserWeb entity)
 {
     try
     {
         var user = db.UserWebs.Find(entity.ID);
         user.Name         = entity.Name;
         user.Address      = entity.Address;
         user.Email        = entity.Email;
         user.ModifiedBy   = entity.ModifiedBy;
         user.ModifiedDate = DateTime.Now;
         db.SaveChanges();
         return(true);
     }
     catch (Exception e)
     {
         return(false);
     }
 }
示例#26
0
        public static UserWeb CreateUserWeb(long fKey, UserWebFKeyType fKeyType, string userName = "", string password = "", bool requireUserNameChange = false,
                                            bool requirePasswordChange = false, string passwordResetCode = "", DateTime dateTimeLastLogin = default(DateTime))
        {
            UserWeb userWeb = new UserWeb()
            {
                IsNew    = true,
                FKey     = fKey,
                FKeyType = fKeyType,
                UserName = userName,
                Password = password,
                RequireUserNameChange = requireUserNameChange,
                RequirePasswordChange = requirePasswordChange,
                PasswordResetCode     = passwordResetCode,
                DateTimeLastLogin     = dateTimeLastLogin,
            };

            UserWebs.Insert(userWeb);
            return(userWeb);
        }
示例#27
0
        ///<summary>Converts a DataTable to a list of objects.</summary>
        public static List <UserWeb> TableToList(DataTable table)
        {
            List <UserWeb> retVal = new List <UserWeb>();
            UserWeb        userWeb;

            foreach (DataRow row in table.Rows)
            {
                userWeb                       = new UserWeb();
                userWeb.UserWebNum            = PIn.Long(row["UserWebNum"].ToString());
                userWeb.FKey                  = PIn.Long(row["FKey"].ToString());
                userWeb.FKeyType              = (OpenDentBusiness.UserWebFKeyType)PIn.Int(row["FKeyType"].ToString());
                userWeb.UserName              = PIn.String(row["UserName"].ToString());
                userWeb.Password              = PIn.String(row["Password"].ToString());
                userWeb.PasswordResetCode     = PIn.String(row["PasswordResetCode"].ToString());
                userWeb.RequireUserNameChange = PIn.Bool(row["RequireUserNameChange"].ToString());
                userWeb.DateTimeLastLogin     = PIn.DateT(row["DateTimeLastLogin"].ToString());
                userWeb.RequirePasswordChange = PIn.Bool(row["RequirePasswordChange"].ToString());
                retVal.Add(userWeb);
            }
            return(retVal);
        }
        public ApiResult AddOneUser(UserWeb newUser)
        {
            bool success = true;

            try
            {
                if (newUser != null)
                {
                    this.logic.AddUser(newUser.UserFullName, newUser.UserEmail, newUser.UserUsername, newUser.UserPassword, newUser.UserType);
                }
            }
            catch (ArgumentException)
            {
                success = false;
            }

            return(new ApiResult()
            {
                OperationResult = success
            });
        }
        public ActionResult Register(RegisterUserViewModel userView)
        {
            if (!ModelState.IsValid)
            {
                return(View(userView));
            }

            UserWeb user = new UserWeb
            {
                Email    = userView.Email,
                Name     = userView.FirstName,
                LastName = userView.LastName,
                Password = userView.Password
            };
            var validUser = _unit.UserWeb.CreateUser(user);

            if (validUser == null)
            {
                ModelState.AddModelError("Error", "No se pudo crear el usuario");
                return(View(user));
            }
            /*sign in*/

            /*
             * var identity = new ClaimsIdentity(new[]
             * {
             *  new Claim(ClaimTypes.Email, validUser.Email),
             *  new Claim(ClaimTypes.Name, $"{validUser.FirstName} {validUser.LastName}"),
             *  new Claim(ClaimTypes.NameIdentifier, validUser.Email)
             * },
             * "ApplicationCookie");
             *
             * var context = Request.GetOwinContext();
             * var authManager = context.Authentication;
             * authManager.SignIn(identity);
             */

            /*redireccionar al login*/
            return(RedirectToAction("Login", "Account"));
        }
示例#30
0
 public ActionResult ByUser(UserWeb user)
 {
     try
     {
         var libUser   = MapperWeb.Map(user);
         var checkUser = Repo.FindUserId(libUser.FirstName, libUser.LastName);
         if (checkUser > 0)
         {
             return(RedirectToAction("SearchResultsUser", "OrderHistory", new { searchID = checkUser, searchOption = user.SearchOption })); //add search option
         }
         else
         {
             ModelState.AddModelError(string.Empty, "User doesn't exist. Please retype your search");
             return(View(user));
         }
         // TODO: Add insert logic
     }
     catch
     {
         return(View());
     }
 }