public bool Insertar(object VO)
{
User = (VO_User)VO;
try
{
Encabezado();
cmdComando.CommandText = "sp_Inserta_Usuario";
cmdComando.Parameters.AddWithValue("@Curp", User.Curp);
cmdComando.Parameters.AddWithValue("@Tipo", User.idUser);
cmdComando.Parameters.Add("@Foto", SqlDbType.Image);
MemoryStream ms = new MemoryStream();
User.picture.Image.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
cmdComando.Parameters["@Foto"].Value = ms.GetBuffer();
cmdComando.Parameters.AddWithValue("@User", User.usuario);
cmdComando.Parameters.AddWithValue("@Password", adapter.Default(User.Email));
cmdComando.Parameters.AddWithValue("@Celular", User.Celular);
cmdComando.Parameters.AddWithValue("@Email", User.Email);
cmdComando.ExecuteNonQuery();
return(true);
}
catch (Exception e)
{
System.Windows.Forms.MessageBox.Show("Error: " + e);
return(false);
}
finally
{
cnnConexion.Cerrar();
cmdComando.Dispose();
}
}
public List <object> Listar(object VO)
{
Dtt = null;
VO_User User = (VO_User)VO;
try
{
Dtt = new DataTable();
Encabezado();
cmdComando.CommandText = "sp_Login";
cmdComando.Parameters.AddWithValue("@User", User.Nombre);
cmdComando.Parameters.AddWithValue("@Password", User.password);
cmdComando.ExecuteNonQuery();
daAdapter = new SqlDataAdapter(cmdComando);
daAdapter.Fill(Dtt);
List <Object> lstUser = new List <Object>();
if (Dtt.Rows.Count != 0)
{
VO_User user = new VO_User();
user.Nombre = Dtt.Rows[0][0].ToString();
user.Puesto = Dtt.Rows[0][1].ToString();
user.idUser = int.Parse(Dtt.Rows[0][2].ToString());
user.Reglas = Dtt.Rows[0][3].ToString();
lstUser.Add(true);
lstUser.Add(user);
}
else
{
lstUser.Add(false);
}
return(lstUser);
}
catch (Exception e)
{
System.Windows.Forms.MessageBox.Show("Error: " + e);
return(null);
}
finally
{
cnnConexion.Cerrar();
cmdComando.Dispose();
}
}
public bool Eliminar(object VO)
{
User = (VO_User)VO;
try
{
Encabezado();
cmdComando.CommandText = "sp_Elimina_Usuario";
cmdComando.Parameters.AddWithValue("@Curp", User.Curp);
cmdComando.ExecuteNonQuery();
return(true);
}
catch (Exception e)
{
System.Windows.Forms.MessageBox.Show("Error: " + e);
return(false);
}
finally
{
cnnConexion.Cerrar();
cmdComando.Dispose();
}
}
public List <object> Listar(object VO)
{
Boolean verifica = false;
Dtt = null;
try
{
Dtt = new DataTable();
Encabezado();
User = (VO_User)VO;
cmdComando.CommandText = "sp_Login";
if (User != null)
{
cmdComando.Parameters.AddWithValue("@User", User.Nombre);
string clave = adapter.encriptar2(User.password);
cmdComando.Parameters.AddWithValue("@Password", clave);
}
cmdComando.ExecuteNonQuery();
daAdapter = new SqlDataAdapter(cmdComando);
daAdapter.Fill(Dtt);
List <Object> lstUser = new List <Object>();
if (Dtt.Rows.Count != 0)
{
lstUser.Add(true);
for (int i = 0; i < Dtt.Rows.Count; i++)
{
VO_User user = new VO_User();
user.Curp = Dtt.Rows[i][0].ToString();
user.Nombre = Dtt.Rows[i][1].ToString();
user.Paterno = Dtt.Rows[i][2].ToString();
user.Materno = Dtt.Rows[i][3].ToString();
user.Puesto = Dtt.Rows[i][4].ToString();
user.idUser = int.Parse(Dtt.Rows[i][5].ToString());
user.Reglas = Dtt.Rows[i][6].ToString();
user.Celular = Dtt.Rows[i][8].ToString();
user.Email = Dtt.Rows[i][9].ToString();
user.usuario = Dtt.Rows[i][10].ToString();
byte[] datos = new byte[0];
if (!(Dtt.Rows[i][7] is DBNull))
{
datos = (byte[])Dtt.Rows[i][7];
}
user.modificador = int.Parse(Dtt.Rows[i][11].ToString());
user.datos = datos;
lstUser.Add(user);
}
}
else
{
lstUser.Add(false);
}
return(lstUser);
}
catch (Exception e)
{
System.Windows.Forms.MessageBox.Show("Error: " + e);
return(null);
}
finally
{
cnnConexion.Cerrar();
cmdComando.Dispose();
}
}