using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data;
namespace EXAMEN_VISUAL_III
{
public class LOGIN
{
private static SqlConnection con = new SqlConnection("Data Source=DIEGO-PC\\SQLEXPRESS;Initial Catalog=BDPRUEBA;Integrated Security=True");
private int idLogin;
public int IdLogin
{
get { return idLogin; }
set { idLogin = value; }
}
private int idPersona;
public int IdPersona
{
get { return idPersona; }
set { idPersona = value; }
}
private int idRol;
public int IdRol
{
get { return idRol; }
set { idRol = value; }
}
private DateTime fechareg;
public DateTime Fechareg
{
get { return fechareg; }
set { fechareg = value; }
}
private String usuario;
public String Usuario
{
get { return usuario; }
set { usuario = value; }
}
private String password;
public String Password
{
get { return password; }
set { password = value; }
}
public static int checklogin(String USUARIO, String PASSWORD)
{
try
{ con.Open();
DataTable dt = new DataTable ();
String Query ="SELECT id_persona FROM login WHERE usuario='"+USUARIO+"' AND password='"+PASSWORD+"'";
SqlCommand SqlCmd = new SqlCommand(Query,con);
SqlCmd.CommandType = CommandType.Text;
SqlDataAdapter SqlDa = new SqlDataAdapter(SqlCmd);
SqlDa.Fill(dt);
con.Close();
if(dt.Rows.Count>0)
{
return Convert.ToInt32(dt.Rows[0][0]);
}
else
{ return 0;}
}
catch (Exception ex)
{ return -1; }
}
public static int Insert(LOGIN ObjLogin)
{
try
{
con.Open();
DataTable dt = new DataTable();
String Query = "INSERT INTO login ([id_persona],[id_rol], [fechareg], [usuario], [password]) VALUES ('" + ObjLogin.idPersona + "','" + ObjLogin.idRol + "','" + ObjLogin.fechareg + "','" + ObjLogin.usuario + "','" + ObjLogin.password + "')select @@IDENTITY as 'IDENTITY'";
SqlCommand SqlCmd = new SqlCommand(Query, con);
SqlCmd.CommandType = CommandType.Text;
SqlDataAdapter SqlDa = new SqlDataAdapter(SqlCmd);
SqlDa.Fill(dt);
con.Close();
if(dt.Rows.Count>0)
{
return Convert.ToInt32(dt.Rows[0][0]);
}
else
{ return 0; }
}
catch (Exception ex)
{ return -1; }
}
public static List<LOGIN> GetListLogin()
{
try
{
List<LOGIN> listlogin = null;
con.Open();
DataTable dt = new DataTable();
String Query = "SELECT * FROM login";
SqlCommand SqlCmd = new SqlCommand(Query, con);
SqlCmd.CommandType = CommandType.Text;
SqlDataAdapter SqlDa = new SqlDataAdapter(SqlCmd);
SqlDa.Fill(dt);
if (dt.Rows.Count > 0)
{
listlogin = new List<LOGIN>();
foreach (DataRow item in dt.Rows)
{
LOGIN objLogin = new LOGIN();
objLogin.IdLogin = Convert.ToInt32(item["id_login"]);
objLogin.IdPersona = Convert.ToInt32(item["id_persona"]);
objLogin.IdRol = Convert.ToInt32(item["id_rol"]);
objLogin.Fechareg = Convert.ToDateTime(item["fechareg"]);
objLogin.Usuario = Convert.ToString(item["usuario"]);
objLogin.Password = Convert.ToString(item["password"]);
listlogin.Add(objLogin);
}
}
con.Close();
return listlogin;
}
catch (Exception)
{
return null;
}
}
}
}
-----------------------------------------------FORMULARIO LOGIN---------------------------------
private void button1_Click(object sender, EventArgs e)
{
if (LOGIN.checklogin(txtUsuario.Text, txtPassword.Text) > 0)
{
Menu menu = new Menu();
menu.Show();
}
else
{
MessageBox.Show("USUARIO NO ENCONTRADO");
}
}
No hay comentarios.:
Publicar un comentario