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_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(); } } }