Exemple #1
0
 public UserDto(User user)
 {
     Login = user.Login;
     Name = user.Name;
     Password = "******";
     Email = user.Email;
     Phone = user.Phone;
 }
Exemple #2
0
        public static int UpdateUserById(User user)
        {
            try
            {
                string comText = "update [tUsers] set tUsers.uname='" + user.UName + "', tUsers.upwd='" + user.UPwd + "', tUsers.utext='" + user.UText + "', tUsers.ulevel='" + user.ULevel + "', tUsers.userupdate='" + user.UserUpdate + "' where tUsers.userid=" + user.UserId;
                int rlt = OleDbHelper.ExecuteNonQuery(comText);
                return rlt;

            }
            catch (Exception e)
            {
                throw e;
            }
        }
Exemple #3
0
        public static int AddUser(User user)
        {
            try
            {
                string comText = "insert into [tUsers] (uname ,upwd ,utext ,ulevel) values ( '"
                    + user.UName + "', '" + user.UPwd + "', '" + user.UText + "', " + user.ULevel + ")";
                int rlt = OleDbHelper.ExecuteNonQuery(comText);
                return rlt;

            }
            catch (Exception e)
            {
                throw e;
            }
        }
        public void Create(UserDTO user)
        {
            User u = new User
            {
                Email = user.Email,
                Password = user.Password,
                RoleId = user.RoleId
            };
            Database.Users.Create(u);
            Database.Save();

            DAL.Entities.Profile prof = new DAL.Entities.Profile
            {
                 FirstName = "Undefined",
                 LastName = "Undefined",
                 Age = 0,
                 CreationDate = DateTime.Now,
                 UserId = u.Id
            };
            Database.Profiles.Create(prof);
            Database.Save();
        }
Exemple #5
0
        protected void GridViewUsers_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            if (e.CommandName == "AddUser")
            {
                if (GridViewUsers.FooterRow != null)
                {
                    DAL.Entities.User user = new User();
                    user.UName = (GridViewUsers.FooterRow.FindControl("TextBoxUserNameFooter") as TextBox).Text.Trim();
                    user.UPwd = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile((GridViewUsers.FooterRow.FindControl("TextBoxPwdFooter") as TextBox).Text.Trim(), "MD5");
                    user.ULevel = Convert.ToInt32((GridViewUsers.FooterRow.FindControl("ddlUlevelFooter") as DropDownList).SelectedValue);
                    user.UText = (GridViewUsers.FooterRow.FindControl("textBoxUtextFooter") as TextBox).Text;
                    user.UserUpdate = DateTime.Now;
                    try
                    {
                        int rlt = DalHandler.AddUser(user);
                        if (rlt == 1)
                        {
                            RefreshCacheUsers(0, user);
                            BindGridView(true);
                        }
                        else
                        {
                            //...
                        }
                    }
                    catch (Exception ex)
                    {
                        errorPlace.InnerHtml = ex.Message;
                    }
                }
            }
            else if (e.CommandName == "DeleteUser")
            {
                if (e.CommandArgument != null)
                {
                    int userId = Convert.ToInt32(e.CommandArgument);
                    try
                    {
                        int rlt = DalHandler.DeleteUserById(userId);
                        if (rlt == 1)
                        {
                            DataTable dt = Cache["UsersCache"] as DataTable;
                            foreach (DataRow row in dt.Rows)
                            {
                                if (row["userid"].ToString().Equals(userId.ToString(), StringComparison.OrdinalIgnoreCase))
                                {
                                    row.Delete();
                                    break;
                                }
                            }
                            BindGridView(false);
                        }
                    }
                    catch (Exception ex)
                    {
                        errorPlace.InnerText = ex.Message;
                    }
                }
            }

        }
Exemple #6
0
 protected void GridViewUsers_RowUpdating(object sender, GridViewUpdateEventArgs e)
 {
     try
     {
         int rowIndex = e.RowIndex;
         GridViewRow row = GridViewUsers.Rows[rowIndex];
         HiddenField hiddfield = row.FindControl("userIdHiddenField") as HiddenField;
         if (hiddfield != null && !string.IsNullOrEmpty(hiddfield.Value))
         {
             DAL.Entities.User user = new User();
             user.UserId = Convert.ToInt32(hiddfield.Value);
             user.UName = (row.Cells[1].Controls[1] as TextBox).Text;
             user.UPwd = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile((row.Cells[2].Controls[1] as TextBox).Text, "MD5");
             user.ULevel = Convert.ToInt32((row.Cells[4].Controls[1] as DropDownList).SelectedValue);
             user.UText = (row.Cells[3].Controls[1] as TextBox).Text;
             user.UserUpdate = DateTime.Now;
             int rlt = DalHandler.UpdateUserById(user);
             if (rlt == 1)
             {
                 RefreshCacheUsers(rowIndex, user);
                 GridViewUsers.EditIndex = -1;
                 BindGridView(true);
             }
         }
         else
         {
             BindGridView(true);
         }
     }
     catch (Exception ex)
     {
         errorPlace.InnerText = ex.Message;
     }
 }
 public ActionResult Login(User user)
 {
     return View(user);
 }