internal object MtdFiltrarCliente(string filtro) { ClsConexionSQL conn = new ClsConexionSQL(); DataTable result = new DataTable(); SqlDataAdapter adapter = new SqlDataAdapter(); SqlCommand command = new SqlCommand(); command.Connection = conn.Conectar(); command.CommandType = CommandType.StoredProcedure; command.CommandText = "USP_S_FiltrarCliente"; command.Parameters.Add(new SqlParameter("fil", SqlDbType.VarChar)); command.Parameters["fil"].Value = filtro; command.ExecuteNonQuery(); adapter.SelectCommand = command; adapter.Fill(result); command.Connection = conn.Desconectar(); return(result); }
internal DataTable MtdBusquedaProveedor(string ruc) { ClsConexionSQL conn = new ClsConexionSQL(); DataTable result = new DataTable(); SqlDataAdapter adapter = new SqlDataAdapter(); SqlCommand command = new SqlCommand(); command.Connection = conn.Conectar(); command.CommandType = CommandType.StoredProcedure; command.CommandText = "USP_S_BusquedaProveedor"; command.Parameters.Add(new SqlParameter("r", SqlDbType.VarChar)); command.Parameters["r"].Value = ruc; command.ExecuteNonQuery(); adapter.SelectCommand = command; adapter.Fill(result); command.Connection = conn.Desconectar(); return(result); }
internal Boolean MtdAgregarLote(ClsElote e) { try { ClsConexionSQL objConexion = new ClsConexionSQL(); SqlCommand command = new SqlCommand(); SqlDataAdapter adapter = new SqlDataAdapter(); command.Connection = objConexion.Conectar(); command.CommandText = "USP_I_AgregarLote"; command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("cod", SqlDbType.VarChar)); command.Parameters.Add(new SqlParameter("nom", SqlDbType.VarChar)); command.Parameters.Add(new SqlParameter("col", SqlDbType.VarChar)); command.Parameters.Add(new SqlParameter("pro", SqlDbType.VarChar)); command.Parameters.Add(new SqlParameter("so", SqlDbType.VarChar)); command.Parameters.Add(new SqlParameter("can", SqlDbType.Int)); command.Parameters.Add(new SqlParameter("pre", SqlDbType.Decimal)); command.Parameters.Add(new SqlParameter("for", SqlDbType.VarChar)); command.Parameters.Add(new SqlParameter("mem", SqlDbType.VarChar)); command.Parameters.Add(new SqlParameter("pes", SqlDbType.Decimal)); command.Parameters["cod"].Value = e.Codigo; command.Parameters["nom"].Value = e.Nombre; command.Parameters["col"].Value = e.Color; command.Parameters["pro"].Value = e.Proveedor; command.Parameters["so"].Value = e.SistemaOperativo; command.Parameters["can"].Value = e.Cantidad; command.Parameters["pre"].Value = e.Precio_unitario; command.Parameters["for"].Value = e.Forma; command.Parameters["mem"].Value = e.Memoria; command.Parameters["pes"].Value = e.Peso; command.ExecuteNonQuery(); command.Connection = objConexion.Desconectar(); return(true); } catch (Exception ex) { return(false); throw ex; } }
internal void MtdAgregarHistorial(ClsEauditoria objE) { ClsConexionSQL objConexion = new ClsConexionSQL(); SqlCommand objComando = new SqlCommand(); SqlDataAdapter adapter = new SqlDataAdapter(); objComando.Connection = objConexion.Conectar(); objComando.CommandText = "USP_I_AgregarAuditoria"; objComando.CommandType = CommandType.StoredProcedure; objComando.Parameters.Add(new SqlParameter("dniemp", SqlDbType.VarChar)); objComando.Parameters.Add(new SqlParameter("desc", SqlDbType.VarChar)); objComando.Parameters.Add(new SqlParameter("fech", SqlDbType.Date)); objComando.Parameters.Add(new SqlParameter("hor", SqlDbType.VarChar)); objComando.Parameters["dniemp"].Value = objE.Dniemp; objComando.Parameters["desc"].Value = objE.Desc; objComando.Parameters["fech"].Value = objE.Fecha; objComando.Parameters["hor"].Value = objE.Hora; objComando.ExecuteNonQuery(); objComando.Connection = objConexion.Desconectar(); }
internal DataTable MtdVerificarExistencia(string texto) { DataTable empleado = new DataTable(); ClsConexionSQL objConexion = new ClsConexionSQL(); SqlCommand objComando = new SqlCommand(); SqlDataAdapter adapter = new SqlDataAdapter(); objComando.Connection = objConexion.Conectar(); objComando.CommandText = "USP_S_VerificarCuenta"; objComando.CommandType = CommandType.StoredProcedure; objComando.Parameters.Add(new SqlParameter("ver", SqlDbType.VarChar)); objComando.Parameters["ver"].Value = texto; objComando.Connection = objConexion.Conectar(); objComando.ExecuteNonQuery(); adapter.SelectCommand = objComando; adapter.Fill(empleado); objComando.Connection = objConexion.Desconectar(); return(empleado); }
internal DataTable MtdBuscarSesion(string usuario) { DataTable empleado = new DataTable(); ClsConexionSQL objConexion = new ClsConexionSQL(); SqlCommand objComando = new SqlCommand(); SqlDataAdapter adapter = new SqlDataAdapter(); objComando.Connection = objConexion.Conectar(); objComando.CommandText = "USP_S_BuscarSesion"; objComando.CommandType = CommandType.StoredProcedure; objComando.Parameters.Add(new SqlParameter("usu", SqlDbType.VarChar)); objComando.Parameters["usu"].Value = usuario; objComando.Connection = objConexion.Conectar(); objComando.ExecuteNonQuery(); adapter.SelectCommand = objComando; adapter.Fill(empleado); objComando.Connection = objConexion.Desconectar(); return(empleado); }
internal Boolean MtdGuardarComprobante(ClsEcomprobante e) { try { ClsConexionSQL objConexion = new ClsConexionSQL(); SqlCommand command = new SqlCommand(); SqlDataAdapter adapter = new SqlDataAdapter(); command.Connection = objConexion.Conectar(); command.CommandText = "USP_I_AgregarComprobante"; command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("ser", SqlDbType.VarChar)); command.Parameters.Add(new SqlParameter("num", SqlDbType.VarChar)); command.Parameters.Add(new SqlParameter("fec", SqlDbType.Date)); command.Parameters.Add(new SqlParameter("demp", SqlDbType.VarChar)); command.Parameters.Add(new SqlParameter("dcli", SqlDbType.VarChar)); command.Parameters.Add(new SqlParameter("sub", SqlDbType.Decimal)); command.Parameters.Add(new SqlParameter("igv", SqlDbType.Decimal)); command.Parameters.Add(new SqlParameter("tot", SqlDbType.Decimal)); command.Parameters.Add(new SqlParameter("est", SqlDbType.VarChar)); command.Parameters["ser"].Value = e.Serie; command.Parameters["num"].Value = e.Numero; command.Parameters["fec"].Value = e.Fecha; command.Parameters["demp"].Value = e.Empleado; command.Parameters["dcli"].Value = e.Cliente; command.Parameters["sub"].Value = e.Subtotal; command.Parameters["igv"].Value = e.Igv; command.Parameters["tot"].Value = e.Total; command.Parameters["est"].Value = e.Estado; command.ExecuteNonQuery(); command.Connection = objConexion.Desconectar(); return(true); } catch (Exception ex) { return(false); throw ex; } }
internal object MtdListarDetallesComprobante(ClsEdetallecomprobante e) { DataTable data = new DataTable(); ClsConexionSQL objConexion = new ClsConexionSQL(); SqlCommand objComando = new SqlCommand(); SqlDataAdapter adapter = new SqlDataAdapter(); objComando.Connection = objConexion.Conectar(); objComando.CommandText = "USP_S_ListarDetallesComprobante"; objComando.CommandType = CommandType.StoredProcedure; objComando.Parameters.Add(new SqlParameter("ser", SqlDbType.VarChar)); objComando.Parameters.Add(new SqlParameter("num", SqlDbType.VarChar)); objComando.Parameters["ser"].Value = e.Serie; objComando.Parameters["num"].Value = e.Numero; objComando.Connection = objConexion.Conectar(); objComando.ExecuteNonQuery(); adapter.SelectCommand = objComando; adapter.Fill(data); objComando.Connection = objConexion.Desconectar(); return(data); }
internal DataTable MtdValidarLogin(ClsElogin e) { DataTable empleado = new DataTable(); ClsConexionSQL objConexion = new ClsConexionSQL(); SqlCommand objComando = new SqlCommand(); SqlDataAdapter adapter = new SqlDataAdapter(); objComando.Connection = objConexion.Conectar(); objComando.CommandText = "USP_S_ValidarLogin"; objComando.CommandType = CommandType.StoredProcedure; objComando.Parameters.Add(new SqlParameter("usu", SqlDbType.VarChar)); //objComando.Parameters.Add(new SqlParameter("cla", SqlDbType.VarChar)); objComando.Parameters["usu"].Value = e.Usuario; //objComando.Parameters["cla"].Value = e.Clave; objComando.Connection = objConexion.Conectar(); objComando.ExecuteNonQuery(); adapter.SelectCommand = objComando; adapter.Fill(empleado); objComando.Connection = objConexion.Desconectar(); return(empleado); }
internal bool MtdGuardarCliente(ClsEcliente e) { try { ClsConexionSQL objConexion = new ClsConexionSQL(); SqlCommand command = new SqlCommand(); SqlDataAdapter adapter = new SqlDataAdapter(); command.Connection = objConexion.Conectar(); command.CommandText = "USP_I_AgregarCliente"; command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("d", SqlDbType.VarChar)); command.Parameters.Add(new SqlParameter("nom", SqlDbType.VarChar)); command.Parameters.Add(new SqlParameter("ape", SqlDbType.VarChar)); command.Parameters.Add(new SqlParameter("cor", SqlDbType.VarChar)); command.Parameters.Add(new SqlParameter("tel", SqlDbType.VarChar)); command.Parameters.Add(new SqlParameter("est", SqlDbType.VarChar)); //command.Parameters.Add(new SqlParameter("idd", SqlDbType.VarChar)); command.Parameters["d"].Value = e.Dni; command.Parameters["nom"].Value = e.Nombres; command.Parameters["ape"].Value = e.Apellidos; command.Parameters["cor"].Value = e.Correo; command.Parameters["tel"].Value = e.Telefono; command.Parameters["est"].Value = e.Estado; //command.Parameters["idd"].Value = e.IdDispositivo; command.ExecuteNonQuery(); command.Connection = objConexion.Desconectar(); return(true); } catch (Exception ex) { return(false); throw ex; } }
internal Boolean MtdGuardarDetalleComprobante(ClsEdetallecomprobante ed) { try { ClsConexionSQL objConexion = new ClsConexionSQL(); SqlCommand command = new SqlCommand(); SqlDataAdapter adapter = new SqlDataAdapter(); command.Connection = objConexion.Conectar(); command.CommandText = "USP_I_AgregarDetalleComprobante"; command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("ser", SqlDbType.VarChar)); command.Parameters.Add(new SqlParameter("num", SqlDbType.VarChar)); command.Parameters.Add(new SqlParameter("cod", SqlDbType.VarChar)); command.Parameters.Add(new SqlParameter("des", SqlDbType.VarChar)); command.Parameters.Add(new SqlParameter("can", SqlDbType.Int)); command.Parameters.Add(new SqlParameter("pre", SqlDbType.Decimal)); command.Parameters.Add(new SqlParameter("imp", SqlDbType.Decimal)); command.Parameters["ser"].Value = ed.Serie; command.Parameters["num"].Value = ed.Numero; command.Parameters["cod"].Value = ed.Codigo; command.Parameters["des"].Value = ed.Descripcion; command.Parameters["can"].Value = ed.Cantidad; command.Parameters["pre"].Value = ed.Precio_unitario; command.Parameters["imp"].Value = ed.Importe; command.ExecuteNonQuery(); command.Connection = objConexion.Desconectar(); return(true); } catch (Exception ex) { return(false); throw ex; } }
internal bool MtdGuardarSesion(string usuario) { try { ClsConexionSQL objConexion = new ClsConexionSQL(); SqlCommand command = new SqlCommand(); SqlDataAdapter adapter = new SqlDataAdapter(); command.Connection = objConexion.Conectar(); command.CommandText = "USP_I_AgregarSesion"; command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("usu", SqlDbType.VarChar)); command.Parameters["usu"].Value = usuario; command.ExecuteNonQuery(); command.Connection = objConexion.Desconectar(); return(true); } catch (Exception ex) { return(false); throw ex; } }