public DataTable ConsultarLogin(BEUsuario objEUsuario)
{
DataTable dt = new DataTable();
MySqlConnection conn = new MySqlConnection("Server=127.0.0.1; Database=MECANICSWEB; Uid=Administrador; Pwd=admin");
MySqlCommand command = new MySqlCommand("`mecanicsweb`.`ConsultaLogin`", conn);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(ObjSqlParameter("N_Login", objEUsuario.Login, ParameterDirection.Input, System.Data.DbType.String));
command.Parameters.Add(ObjSqlParameter("N_Password", objEUsuario.Password, ParameterDirection.Input, System.Data.DbType.String));
conn.Open();
IDataReader dr = command.ExecuteReader();
dt.Load(dr);
conn.Close();
return dt;
}
public Object MantenimientoUsuario(string ACCION, BEUsuario objEUsuario)
{
DataTable dt = new DataTable();
MySqlConnection conn = new MySqlConnection("Server=127.0.0.1; Database=MECANICSWEB; Uid=Administrador; Pwd=admin");
MySqlCommand command = new MySqlCommand("`mecanicsweb`.`MantenimientoUsuario`", conn);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(ObjSqlParameter("N_ID", objEUsuario.ID_Usuario, ParameterDirection.Input, System.Data.DbType.Int16));
command.Parameters.Add(ObjSqlParameter("N_IDPersonal", objEUsuario.ID_Personal, ParameterDirection.Input, System.Data.DbType.Int16));
command.Parameters.Add(ObjSqlParameter("N_Login", objEUsuario.Login, ParameterDirection.Input, System.Data.DbType.String));
command.Parameters.Add(ObjSqlParameter("N_LPassword", objEUsuario.Password, ParameterDirection.Input, System.Data.DbType.String));
command.Parameters.Add(ObjSqlParameter("N_IDRol", objEUsuario.Id_Perfil, ParameterDirection.Input, System.Data.DbType.Int16));
command.Parameters.Add(ObjSqlParameter("N_Estado", objEUsuario.Estado, ParameterDirection.Input, System.Data.DbType.Int16));
command.Parameters.Add(ObjSqlParameter("ACCION", ACCION, ParameterDirection.Input, System.Data.DbType.String));
conn.Open();
try
{
if (ACCION.Equals("AGREGAR") || ACCION.Equals("MODIFICAR"))
{
command.ExecuteNonQuery();
return "Exito";
}
else
{
IDataReader dr = command.ExecuteReader();
dt.Load(dr);
return dt;
}
}
catch (Exception e)
{
throw new Exception("Error interno", e);
}
finally
{
conn.Close();
}
}
public Object MantenimientoUsuario(string ACCION, BEUsuario objEUsuario)
{
return objUsuario.MantenimientoUsuario(ACCION, objEUsuario);
}
public DataTable ConsultarLogin(BEUsuario objEUsuario)
{
return objUsuario.ConsultarLogin(objEUsuario);
}
