private void BTN_Filtrar1_Click(object sender, EventArgs e) { String name = null, userName = null, setor = null; UserIsactive status = 0; if (TXT_Filter_Name.Text.ToString() != "") { name = TXT_Filter_Name.Text.ToString(); } if (TXT_Filter_User_Name.Text.ToString() != "") { userName = TXT_Filter_User_Name.Text.ToString(); } if (TXT_filter_Setor.Text.ToString() != "") { setor = TXT_filter_Setor.Text.ToString(); } status = (UserIsactive)Enum.Parse(typeof(UserIsactive), CBX_Filter_Status.Text.ToString()); //usuarios = ObterUsers.GetUsuarios(userName, name, setor, status); //GRID_USERS_VIEW.DataSource = usuarios; GRID_USERS_VIEW.DataSource = manipulaUsuarios.GetUsers(); }
public PageUserEditandAdd(bool IsNew, String SelectUserName, UserIdioma UserLoginIdioma, bool Install) { InitializeComponent(); isNew = IsNew; bool install = Install; CBX_Status.DataSource = Enum.GetValues(typeof(UserIsactive)); CBX_TYPE.DataSource = Enum.GetValues(typeof(UserType)); userLoginIdioma = UserLoginIdioma; if (!isNew)//Editar usuario { TXT_Usuario.Enabled = false; Entities.User user = manipulaUsuarios.GetByUsername(SelectUserName); TXT_Nome.Text = user.Name.ToString(); TXT_Email.Text = user.Email.ToString(); TXT_CPF.Text = user.CPF.ToString(); TXT_Setor.Text = user.Setor.ToString(); TXT_Usuario.Text = user.UserName.ToString(); CBX_TYPE.Text = user.Type.ToString(); CBX_Status.Text = user.IsActive.ToString(); } if(Install) { UserIsactive userStatus = UserIsactive.Ativo; CBX_Status.DataSource = Enum.GetValues(typeof(UserIsactive)); CBX_Status.Text = userStatus.ToString(); CBX_Status.Enabled = false; UserType userType = UserType.Administrador; CBX_TYPE.DataSource = Enum.GetValues(typeof(UserType)); CBX_TYPE.Text = userType.ToString(); CBX_TYPE.Enabled = false; } }
private void BTN_UserSalvar_Click(object sender, EventArgs e) { //captura textos dos campos name = TXT_Nome.Text.ToString(); email = TXT_Email.Text.ToString(); cPF = TXT_CPF.Text.ToString().Replace(",", "."); setor = TXT_Setor.Text.ToString(); userName = TXT_Usuario.Text.ToString(); password = TXT_Password.Text.ToString(); confirmPassword = TXT_Confirm_Pass.Text.ToString(); type = (UserType)Enum.Parse(typeof(UserType), CBX_TYPE.Text.ToString()); isActive = (UserIsactive)Enum.Parse(typeof(UserIsactive), CBX_Status.Text.ToString()); String maskCPF = TXT_CPF.Text.ToString().Replace(".", "").Replace("-", "").Replace(" ", "").Replace(",", ""); //valida campos obrigatorio e valida seleção comboboxs if (name == "" || maskCPF == "" || setor == "" || userName == "" || email == "" || isActive == 0 || type == 0 || maskCPF.Length < 11) { if (name == "") TXT_Nome.BackColor = Color.OrangeRed; if (maskCPF == "" || maskCPF.Length < 11) TXT_CPF.BackColor = Color.OrangeRed; if (setor == "") TXT_Setor.BackColor = Color.OrangeRed; if (email == "") TXT_Email.BackColor = Color.OrangeRed; if (userName == "") TXT_Usuario.BackColor = Color.OrangeRed; if (isActive == UserIsactive._) CBX_Status.BackColor = Color.OrangeRed; if (type == UserType._) CBX_TYPE.BackColor = Color.OrangeRed; if (userLoginIdioma == UserIdioma.Portugues) MessageBox.Show("Informe uma opção valida!"); if (userLoginIdioma == UserIdioma.Ingles) MessageBox.Show("Please enter a valid option!"); if (userLoginIdioma == UserIdioma.Espanhol) MessageBox.Show("Introduzca una opción válida!"); return; } if (password != confirmPassword) { MessageBox.Show("As senhas informadas nao sao iguais!"); TXT_Confirm_Pass.BackColor = Color.OrangeRed; TXT_Password.BackColor = Color.OrangeRed; return; } password = Cripto.CriptografaSenha(password); //novo usuario if (isNew) { if (confirmPassword == "" || password == "") { if (password == "") TXT_Password.BackColor = Color.OrangeRed; if (confirmPassword == "") TXT_Confirm_Pass.BackColor = Color.OrangeRed; return; } //valida se usario ja existe //usuarios = manipulaUsuarios.GetUsuarios(userName, null, null, 0); Entities.User user = manipulaUsuarios.GetByUsername(userName); if (user != null) { TXT_Usuario.BackColor = Color.OrangeRed; TXT_Usuario.Focus(); if (userLoginIdioma == UserIdioma.Portugues) MessageBox.Show("Usuario ja Existe, Informe um nome de usuario diferente!"); if (userLoginIdioma == UserIdioma.Ingles) MessageBox.Show("User already exists, Please enter a different username!"); if (userLoginIdioma == UserIdioma.Espanhol) MessageBox.Show("El usuario ya existe, introduzca un nombre de usuario diferente!"); } else// se nao existe cadastra { //saveUserOk = Manipula_Usuarios.Novo_Usuario(name, setor, email, cPF, userName, password, type, isActive); this.Close(); if (saveUserOk) { if (userLoginIdioma == UserIdioma.Portugues) MessageBox.Show("Usuario Adicionado com Sucesso!"); if (userLoginIdioma == UserIdioma.Ingles) MessageBox.Show("Successfully Added User!"); if (userLoginIdioma == UserIdioma.Espanhol) MessageBox.Show("Usuario agregado con éxito!"); } } } //edição de usuario if (!isNew) { if (!passEdit) password = null; saveUserOk = manipulaUsuarios.Edit_User(name, setor, email, cPF, userName, password, type, isActive); this.Close(); if (userLoginIdioma == UserIdioma.Portugues) MessageBox.Show("Usuario Editado com Sucesso!"); if (userLoginIdioma == UserIdioma.Ingles) MessageBox.Show("User Edited Successfully!"); if (userLoginIdioma == UserIdioma.Espanhol) MessageBox.Show("Usuario Editado con Éxito!"); } }
public List <Return_Usuarios> GetUsuarios(String UserName, String Name, String Setor, UserIsactive Status) { List <Return_Usuarios> return_usuarios = new List <Return_Usuarios>(); SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["CS"].ConnectionString); try { string queryString = "SELECT cpf, NAME, email, UserName , Password , setor , " + "isactive , type FROM [dbo].[users] where id > 0 "; SqlCommand cmd = new SqlCommand(queryString, sqlConn); if (UserName != null) { cmd.CommandText += " and UserName like @UserName"; cmd.Parameters.Add("@UserName", SqlDbType.VarChar).Value = "%" + UserName + "%"; } if (Name != null) { cmd.CommandText += " and Name like @Name"; cmd.Parameters.Add("@Name", SqlDbType.VarChar).Value = "%" + Name + "%"; } if (Setor != null) { cmd.CommandText += " and Setor like @Setor"; cmd.Parameters.Add("@Setor", SqlDbType.VarChar).Value = "%" + Setor + "%"; } if (Status != UserIsactive._) { cmd.CommandText += " and isactive = @Status"; cmd.Parameters.Add("@Status", SqlDbType.Int).Value = Status; } sqlConn.Open(); SqlDataReader query = cmd.ExecuteReader(); while (query.Read()) { Return_Usuarios usuarios = new Return_Usuarios(); usuarios.CPF = query["cpf"].ToString(); usuarios.Name = query["Name"].ToString(); usuarios.UserName = query["UserName"].ToString(); usuarios.Password = query["Password"].ToString(); usuarios.Email = query["email"].ToString(); usuarios.Setor = query["Setor"].ToString(); usuarios.IsActive = (UserIsactive)int.Parse(query["isActive"].ToString()); usuarios.Type = (UserType)int.Parse(query["Type"].ToString()); return_usuarios.Add(usuarios); } } catch (SqlException ex) { log.logador("Erro ao carregar a lista de usuarios."); log.logador(ex); throw; } finally { sqlConn.Close(); } return(return_usuarios); }
public bool Edit_User(String Name, String Setor, String eMail, String CPF, String UserName, String Password, UserType type, UserIsactive isActive) { SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["CS"].ConnectionString); bool sucess = false; string queryString = null; try { queryString = "UPDATE [dbo].[users] SET NAME = @name, setor = @setor, email = @email," + " cpf = @cpf, username = @username, type = @type, isactive = @isactive "; SqlCommand cmd = new SqlCommand(queryString, sqlConn); if (Password != null) { cmd.CommandText += " , password = @Password "; cmd.Parameters.Add("@Password", SqlDbType.VarChar).Value = Password; } cmd.CommandText += " WHERE UserName = @username "; cmd.Parameters.AddWithValue("@name", Name); cmd.Parameters.AddWithValue("@setor", Setor); cmd.Parameters.AddWithValue("@email", eMail); cmd.Parameters.AddWithValue("@cpf", CPF); cmd.Parameters.AddWithValue("@username", UserName); cmd.Parameters.AddWithValue("@type", type); cmd.Parameters.AddWithValue("@isactive", isActive); sqlConn.Open(); cmd.ExecuteNonQuery(); sucess = true; log.logador("Usuario editado com sucesso: " + UserName); } catch (SqlException ex) { log.logador("Erro ao editar usuario: " + UserName + " - " + queryString); log.logador(ex); throw; } finally { sqlConn.Close(); } return(sucess); }
public bool Novo_Usuario(String Name, String Setor, String eMail, String CPF, String UserName, String Password, UserType type, UserIsactive isActive) { SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["CS"].ConnectionString); bool sucess = false; string queryString = "insert dbo.Users(Name,Setor,eMail,CPF,UserName,Password,Type,isActive) " + "values (@name, @setor, @email, @cpf, @username, @Password, @type, @isactive)"; SqlCommand cmd = new SqlCommand(queryString, sqlConn); cmd.Parameters.AddWithValue("@name", Name); cmd.Parameters.AddWithValue("@setor", Setor); cmd.Parameters.AddWithValue("@email", eMail); cmd.Parameters.AddWithValue("@cpf", CPF); cmd.Parameters.AddWithValue("@username", UserName); cmd.Parameters.AddWithValue("@Password", Password); cmd.Parameters.AddWithValue("@type", type); cmd.Parameters.AddWithValue("@isactive", isActive); try { sqlConn.Open(); cmd.ExecuteNonQuery(); sucess = true; log.logador("Usuario cadastrado com sucesso: " + UserName); } catch (SqlException ex) { log.logador("Erro ao cadastrar usuario: " + UserName); log.logador(ex); throw; } finally { sqlConn.Close(); } return(sucess); }