public void EliminarEmpleado(clsEmpleadoEntity vX)
{
SqlCommand cmd = new SqlCommand("SP_EMPLEADO_ELIMINAR", Conexion());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@COD", vX.idEmpleado);
cmd.ExecuteNonQuery();
}
public DataTable BuscarxNombre(clsEmpleadoEntity vX)
{
SqlCommand cmd = new SqlCommand("SP_BUSCAR_NOM_EMPLEADO", Conexion());
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
cmd.Parameters.AddWithValue("@NOMBRE", vX.nombre);
DataTable dt = new DataTable("empleado");
da.Fill(dt);
da.Dispose();
return(dt);
}
public Boolean VerificarContra(clsEmpleadoEntity em, int x)
{
SqlCommand cmd = new SqlCommand("SP_ACCESO_CONTRA", Conexion());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CONTRA", em.clave);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows == true)
{
return(true);
}
else
{
return(false);
}
}
public void InsertarEmpleado(clsEmpleadoEntity vX, PictureBox foto)
{
SqlCommand cmd = new SqlCommand("SP_EMPLEADO_INSERTAR", Conexion());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@NOMBRE ", vX.nombre);
cmd.Parameters.AddWithValue("@APELLIDO ", vX.apellido);
cmd.Parameters.AddWithValue("@EMAIL ", vX.email);
cmd.Parameters.AddWithValue("@USUARIO ", vX.ususario);
cmd.Parameters.AddWithValue("@CLAVE ", vX.clave);
cmd.Parameters.AddWithValue("@TELEFONO ", vX.telefono);
cmd.Parameters.AddWithValue("@FOTO", SqlDbType.Image);
System.IO.MemoryStream ms = new System.IO.MemoryStream();
foto.Image.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
cmd.Parameters["@FOTO"].Value = ms.GetBuffer();
cmd.ExecuteNonQuery();
}
public Boolean VerificarUsuario(clsEmpleadoEntity em)
{
SqlCommand cmd = new SqlCommand("SP_ACCESO_USUARIO", Conexion());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@USU", em.ususario);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows == true)
{
return(true);
}
else
{
return(false);
}
}
public Boolean VerificarAcceso(clsEmpleadoEntity em)
{
SqlCommand cmd = new SqlCommand("PA_ACCESO_SISTEMA", Conectar());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@USU", em.ususario);
cmd.Parameters.AddWithValue("@CLAVE", em.clave);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows == true)
{
return(true);
}
else
{
return(false);
}
}
