public SqlOperation GetCreateStatement(Entity entity) { var operation = new SqlOperation { ProcedureName = "CRE_HOTEL_PR" }; var c = (Hotel)entity; operation.AddVarcharParam(DB_COL_CEDULA_JURIDICA, c.CedulaJuridica); operation.AddVarcharParam(DB_COL_ID_GERENTE, c.IdGerente); operation.AddVarcharParam(DB_COL_NOMBRE, c.Nombre); operation.AddIntParam(DB_COL_CLASIFICACION, c.Clasificacion); operation.AddVarcharParam(DB_COL_UBICACION_X, c.UbicacionX); operation.AddVarcharParam(DB_COL_UBICACION_Y, c.UbicacionY); operation.AddVarcharParam(DB_COL_PROVINCIA, c.Provincia); operation.AddVarcharParam(DB_COL_CANTON, c.Canton); operation.AddVarcharParam(DB_COL_DISTRITO, c.Distrito); operation.AddVarcharParam(DB_COL_DIRECCION, c.Direccion); operation.AddVarcharParam(DB_COL_DESCRIPCION, c.Descripcion); operation.AddVarcharParam(DB_COL_CADENA, c.Cadena); operation.AddDoubleParam(DB_COL_PROM_CALIFICACION, c.PromCalificacion); operation.AddVarcharParam(DB_COL_ESTADO, c.Estado); operation.AddVarcharParam(DB_COL_CORREO, c.Correo); operation.AddVarcharParam(DB_COL_TELEFONOS, c.Telefonos); operation.AddVarcharParam(DB_COL_URL_SITIO, c.URLSitio); operation.AddDoubleParam(DB_COL_MEMBRECIA, c.Membrecia); operation.AddVarcharParam(DB_COL_ESTADO_MEMBRECIA, c.EstadoMembrecia); operation.AddDateTimeParam(DB_COL_FECHA_FIN, c.FechaFin); operation.AddVarcharParam(DB_COL_LOGO, c.Logo); operation.AddVarcharParam(DB_COL_FOTO_PERFIL, c.FotoPerfil); operation.AddIntParam(DB_COL_NUM_FACTURACION, c.NumFacturacion); return(operation); }
public SqlOperation GetUpdateStatement(BaseEntity entity) { var sqlOpe = new SqlOperation { ProcedureName = "UPD_DISTRIBUIDOR_PR" }; var obj = (Distribuidor)entity; sqlOpe.AddVarcharParam(DB_COL_CEDULA, obj.Cedula); sqlOpe.AddVarcharParam(DB_COL_NOMBRE, obj.Nombre); sqlOpe.AddVarcharParam(DB_COL_CODIGO_USUARIO, obj.Administrador); sqlOpe.AddDoubleParam(DB_COL_TARIFA_BASE, obj.TarifaBase); sqlOpe.AddDoubleParam(DB_COL_TARIFA_KM, obj.TarifaKM); sqlOpe.AddIntParam(DB_COL_RANGO, obj.Rango); return(sqlOpe); }
public SqlOperation GetCreateStatement(BaseEntity entity) { var operation = new SqlOperation { ProcedureName = "[dbo].[CRE_PRODUCCIOM_PR]" }; var c = (Producion)entity; operation.AddIntParam(DB_COL_TIPO_PRODUCTO, c.id_animal); operation.AddVarcharParam(DB_COL_TIPO_PRODUCTO, c.tipoProducto); operation.AddDateParam(DB_COL_FECHA_PRODUCION, c.fechaProducion); operation.AddDoubleParam(DB_COL_CANTIDAD, c.cantidad); operation.AddVarcharParam(DB_COL_MEDIDA, c.medida); operation.AddDoubleParam(DB_COL_CENFO_DOLLAR, c.cenfoDollar); return(operation); }
public SqlOperation GetCreateStatement(BaseEntity entity) { var operacion = new SqlOperation { ProcedureName = "CREAR_PROMOCION" }; var p = (Promocion)entity; operacion.AddVarcharParam(DB_COL_NOMBRE, p.nombre); operacion.AddDoubleParam(DB_COL_PORCENTAJE, p.porcentaje); operacion.AddVarcharParam(DB_COL_CODIGO, p.codigo); operacion.AddIntParam(DB_COL_CANTIDAD, p.cantidad); if (p.id_comercio > 0) { operacion.AddIntParam(DB_COL_ID_COMERCIO, p.id_comercio); } else { operacion.AddNullParam(DB_COL_ID_COMERCIO); } if (p.id_sucursal > 0) { operacion.AddIntParam(DB_COL_ID_SUCURSAL, p.id_sucursal); } else { operacion.AddNullParam(DB_COL_ID_SUCURSAL); } return(operacion); }
public SqlOperation GetCreateStatement(BaseEntity entity) { var sqlOpe = new SqlOperation { ProcedureName = "CRE_INVENTARIOS_PR" }; var inventario = (Inventario)entity; sqlOpe.AddVarcharParam(DB_COL_CODIGO_PRODUCTO, inventario.IdProducto); sqlOpe.AddVarcharParam(DB_COL_CODIGO_TIENDA, inventario.IdTienda); sqlOpe.AddVarcharParam(DB_COL_CODIGO_PROVEEDOR, inventario.IdProveedor); sqlOpe.AddIntParam(DB_COL_CANTIDAD, inventario.Cantidad); sqlOpe.AddDoubleParam(DB_COL_PRECIO_UNIDAD, inventario.PrecioUnidad); sqlOpe.AddVarcharParam(DB_COL_FECHA_ENTRADA, inventario.FechaEntrada); sqlOpe.AddDoubleParam(DB_COL_IMPUESTO, inventario.Impuesto); return(sqlOpe);; }
public SqlOperation GetCreateStatement(BaseEntity entity) { var operation = new SqlOperation { ProcedureName = "CREAR_LINEA_FACTURA" }; var lineaFactura = (LineaFactura)entity; operation.AddIntParam(DB_COL_ID_ITEM, lineaFactura.IdItem); operation.AddVarcharParam(DB_COL_NOMBRE_ITEM, lineaFactura.NombreItem); operation.AddIntParam(DB_COL_CANTIDAD_ITEM, lineaFactura.CantidadItem); operation.AddDoubleParam(DB_COL_PRECIO_ITEM, lineaFactura.PrecioItem); operation.AddDoubleParam(DB_COL_IMPUESTO, lineaFactura.Impuesto); operation.AddIntParam(DB_COL_ID_FACTURA, lineaFactura.IdFactura); return(operation); }
public SqlOperation GetCreateStatement(BaseEntity entity) { var operation = new SqlOperation { ProcedureName = "PA_CREAR_PRODUCCION" }; var p = (Produccion)entity; operation.AddVarcharParam(DB_COL_TIPO, p.Tipo); operation.AddDoubleParam(DB_COL_CANTIDAD, p.Cantidad); operation.AddDoubleParam(DB_COL_VALOR, p.Valor); operation.AddVarcharParam(DB_COL_FECHA_PRODUCCION, p.FechaProduccion.ToString()); operation.AddIntParam(DB_COL_ANIMAL, p.IdAnimal); return(operation); }
public SqlOperation GetCreateStatement(BaseEntity entity) { var Operation = new SqlOperation { ProcedureName = "CreateRoute" }; var C = (Route)entity; Operation.AddVarcharParam(NAME, C.Name); Operation.AddDoubleParam(DISTANCE, C.Distance); Operation.AddDoubleParam(ESTIMATEDTIME, C.EstimatedTime); Operation.AddIntParam(IDCOMPANY, C.RouteCompany.IdCompany); Operation.AddIntParam(IDTERMINAL, C.RouteTerminal.IdTerminal); Operation.AddDoubleParam(PRICE, C.Price); return(Operation); }
public SqlOperation GetUpdateStatement(BaseEntity entity) { var operation = new SqlOperation { ProcedureName = "UPD_CREDIT_PR" }; var c = (Credit)entity; operation.AddIntParam(DB_COL_CREDIT_ID, c.CreditId); operation.AddVarcharParam(DB_COL_USER_ID, c.UserId); operation.AddDoubleParam(DB_COL_INTEREST_RATE, c.InterestRate); operation.AddVarcharParam(DB_COL_NAME, c.CreditLine); operation.AddDoubleParam(DB_COL_FEE, c.Fee); operation.AddVarcharParam(DB_COL_START_DATE, Convert.ToString(c.StartDate)); operation.AddVarcharParam(DB_COL_STATUS, Convert.ToString(c.Status)); return(operation); }
public SqlOperation GetUpdateStatement(BaseEntity entity) { var operation = new SqlOperation { ProcedureName = "UPD_CONFIGURACION_TERMINAL_PR" }; var c = (ConfiguracionTerminal)entity; operation.AddIntParam(DB_COL_TERMINAL_ID, c.TerminalId); operation.AddIntParam(DB_COL_CANT_QUEJAS_SANCION, c.CantidadQuejasSancion); operation.AddDoubleParam(DB_COL_COSTO_PARQUEO_DIA, c.CostoParqueoDia); operation.AddDoubleParam(DB_COL_COSTO_PARQUEO_HORA, c.CostoParqueoHora); operation.AddDoubleParam(DB_COL_MONTO_INICIAL_TARJETA, c.MontoInicialTarjeta); operation.AddDoubleParam(DB_COL_COSTO_PARQUEO_BUS_MES, c.CostoParqueoBusMes); operation.AddIntParam(DB_COL_CANT_MINUTOS_TARDIA, c.CantidadMinutosTardia); operation.AddIntParam(DB_COL_CANT_TARDIA_SANCION, c.CantidadTardiasSancion); return(operation); }
public SqlOperation GetCreateStatement(BaseEntity entity) { var operation = new SqlOperation { ProcedureName = "CRE_CREDITO_PR" }; var c = (Credit)entity; operation.AddDoubleParam(DB_COL_MONTO, c.Monto); operation.AddDoubleParam(DB_COL_TASA, c.Tasa); operation.AddVarcharParam(DB_COL_CLIENTEID, c.ClienteId); operation.AddDoubleParam(DB_COL_CUOTA, c.Cuota); operation.AddVarcharParam(DB_COL_FEC_INIC, c.FechaInicio); operation.AddVarcharParam(DB_COL_ESTADO, c.Estado); operation.AddDoubleParam(DB_COL_SALDO, c.Saldo); operation.AddVarcharParam(DB_COL_MONEDA, c.Moneda); return(operation); }
public SqlOperation GetUpdateStatement(BaseEntity entity) { var operation = new SqlOperation { ProcedureName = "UPD_CREDIT_PR" }; var c = (Credit)entity; operation.AddIntParam(DB_COL_CREDIT_ID, c.CreditId); operation.AddDoubleParam(DB_COL_AMOUNT, c.Amount); operation.AddDoubleParam(DB_COL_RATE, c.Rate); operation.AddVarcharParam(DB_COL_NAME, c.Name); operation.AddDoubleParam(DB_COL_FEE, c.Fee); operation.AddDatetimeParam(DB_COL_START_DATE, c.StartDate); operation.AddVarcharParam(DB_COL_STATUS, c.Status); operation.AddDoubleParam(DB_COL_OPERATIONAL_BALANCE, c.OperationalBalance); return(operation); }
public SqlOperation GetUpdateStatement(BaseEntity entity) { var operation = new SqlOperation { ProcedureName = "UPD_CREDITO_PR" }; var c = (Credito)entity; operation.AddIntParam(DB_COL_ID, c.Id_Credito); operation.AddDoubleParam(DB_COL_MONTO, c.Monto); operation.AddDoubleParam(DB_COL_TASA, c.Tasa); operation.AddVarcharParam(DB_COL_NOMBRE, c.Nombre); operation.AddDoubleParam(DB_COL_CUOTA, c.Cuota); operation.AddDateTimeParam(DB_COL_FECHAINICIO, c.FechaInicio); operation.AddVarcharParam(DB_COL_ESTADO, c.Estado); operation.AddDoubleParam(DB_COL_SALDOOPERACION, c.SaldoOperacion); operation.AddIntParam(DB_COL_CLIENTE, c.Cliente); return(operation); }
public SqlOperation GetUpdateBalanceStatement(BaseEntity entity) { var operation = new SqlOperation { ProcedureName = "UpdateCardBalance" }; var Card = (Card)entity; operation.AddVarcharParam(IDCARD, Card.IdCard); operation.AddDoubleParam(BALANCE, Card.Balance); return(operation); }
public SqlOperation GetUpdateStatement(BaseEntity entity) { var operation = new SqlOperation { ProcedureName = "UPD_RUTA_PR" }; var r = (Ruta)entity; operation.AddIntParam(DB_COL_ID, r.Id); operation.AddVarcharParam(DB_COL_RUTA_DESCRIPCION, r.RutaDescripcion); operation.AddVarcharParam(DB_COL_JSON_ROUTE, r.JsonRoute); operation.AddDoubleParam(DB_COL_LONGITUDE_DESTINO, r.DestinoLongitude); operation.AddDoubleParam(DB_COL_LATITUDE_DESTINO, r.DestinoLatitude); operation.AddDoubleParam(DB_COL_DISTANCIA, r.Distancia); operation.AddIntParam(DB_COL_LINEA_ID, r.LineaId); operation.AddIntParam(DB_COL_TERMINAL_ID, r.TerminalId); operation.AddIntParam(DB_COL_TARIFA_ID, r.TarifaId); operation.AddVarcharParam(DB_COL_ESTADO, r.Estado); return(operation); }
public SqlOperation GetUpdateSettingsStatement(double number, int idParam, string name) { var Operation = new SqlOperation { ProcedureName = "UpdateSystemParam" }; Operation.AddIntParam(IDPARAM, idParam); Operation.AddDoubleParam(PARAMVALUE, number); Operation.AddVarcharParam(PARAMNAME, name); return(Operation); }
public SqlOperation GetCreateStatement(BaseEntity entity) { var operation = new SqlOperation { ProcedureName = "CreateFineType" }; var c = (FineType)entity; operation.AddVarcharParam(DESCRIPTION, c.TypeDescription); operation.AddDoubleParam(COST, c.Cost); operation.AddVarcharParam(NAME, c.TypeName); return(operation); }
public SqlOperation GetCreateStatement(BaseEntity entity) { var operation = new SqlOperation { ProcedureName = "CREAR_IMPUESTO" }; var i = (Impuesto)entity; operation.AddVarcharParam(DB_COL_NOMBRE, i.Nombre); operation.AddDoubleParam(DB_COL_PORCENTAJE, i.Porcentaje); return(operation); }
public SqlOperation GetCreateStatement(BaseEntity entity) { var operation = new SqlOperation { ProcedureName = "CREAR_TRANSACCION" }; var transaccion = (Transaccion)entity; operation.AddVarcharParam(DB_COL_CODIGO_CONFIRMACION, transaccion.CodigoTransaccion); operation.AddVarcharParam(DB_COL_TIPO_PAGO, transaccion.TipoPago); operation.AddDoubleParam(DB_COL_MONTO, transaccion.Monto); return(operation); }
public SqlOperation GetCreateStatement(BaseEntity entity) { var Operation = new SqlOperation { ProcedureName = "CreateSanctionType" }; var C = (SanctionType)entity; Operation.AddVarcharParam(DESCRIPTION, C.Description); Operation.AddVarcharParam(NAME, C.Name); Operation.AddDoubleParam(COST, C.Cost); return(Operation); }
public SqlOperation GetUpdateStatement(BaseEntity entity) { var operation = new SqlOperation { ProcedureName = "UPD_CONFIGURACION_PR" }; var c = (ConfiguracionItem)entity; operation.AddVarcharParam(DB_COL_ID, c.Id); operation.AddDoubleParam(DB_COL_NUMBER, c.NumberValue); operation.AddVarcharParam(DB_COL_STRING, c.StringValue); return(operation); }
public SqlOperation GetCreateStatement(BaseEntity entity) { var operation = new SqlOperation { ProcedureName = "CRE_CUENTA_PR" }; var c = (Account)entity; operation.AddVarcharParam(DB_COL_MONEDA, c.Moneda); operation.AddVarcharParam(DB_COL_CLIENTEID, c.ClienteId); operation.AddDoubleParam(DB_COL_SALDO, c.Saldo); return(operation); }
public SqlOperation GetUpdateStatement(BaseEntity entity) { var operation = new SqlOperation { ProcedureName = "UpdateCard" }; var Card = (Card)entity; operation.AddVarcharParam(IDCARD, Card.IdCard); operation.AddDoubleParam(BALANCE, Card.Balance); operation.AddIntParam(DAYSFORNOTIFICATION, Card.DaysForNotification); operation.AddDateParam(NOTIFICATION, Card.Notification); operation.AddIntParam(STATUS, Card.Status); return(operation); }
public SqlOperation GetCreateStatement(BaseEntity entity) { var operation = new SqlOperation { ProcedureName = "CRE_ACCOUNT_MOV_PR" }; var am = (AccountMovement)entity; operation.AddVarcharParam(DB_COL_DATE, Convert.ToString(am.Date)); operation.AddVarcharParam(DB_COL_TYPE, Convert.ToString(am.MovType)); operation.AddDoubleParam(DB_COL_AMOUNT, am.Amount); operation.AddIntParam(DB_COL_ACC_NUM, am.AccountNum); return(operation); }
public SqlOperation GetCreateStatement(BaseEntity entity) { var operation = new SqlOperation { ProcedureName = "CRE_TARIFA_PR" }; var t = (Tarifa)entity; operation.AddIntParam(DB_COL_ROUTE_ID, t.RouteId); operation.AddVarcharParam(DB_COL_ROUTE_NAME, t.RouteName); operation.AddVarcharParam(DB_COL_OPERATOR, t.Operator); operation.AddDoubleParam(DB_COL_REGULAR_FARE, t.RegularFare); return(operation); }
public SqlOperation GetUpdateStatement(Entity entity) { var operation = new SqlOperation { ProcedureName = "UPD_SOLICITUD_HOTEL_PR" }; var c = (SolicitudHotel)entity; operation.AddIntParam(DB_COL_CODIGO_SOLICITUD, c.CodigoSolicitud); operation.AddVarcharParam(DB_COL_ESTADO, c.Estado); operation.AddDoubleParam(DB_COL_MEMBRECIA, c.Membrecia); return(operation); }
public SqlOperation GetCreateStatement(BaseEntity entity) { var operation = new SqlOperation { ProcedureName = "CRE_ACCOUNT_PR" }; var c = (Account)entity; operation.AddVarcharParam(DB_COL_ACCOUNT_NAME, c.AccountName); operation.AddVarcharParam(DB_COL_CURRENCY, c.Currency); operation.AddDoubleParam(DB_COL_BALANCE, c.Balance); operation.AddVarcharParam(DB_COL_FK_CUSTOMER_ID, c.Fk_Customer_Id); return(operation); }
public SqlOperation GetCreateStatement(BaseEntity entity) { var operation = new SqlOperation { ProcedureName = "CRE_PRODUCCION_PR" }; var p = (Produccion)entity; operation.AddIntParam(DB_COL_ID_ANIMAL, p.IdAnimal); operation.AddIntParam(DB_COL_CANTIDAD, p.Cantidad); operation.AddDoubleParam(DB_COL_VALOR, p.Valor); operation.AddDateTimeParam(DB_COL_FECHA, p.Fecha); return(operation); }
public SqlOperation GetUpdateStatement(BaseEntity entity) { var operation = new SqlOperation { ProcedureName = "UPD_CUENTA_PR" }; var c = (Cuenta)entity; operation.AddIntParam(DB_COL_ID, c.Id_Cuenta); operation.AddVarcharParam(DB_COL_NOMBRE, c.Nombre); operation.AddVarcharParam(DB_COL_MONEDA, c.Moneda); operation.AddDoubleParam(DB_COL_SALDO, c.Saldo); operation.AddIntParam(DB_COL_CLIENTE, c.Cliente); return(operation); }
public SqlOperation GetUpdateStatement(BaseEntity entity) { var sqlOpe = new SqlOperation { ProcedureName = "UPD_TIENDAS_PR" }; var tienda = (Tienda)entity; sqlOpe.AddVarcharParam(DB_COL_CEDULA, tienda.Cedula); sqlOpe.AddVarcharParam(DB_COL_NOMBRE, tienda.Nombre); sqlOpe.AddVarcharParam(DB_COL_URL_LOGO, tienda.UrlLogo); sqlOpe.AddVarcharParam(DB_COL_TIPO_CEDULA, tienda.TipoCedula); sqlOpe.AddIntParam(DB_COL_CODIGO_GPS_BODEGA, tienda.GpsBodega); sqlOpe.AddDoubleParam(DB_COL_COMISION, tienda.Comision); sqlOpe.AddVarcharParam(DB_COL_CODIGO_ADMIN, tienda.CodigoVendedor); return(sqlOpe); }