public bool Add() { try { Data_DBConnection_.StartProcedure("SP_Producto"); Data_DBConnection_.AddParameter(Id, "Id", "INT"); Data_DBConnection_.AddParameter(Clave, "Clave", "VARCHAR"); Data_DBConnection_.AddParameter(Descripcion, "Descripcion", "VARCHAR"); Data_DBConnection_.AddParameter(PrecioCotizacion, "PrecioCotizacion", "DOUBLE"); Data_DBConnection_.AddParameter(PrecioCompra, "PrecioCompra", "DOUBLE"); Data_DBConnection_.AddParameter(PrecioVenta, "PrecioVenta", "DOUBLE"); Data_DBConnection_.AddParameter(FechaCotizacion, "FechaCotizacion", "DATETIME"); Data_DBConnection_.AddParameter(FechaCompra, "FechaCompra", "DATETIME"); Data_DBConnection_.AddParameter(FechaVenta, "FechaVenta", "DATETIME"); Data_DBConnection_.AddParameter(Estatus, "Estatus", "INT"); Data_DBConnection_.AddParameter(Pedido, "Pedido", "INT"); Data_DBConnection_.AddParameter(TipoProducto, "TipoProducto", "INT"); Data_DBConnection_.AddParameter(Cliente, "Cliente", "INT"); Data_DBConnection_.AddParameter(1, "ModeProcedure", "INT"); int result = Data_DBConnection_.ExecProcedure(); return(result == 0 ? true : false); } catch (Ecom_Exception ex) { throw ex; } }
public bool Add() { try { Data_DBConnection_.StartProcedure("SP_tipoProducto"); Data_DBConnection_.AddParameter(Id, "Id", "INT"); Data_DBConnection_.AddParameter(Descripcion, "Descripcion", "VARCHAR"); Data_DBConnection_.AddParameter(1, "ModeProcedure", "INT"); int result = Data_DBConnection_.ExecProcedure(); return(result == 0 ? true : false); } catch (Ecom_Exception ex) { throw ex; } }
public bool Add() { try { Data_DBConnection_.StartProcedure("SP_inversionista"); Data_DBConnection_.AddParameter(Id, "Id", "INT"); Data_DBConnection_.AddParameter(Nombre, "Nombre", "VARCHAR"); Data_DBConnection_.AddParameter(1, "ModeProcedure", "INT"); int result = Data_DBConnection_.ExecProcedure(); return(result == 0 ? true : false); } catch (Ecom_Exception ex) { throw ex; } }
public bool Add() { try { Data_DBConnection_.StartProcedure("SP_PedidoNota"); Data_DBConnection_.AddParameter(Id, "Id", "INT"); Data_DBConnection_.AddParameter(Folio, "Folio", "VARCHAR"); Data_DBConnection_.AddParameter(Pedido, "Pedido", "INT"); Data_DBConnection_.AddParameter(1, "ModeProcedure", "INT"); int result = Data_DBConnection_.ExecProcedure(); return(result == 0 ? true : false); } catch (Ecom_Exception ex) { throw ex; } }
public bool Add() { try { Data_DBConnection_.StartProcedure("SP_Proveedor"); Data_DBConnection_.AddParameter(Id, "Id", "INT"); Data_DBConnection_.AddParameter(Nombre, "Nombre", "VARCHAR"); Data_DBConnection_.AddParameter(Telefono, "Telefono", "VARCHAR"); Data_DBConnection_.AddParameter(Direccion, "Direccion", "VARCHAR"); Data_DBConnection_.AddParameter(1, "ModeProcedure", "INT"); int result = Data_DBConnection_.ExecProcedure(); return(result == 0 ? true : false); } catch (Ecom_Exception ex) { throw ex; } }
public bool Add() { try { Data_DBConnection_.StartProcedure("SP_Abonos"); Data_DBConnection_.AddParameter(Id, "Id", "INT"); Data_DBConnection_.AddParameter(Total, "Total", "DOUBLE"); Data_DBConnection_.AddParameter(Fecha, "Fecha", "DATETIME"); Data_DBConnection_.AddParameter(Cliente, "Cliente", "INT"); Data_DBConnection_.AddParameter(1, "ModeProcedure", "INT"); int result = Data_DBConnection_.ExecProcedure(); return(result == 0 ? true : false); } catch (Ecom_Exception ex) { throw ex; } }
public bool Add() { try { Data_DBConnection_.StartProcedure("SP_PedidoAjuste"); Data_DBConnection_.AddParameter(Id, "Id", "INT"); Data_DBConnection_.AddParameter(Total, "Total", "DOUBLE"); Data_DBConnection_.AddParameter(Tipo, "Tipo", "INT"); Data_DBConnection_.AddParameter(Pedido, "Pedido", "INT"); Data_DBConnection_.AddParameter(Descripcion, "Descripcion", "VARCHAR"); Data_DBConnection_.AddParameter(1, "ModeProcedure", "INT"); int result = Data_DBConnection_.ExecProcedure(); return(result == 0 ? true : false); } catch (Ecom_Exception ex) { throw ex; } }
public bool Add() { try { Data_DBConnection_.StartProcedure("SP_Pedido"); Data_DBConnection_.AddParameter(Id, "Id", "INT"); Data_DBConnection_.AddParameter(Total, "Total", "DOUBLE"); Data_DBConnection_.AddParameter(FechaCompra, "FechaCompra", "DATETIME"); Data_DBConnection_.AddParameter(Estatus, "Estatus", "INT"); Data_DBConnection_.AddParameter(Proveedor, "Proveedor", "INT"); Data_DBConnection_.AddParameter(1, "ModeProcedure", "INT"); int result = Data_DBConnection_.ExecProcedure(); return(result == 0 ? true : false); } catch (Ecom_Exception ex) { throw ex; } }
public bool Add() { try { Data_DBConnection_.StartProcedure("SP_Inversiones"); Data_DBConnection_.AddParameter(Id, "Id", "INT"); Data_DBConnection_.AddParameter(TotalInversion, "TotalInversion", "DOUBLE"); Data_DBConnection_.AddParameter(Descripcion, "Descripcion", "VARCHAR"); Data_DBConnection_.AddParameter(FechaInversion, "FechaInversion", "DATETIME"); Data_DBConnection_.AddParameter(Inversionista, "Inversionista", "INT"); Data_DBConnection_.AddParameter(Pedido, "Pedido", "INT"); Data_DBConnection_.AddParameter(TotalRecuperado, "TotalRecuperado", "DOUBLE"); Data_DBConnection_.AddParameter(FechaRecuperado, "FechaRecuperado", "DATETIME"); Data_DBConnection_.AddParameter(Estatus, "Estatus", "INT"); Data_DBConnection_.AddParameter(1, "ModeProcedure", "INT"); int result = Data_DBConnection_.ExecProcedure(); return(result == 0 ? true : false); } catch (Ecom_Exception ex) { throw ex; } }