C# (CSharp) DataAdminGold Data_DBConnection.StartProcedure Exemples

Exemple #1

Fichier : Ecom_Producto.cs Projet : dark-dev-17/darkdev

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

Exemple #2

Fichier : Ecom_ProductoTipo.cs Projet : dark-dev-17/darkdev

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

Exemple #3

Fichier : Ecom_Inversionista.cs Projet : dark-dev-17/darkdev

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

Exemple #4

Fichier : Ecom_PedidoNota.cs Projet : dark-dev-17/darkdev

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

Exemple #5

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

Exemple #6

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

Exemple #7

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

Exemple #8

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

Exemple #9

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