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;
}
}
