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