private void btnIngresar_Click(object sender, EventArgs e) { string nickname = txtNickname.Text; string password = txtPassword.Text; if (nickname == "" || password == "") { lblMensaje.Text = "Es necesario que ingreses usuario y/o contraseña"; } else { db = new FigthersEntities(); Usuario user = new Usuario(); try { var context = new FigthersEntities(); //var users = from Usuario in context.Usuario select user; user = db.Usuario.FirstOrDefault(a => a.nickname == nickname && a.passwork == password); if (user == null) { lblMensaje.Text = "No existe el Usuario en el sistema"; } else { DialogResult = DialogResult.OK; } } catch (EntitySqlException ex) { MessageBox.Show(":( Ocurrio un pequeño error vuelve a intentarlo..... {0}", ex.Message); } } }
public bool Actualizar(int id, string name, string lastname, Double money,Double debe ,DateTime date) { try { db = new FigthersEntities(); Alumno someone = db.Alumno.FirstOrDefault(a=> a.Id == id); someone.nombre = name; someone.apellido = lastname; someone.pago = money; someone.fechaPago = date; someone.debe = debe; db.SaveChanges(); return true; } catch { return false; } }
public bool DeleteAlumn(int id) { try { db = new FigthersEntities(); Alumno someone = db.Alumno.FirstOrDefault(a => a.Id == id); if (someone == null) { return false; } else { db.Alumno.Remove(someone); db.SaveChanges(); return true; } } catch { return false; } }
public bool AddAlumn(int id, string name, string lastname, Double money, Double debe,DateTime date) { try { db = new FigthersEntities(); Alumno someone = new Alumno(); someone.Id = id; someone.nombre = name; someone.apellido = lastname; someone.pago = money; someone.debe = debe; someone.fechaPago = date; someone.habilitado = true; db.Alumno.Add(someone); db.SaveChanges(); return true; } catch { return false; } }
private void RefreshDataBinding() { context = new FigthersEntities(); var query = from a in context.Alumno select new DataBindingProjection { AlumID = a.Id, AlumName = a.nombre, AlumnfechaPago = a.fechaPago }; var alums = query.ToList(); dgvDatos.DataSource = alums; }
public bool SearchAlumn(int id) { try { db = new FigthersEntities(); Alumno alumn = db.Alumno.FirstOrDefault(a=>a.Id == id); if (alumn == null) { return false; } else { other = alumn; return true; } } catch { return false; } }