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