public int Registrar_Categoria(categoriaEntitis categoria) { try { using (dbventasEntity context = new dbventasEntity()) { var connection = context.Database.Connection as SqlConnection; using (connection) { connection.Open(); string Qry = "[dbo].[SP_SET_CATEGORIA]"; SqlCommand cmd = new SqlCommand(Qry, connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@idCat", categoria.idcategoria)); cmd.Parameters.Add(new SqlParameter("@nom", categoria.nombre)); cmd.Parameters.Add(new SqlParameter("@Desc", categoria.descripcion)); cmd.ExecuteNonQuery(); return(1); } } } catch (Exception) { return(0); } }
public void EliminarClientes(ClienteEntitis cliente) { try { using (dbventasEntity context = new dbventasEntity()) { var connection = context.Database.Connection as SqlConnection; using (connection) { connection.Open(); string Qry = "[dbo].[SP_SET_CLIENTE_DELETE]"; SqlCommand cmd = new SqlCommand(Qry, connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@idcliente", cliente.idcliente)); //cmd.Parameters.Add(new SqlParameter("@status", 0)); //cmd.Parameters.Add(new SqlParameter("@FechaModifica", DateTime.Now)); cmd.Parameters.Add(new SqlParameter("@UsuarioModifica", cliente.UsuarioModifica)); cmd.ExecuteNonQuery(); } } } catch (Exception ex) { throw ex; } }
public void EliminarProveedor(ProveedorEntity proveedor) { try { using (dbventasEntity context = new dbventasEntity()) { var connection = context.Database.Connection as SqlConnection; using (connection) { connection.Open(); string Qry = "SP_SET_DELETE_PROVEEDOR"; SqlCommand cmd = new SqlCommand(Qry, connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@codigo", proveedor.idproveedor)); cmd.Parameters.Add(new SqlParameter("@estado", proveedor.statu)); cmd.ExecuteNonQuery(); } } } catch (Exception ex) { throw ex; } }
public void EliminarArticulo(articulosEntitis articulo) { try { using (dbventasEntity context = new dbventasEntity()) { var connection = context.Database.Connection as SqlConnection; using (connection) { connection.Open(); string Qry = "[DBO].[SP_SET_DELETE_ARTICULO]"; SqlCommand cmd = new SqlCommand(Qry, connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@codigo", articulo.codigo)); cmd.Parameters.Add(new SqlParameter("@estado", articulo.estado)); cmd.ExecuteNonQuery(); } } } catch (Exception ex) { throw ex; } }
public int LoginUser(string user, string pass) { int rolId = 0; try { using (dbventasEntity db = new dbventasEntity()) { using (var connection = db.Database.Connection as SqlConnection) { connection.Open(); string query = "[dbo].[SP_LOGIN]"; SqlCommand cmd = new SqlCommand(query, connection); cmd.CommandType = CommandType.StoredProcedure; //parameters. @usuario SqlParameter usuario = new SqlParameter("@usuario", user); usuario.SqlDbType = SqlDbType.VarChar; usuario.Size = 50; //parameter. @contrasena SqlParameter contrasena = new SqlParameter("@contrasena", pass); contrasena.SqlDbType = SqlDbType.VarChar; contrasena.Size = 50; //parameter. @rolid SqlParameter rolid = new SqlParameter("@rolid", rolId); rolid.SqlDbType = SqlDbType.Int; rolid.Direction = ParameterDirection.Output; //add parameters to cmd cmd.Parameters.Add(usuario); cmd.Parameters.Add(contrasena); cmd.Parameters.Add(rolid); //exec procedure cmd.ExecuteNonQuery(); if (cmd.Parameters["@rolid"].Value == DBNull.Value) { rolId = 0; } else { rolId = System.Convert.ToInt32(cmd.Parameters["@rolid"].Value); } } } }catch (SqlException ex) { throw new Exception(ex.Message); }catch (Exception ex) { throw new Exception(ex.Message); } return(rolId); }
public int IngresdoDeDatos(ArticulosCompuestoEntity ingreso) { int Estado; try { using (dbventasEntity context = new dbventasEntity()) { var connection = context.Database.Connection as SqlConnection; using (connection) { connection.Open(); string Qry = "SP_SET_INSERTAR_ARTICULOS_INGRESO"; SqlCommand cmd = new SqlCommand(Qry, connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@nombre", ingreso.nombre)); cmd.Parameters.Add(new SqlParameter("@idcategoria", ingreso.idcategoria)); cmd.Parameters.Add(new SqlParameter("@Codigo", ingreso.Codigo)); cmd.Parameters.Add(new SqlParameter("@Imag_Url", ingreso.Imag_Url)); cmd.Parameters.Add(new SqlParameter("@descripcion", ingreso.descripcion)); cmd.Parameters.Add(new SqlParameter("@precioVenta", ingreso.precioVenta)); cmd.Parameters.Add(new SqlParameter("@precioCompra", ingreso.precioCompra)); cmd.Parameters.Add(new SqlParameter("@cantidad", ingreso.cantidad)); cmd.Parameters.Add(new SqlParameter("@estado", ingreso.estado)); cmd.Parameters.Add(new SqlParameter("@idProveedor", ingreso.idProveedor)); cmd.Parameters.Add(new SqlParameter("@idingreso", ingreso.idingreso)); cmd.Parameters.Add(new SqlParameter("@fecha", ingreso.fecha)); cmd.Parameters.Add(new SqlParameter("@tipo_comprobante", ingreso.tipo_comprobante)); cmd.Parameters.Add(new SqlParameter("@igv", ingreso.igv)); cmd.Parameters.Add(new SqlParameter("@UsuarioAdiciona", ingreso.UsuarioAdiciona)); cmd.Parameters.Add(new SqlParameter("@stock_inicial", ingreso.stock_inicial)); cmd.Parameters.Add(new SqlParameter("@fecha_produccion", ingreso.fecha_produccion)); cmd.Parameters.Add(new SqlParameter("@fecha_vencimiento", ingreso.fecha_vencimiento)); cmd.ExecuteNonQuery(); return(Estado = 1); } } } catch (Exception ex) { return(Estado = 0); throw ex; } }
public DataTable Listproveedor() { using (dbventasEntity context = new dbventasEntity()) { var connection = context.Database.Connection as SqlConnection; using (connection) { connection.Open(); string Qry = "[dbo].[SP_GET_PROVEEDOR_LOAD]"; SqlCommand cmd = new SqlCommand(Qry, connection); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); return(dt); } } }
public DataTable ListCuentasXcobrar() { using (dbventasEntity context = new dbventasEntity()) { var connection = context.Database.Connection as SqlConnection; using (connection) { connection.Open(); string Qry = "sp_get_clientes_deudores"; SqlCommand cmd = new SqlCommand(Qry, connection); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); return(dt); } } }
public DataTable ListCategoria() { using (dbventasEntity context = new dbventasEntity()) { var connection = context.Database.Connection as SqlConnection; using (connection) { connection.Open(); string Qry = "SP_GET_Categoria_LOAD"; SqlCommand cmd = new SqlCommand(Qry, connection); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); return(dt); } } }
public int Registrar_Proveedor(ProveedorEntity proveedor) { try { using (dbventasEntity context = new dbventasEntity()) { var connection = context.Database.Connection as SqlConnection; using (connection) { connection.Open(); string Qry = "SP_SET_UDATE_INSERT_PROVEEDOR"; SqlCommand cmd = new SqlCommand(Qry, connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@idproveedor", proveedor.idproveedor)); cmd.Parameters.Add(new SqlParameter("@razon_social", proveedor.razon_social)); cmd.Parameters.Add(new SqlParameter("@NombreProveedor", proveedor.NombreProveedor)); cmd.Parameters.Add(new SqlParameter("@tipo_documento", proveedor.tipo_documento)); cmd.Parameters.Add(new SqlParameter("@num_documento", proveedor.num_documento)); cmd.Parameters.Add(new SqlParameter("@direccion", proveedor.direccion)); cmd.Parameters.Add(new SqlParameter("@telefono", proveedor.telefono)); cmd.Parameters.Add(new SqlParameter("@email", proveedor.email)); cmd.Parameters.Add(new SqlParameter("@url", proveedor.url)); cmd.Parameters.Add(new SqlParameter("@statu", proveedor.statu)); cmd.Parameters.Add(new SqlParameter("@FechaAdiciona", proveedor.FechaAdiciona)); cmd.Parameters.Add(new SqlParameter("@FechaModifica", proveedor.FechaModifica)); cmd.Parameters.Add(new SqlParameter("@UsuarioAdiciona", proveedor.UsuarioAdiciona)); cmd.Parameters.Add(new SqlParameter("@UsuarioModifica", proveedor.UsuarioModifica)); //cmd.Parameters.Add(new SqlParameter("@HostNa", proveedor.HostNa)); cmd.ExecuteNonQuery(); return(1); } } } catch (Exception ex) { return(0); throw ex; } }
public articulosEntitis BuscarArticuloXCodigo(string codigo) { articulosEntitis entity = null; try { using (dbventasEntity db = new dbventasEntity()) { var connection = db.Database.Connection as SqlConnection; using (connection) { connection.Open(); string command = "[DBO].[SP_GET_ARTICULOS_BUSCAR_X_CODIGO]"; SqlCommand sqlCommand = new SqlCommand(command); sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.Parameters.AddWithValue("@codigo", codigo.ToUpper()); SqlDataAdapter da = new SqlDataAdapter(sqlCommand); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count > 0) { entity = new articulosEntitis(); foreach (DataRow row in dt.Rows) { entity.idarticulo = Convert.ToInt32(row["idarticulo"].ToString()); entity.codigo = row["codigo"].ToString(); entity.nombre = row["nombre"].ToString(); entity.idcategoria = Convert.ToInt32(row["idcategoria"].ToString()); entity.Imag_Url = row["Imag_Url"].ToString(); entity.descripcion = row["descripcion"].ToString(); entity.precioVenta = Convert.ToDecimal(row["precioVenta"].ToString()); entity.precioCompra = Convert.ToDecimal(row["precioCompra"].ToString()); } return(entity); } } } }catch (Exception ex) { return(entity); } return(entity); }
public DataTable BuscarCategoria(categoriaEntitis categoria) { using (dbventasEntity context = new dbventasEntity()) { var connection = context.Database.Connection as SqlConnection; using (connection) { connection.Open(); string Qry = "[dbo].[SP_GET_CATEGORIA_BUSCAR]"; SqlCommand cmd = new SqlCommand(Qry, connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@nombre", categoria.nombre); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); return(dt); } } }
public DataTable BuscarArticulo(string codigo, string nombre) { using (dbventasEntity context = new dbventasEntity()) { var connection = context.Database.Connection as SqlConnection; using (connection) { connection.Open(); string Qry = "[dbo].[SP_GET_ARTICULOS_BUSCAR]"; SqlCommand cmd = new SqlCommand(Qry, connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@codigo", codigo); cmd.Parameters.AddWithValue("@nombre", nombre); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); return(dt); } } }
public DataTable ListarticulosX_Codigo(string codigo, int copia) { using (dbventasEntity context = new dbventasEntity()) { var connection = context.Database.Connection as SqlConnection; using (connection) { connection.Open(); string Qry = "[dbo].[LIST_ARTICULOS_X_CODIGO]"; SqlCommand cmd = new SqlCommand(Qry, connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@CODIGO", codigo); cmd.Parameters.AddWithValue("@COPIAS", copia); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); return(dt); } } }
public DataTable Buscarproveedor(string doc, string tel, string nom) { using (dbventasEntity context = new dbventasEntity()) { var connection = context.Database.Connection as SqlConnection; using (connection) { connection.Open(); string Qry = "SP_GET_BUSCAR_PROVEEDOR"; SqlCommand cmd = new SqlCommand(Qry, connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@num_documento", doc); cmd.Parameters.AddWithValue("@telefono", tel); cmd.Parameters.AddWithValue("@NombreProveedor", nom); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); return(dt); } } }
//public IEnumerable<ClienteEntitis> ListaCliente() // { // using (dbventasEntity context = new dbventasEntity()) // { // //CREAR METODO EN POS_SITE DE PRODUCCION // IEnumerable<ClienteEntitis> RetornarValue = context.Database.SqlQuery<ClienteEntitis>("[dbo].[SP_GET_CLIENTES_LOAD]").ToList(); // return RetornarValue.ToList(); // } // } public DataTable BuscarCliente(string NombreCompleto, string cedula, string codigo, string telefono) { using (dbventasEntity context = new dbventasEntity()) { var connection = context.Database.Connection as SqlConnection; using (connection) { connection.Open(); string Qry = "SP_GET_CLIENTES_BUSCAR"; SqlCommand cmd = new SqlCommand(Qry, connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@CodigoCliente", codigo); cmd.Parameters.AddWithValue("@Identificacion", cedula); cmd.Parameters.AddWithValue("@Nombre_Completo", NombreCompleto); cmd.Parameters.AddWithValue("@Telefono", telefono); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); return(dt); } } }
public DataTable GetRollD() { using (dbventasEntity context = new dbventasEntity()) { var connection = context.Database.Connection as SqlConnection; string Qry = "SP_GET_ROLL_DROP"; using (SqlDataAdapter sda = new SqlDataAdapter(Qry, connection)) { //Fill the DataTable with records from Table. DataTable dt = new DataTable(); sda.Fill(dt); //Insert the Default Item to DataTable. DataRow row = dt.NewRow(); row[0] = 0; row[1] = "---Seleccione---"; dt.Rows.InsertAt(row, 0); return(dt); } } }
public void Registrar_Clientes(ClienteEntitis cliente) { try { using (dbventasEntity context = new dbventasEntity()) { var connection = context.Database.Connection as SqlConnection; using (connection) { connection.Open(); string Qry = "[dbo].[SP_SET_CLIENTE_INSERT_UPDATE]"; SqlCommand cmd = new SqlCommand(Qry, connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@idcliente", cliente.idcliente)); cmd.Parameters.Add(new SqlParameter("@nombre", cliente.nombre)); cmd.Parameters.Add(new SqlParameter("@apellidos", cliente.apellidos)); cmd.Parameters.Add(new SqlParameter("@sexo", cliente.sexo)); cmd.Parameters.Add(new SqlParameter("@fecha_nacimiento", cliente.fecha_nacimiento)); cmd.Parameters.Add(new SqlParameter("@tipo_documento", cliente.tipo_documento)); cmd.Parameters.Add(new SqlParameter("@num_documento", cliente.num_documento)); cmd.Parameters.Add(new SqlParameter("@direccion", cliente.direccion)); cmd.Parameters.Add(new SqlParameter("@telefono", cliente.telefono)); cmd.Parameters.Add(new SqlParameter("@email", cliente.email)); cmd.Parameters.Add(new SqlParameter("@status", 1)); cmd.Parameters.Add(new SqlParameter("@UsuarioAdiciona", cliente.UsuarioAdiciona)); cmd.Parameters.Add(new SqlParameter("@UsuarioModifica", cliente.UsuarioModifica)); cmd.ExecuteNonQuery(); } } } catch (Exception ex) { throw ex; } }
public DataTable BuscarClientesDeuda(cuentas_x_cobrarEntitis cxc) { using (dbventasEntity context = new dbventasEntity()) { var connection = context.Database.Connection as SqlConnection; using (connection) { connection.Open(); string Qry = "[dbo].[sp_get_searche_client_pagos]"; SqlCommand cmd = new SqlCommand(Qry, connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@num_documento", cxc.num_documento); cmd.Parameters.AddWithValue("@codigoCliente", cxc.codigoCliente); cmd.Parameters.AddWithValue("@NombComp", cxc.NombComp); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); return(dt); } } }
public void Registrar_Articulos(articulosEntitis articulo) { try { using (dbventasEntity context = new dbventasEntity()) { var connection = context.Database.Connection as SqlConnection; using (connection) { connection.Open(); string Qry = "SP_SET_INSERT_UPDATE_ARTICULO"; SqlCommand cmd = new SqlCommand(Qry, connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@idarticulo", articulo.@idarticulo)); cmd.Parameters.Add(new SqlParameter("@codigo", articulo.codigo)); cmd.Parameters.Add(new SqlParameter("@nombre", articulo.nombre)); cmd.Parameters.Add(new SqlParameter("@idcategoria", articulo.idcategoria)); cmd.Parameters.Add(new SqlParameter("@Imag_Url", articulo.Imag_Url)); cmd.Parameters.Add(new SqlParameter("@descripcion", articulo.descripcion)); cmd.Parameters.Add(new SqlParameter("@precioVenta", articulo.precioVenta)); cmd.Parameters.Add(new SqlParameter("@precioCompra", articulo.precioCompra)); cmd.Parameters.Add(new SqlParameter("@cantidad", articulo.cantidad)); cmd.Parameters.Add(new SqlParameter("@estado", articulo.estado)); cmd.Parameters.Add(new SqlParameter("@idProveedor", articulo.idProveedor)); //cmd.Parameters.Add(new SqlParameter("@UsuarioModifica", null)); cmd.ExecuteNonQuery(); } } } catch (Exception ex) { throw ex; } }