private void button1_Click(object sender, EventArgs e) { using (var db = new MySqlContext()) { LoginModel user = db.LoginModels.Where(r => r.User == txt_usuario.Text).FirstOrDefault(); if (user!=null) { if (user.Pass==txt_pass.Text) { this.Hide(); MainWindow mwWindow = new MainWindow(); mwWindow.Show(); } else { MessageBox.Show("Nombre de Usuario o Password Invalido"); } } else { MessageBox.Show("Nombre de Usuario o Password Invalido"); } } }
public MainWindow() { InitializeComponent(); using (var db = new MySqlContext()) { var permissions = from a in db.Permissions select a.Name; this.checkedListBox_permissions.Items.AddRange(permissions.ToArray()); this.checkedListBox_modificar_permissions.Items.AddRange(permissions.ToArray()); var users = from b in db.LoginModels select b.User; this.checkedListBox_users.Items.AddRange(users.ToArray()); this.checkedListBox_modificar_users.Items.AddRange(users.ToArray()); var roles = from r in db.Roles select r.Name; AutoCompleteStringCollection accl = new AutoCompleteStringCollection(); accl.AddRange(roles.ToArray()); txt_rol_nombre.AutoCompleteMode = AutoCompleteMode.Suggest; txt_rol_nombre.AutoCompleteCustomSource = accl; txt_rol_nombre.AutoCompleteSource = AutoCompleteSource.CustomSource; txt_modificar_nombre.AutoCompleteMode = AutoCompleteMode.Suggest; txt_modificar_nombre.AutoCompleteCustomSource = accl; txt_modificar_nombre.AutoCompleteSource = AutoCompleteSource.CustomSource; } }
static void Main() { Database.SetInitializer<MySqlContext>(new DropCreateDatabaseIfModelChanges<MySqlContext>()); var connString = ConfigurationManager.ConnectionStrings["ConnectionStringName"].ToString(); using (var db = new MySqlContext()) { #region Load CheckedList1 const string f = "/Users/Rafa/Documents/Proyecto NS/SavedList.txt"; List<string> lines = new List<string>(); using (StreamReader r = new StreamReader(f)) { string line; while ((line = r.ReadLine()) != null) { lines.Add(line); } } foreach (string s in lines) { var permissions_in_db = db.Permissions .Where(a => a.Name == s) .Count(); if (permissions_in_db < 1) { if (s!="") { db.Permissions.AddOrUpdate(new Permission { Name = s }); db.SaveChanges(); } } } #endregion db.SaveChanges(); } Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); Application.Run(new Login()); }
private void btn_modificar_buscar_Click(object sender, EventArgs e) { using (var db = new MySqlContext()) { #region ClearCheckedList for (int i = 0; i < checkedListBox_modificar_permissions.Items.Count; i++) { checkedListBox_modificar_permissions.SetItemChecked(i, false); } for (int i = 0; i < checkedListBox_modificar_users.Items.Count; i++) { checkedListBox_modificar_users.SetItemChecked(i, false); } #endregion var permissions = db.Roles.Where(r => r.Name == txt_modificar_nombre.Text) .SelectMany(r => r.Permissions); var users_per_role = db.Roles.Where(r => r.Name == txt_modificar_nombre.Text) .SelectMany(r => r.Users); foreach (var permission in permissions) { for (int i = 0; i < checkedListBox_modificar_permissions.Items.Count; i++) { if ((string)checkedListBox_modificar_permissions.Items[i] == permission.Name) { checkedListBox_modificar_permissions.SetItemChecked(i, true); } } } foreach (var user in users_per_role) { for (int i = 0; i < checkedListBox_modificar_users.Items.Count; i++) { if ((string)checkedListBox_modificar_users.Items[i] == user.User) { checkedListBox_modificar_users.SetItemChecked(i, true); } } } } }
public static LoginModel GetUsers(string user_name, MySqlContext db) { var query = db.LoginModels.SingleOrDefault(p => p.User == user_name); return query; }
public static Permission GetPermission(string permission_name, MySqlContext db) { var query = db.Permissions.SingleOrDefault(p => p.Name == permission_name); return query; }
private void btn_rol_modificar_Click(object sender, EventArgs e) { using (var db = new MySqlContext()) { Role role = (from s in db.Roles where s.Name == txt_modificar_nombre.Text select s).FirstOrDefault<Role>(); foreach (var item in checkedListBox_modificar_permissions.CheckedItems) { Permission newPermission = (from r in db.Permissions .Where(n => n.Name == item) select r).FirstOrDefault<Permission>(); role.Permissions.Clear(); db.SaveChanges(); } foreach (var item in checkedListBox_modificar_permissions.CheckedItems) { Permission newPermission = (from r in db.Permissions .Where(n => n.Name == item) select r).FirstOrDefault<Permission>(); role.Permissions.Add(newPermission); db.SaveChanges(); } MessageBox.Show("Cambios realizados satisfactoriamente.", "Role Creator - Modificar ", MessageBoxButtons.OK, MessageBoxIcon.Information); this.usuarios_por_rolTableAdapter.Fill(this.authDataSet.usuarios_por_rol); } }
private void btn_rol_create_Click(object sender, EventArgs e) { bool checked_per = HandyClass.CheckedListValidator(checkedListBox_permissions); bool checked_users = HandyClass.CheckedListValidator(checkedListBox_users); using (var db = new MySqlContext()) { if (txt_rol_nombre.Text != "") { if ((checked_per != false) && (checked_users != false)) { var role = db.Roles.Where(a => a.Name == txt_rol_nombre.Text).FirstOrDefault(); if (role != null) { MessageBox.Show("Ya existe un rol con este nombre", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); txt_rol_nombre.Focus(); } else { var permissions = new List<Permission>(); foreach (var item in checkedListBox_permissions.CheckedItems) { Permission permission = HandyClass.GetPermission(item.ToString(), db); permissions.Add(permission); } var users = new List<LoginModel>(); foreach (var item in checkedListBox_users.CheckedItems) { LoginModel user = HandyClass.GetUsers(item.ToString(), db); users.Add(user); } db.Roles.Add(new Role { Name = txt_rol_nombre.Text, Permissions = permissions, Users = users }); db.SaveChanges(); this.usuarios_por_rolTableAdapter.Fill(this.authDataSet.usuarios_por_rol); MessageBox.Show("Rol creado satisfactoriamente!"); HandyClass.ClearCheckedListBox(checkedListBox_permissions); HandyClass.ClearCheckedListBox(checkedListBox_users); txt_rol_nombre.Text = ""; txt_rol_nombre.Focus(); } } else { MessageBox.Show( "Debe seleccionar al menos un Usuario y al menos un Permisso, para asignar al Rol.", "Rol Creator", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { MessageBox.Show("Debe Introducir un nombre para el Rol a crear.", "", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txt_rol_nombre.Text = ""; txt_rol_nombre.Focus(); } } }