public SqlOperation GetCreateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "CRE_CELLAR_PR"
};
var cellar = (Cellar)entity;
operation.AddDecimalParam(DB_COL_ID_LATITUDE, cellar.Latitude);
operation.AddDecimalParam(DB_COL_ID_LONGITUDE, cellar.Longitude);
operation.AddVarcharParam(DB_COL_ID_STORE, cellar.Id_Store);
operation.AddVarcharParam(DB_COL_ADDRESS, cellar.Address);
return(operation);
}
public SqlOperation GetCreateStatement(EntidadBase entidad)
{
var operation = new SqlOperation {
ProcedureName = "CRE_INGREDIENTE_PR"
};
var i = (Ingrediente)entidad;
operation.AddVarcharParam(DB_COL_NOMBRE, i.Nombre);
operation.AddIntParam(DB_COL_UNIDAD_MEDIDA, i.UnidadDeMedida.Id);
operation.AddVarcharParam(DB_COL_UNIDAD_EMPAQUE, i.UnidadDeEmpaque);
operation.AddDecimalParam(DB_COL_CANT_POR_EMPAQUE, i.CantPorEmpaque);
operation.AddDecimalParam(DB_COL_UNIDADES, i.Unidades);
return(operation);
}
public SqlOperation GetCreateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "CRE_USUARIO_PR"
};
var u = (Usuario)entity;
operation.AddVarcharParam(DB_COL_EMAIL, u.Email);
operation.AddVarcharParam(DB_COL_SALT, u.PasswordSalt);
operation.AddVarcharParam(DB_COL_HASH, u.PasswordHash);
operation.AddDateTimeParam(DB_COL_PASSWORD_LAST_SET, u.PasswordLastSet);
operation.AddVarcharParam(DB_COL_IDENTIFICACION, u.Identificacion);
operation.AddVarcharParam(DB_COL_NOMBRE, u.Nombre);
operation.AddVarcharParam(DB_COL_APELLIDOS, u.Apellidos);
operation.AddDateParam(DB_COL_NACIMIENTO, u.FechaNacimiento);
operation.AddVarcharParam(DB_COL_ESTADO, u.Estado);
operation.AddVarcharParam(DB_COL_ROLE_ID, u.RoleId);
operation.AddDecimalParam(DB_COL_NOTIFY_USER_AT, u.SmsNotificationsMin ?? 100);
operation.AddIntParam(DB_COL_PHONE, u.Telefono);
if (u.TerminalId != null && u.TerminalId != -1)
{
operation.AddIntParam(DB_COL_TERMINAL, u.TerminalId ?? 0);
}
return(operation);
}
public SqlOperation GetUpdateStatement(Entity entity)
{
var operation = new SqlOperation {
ProcedureName = "UPD_PARAMETROS_PR"
};
var p = (ParametrizablesHotel)entity;
operation.AddVarcharParam(DB_COL_ID_HOTEL, p.IdHotel);
operation.AddDecimalParam(DB_COL_COMISION, p.Comision);
operation.AddDecimalParam(DB_COL_PORCENTAJE_POLITICA, p.Porciento);
operation.AddVarcharParam(DB_COL_DESCRIPCION_POLITICA, p.Politica);
operation.AddIntParam(DB_COL_CANT_DIAS_DEVOLUCION, p.Dias);
operation.AddVarcharParam(DB_COL_MENSAJE_SMS, p.Mensaje);
return(operation);
}
public SqlOperation GetCreateStatement(BaseEntity entity)
{
var operation = new SqlOperation()
{
ProcedureName = "CRUD_EVENTO"
};
var evento = (Evento)entity;
operation.Parameters = new List <SqlParameter>();
operation.AddIntParam(DbColIdEvento, evento.IdEvento);
operation.AddVarcharParam(DbColNombreEvento, evento.NombreEvento);
operation.AddVarcharParam(DbColUbicacionEvento, evento.UbicacionEvento);
operation.AddVarcharParam(DbColDescripcionEvento, evento.DescripcionEvento);
operation.AddByteParam(DbColLogoEvento, ConvertImageToByteArray(evento.LogoEvento));
operation.AddIntParam(DbColIdCategoria, evento.IdCategoria);
operation.AddIntParam(DbColCupoEvento, evento.CupoEvento);
operation.AddVarcharParam(DbColIdEntidad, evento.IdEntidad);
operation.AddDateParam(DbColFechaInicioEvento, evento.FechaInicioEvento);
operation.AddDateParam(DbColFechaFinalEvento, evento.FechaFinalEvento);
operation.AddDateParam(DbColFechaInicioInscripcion, evento.FechaInicioInscripcion);
operation.AddDateParam(DbColFechaFinalInscripcion, evento.FechaFinalInscripcion);
operation.AddDecimalParam(DbColCostoInscripcion, evento.CostoInscripcion);
operation.AddIntParam(DbCrudAction, (int)CrudActionEnum.Create);
return(operation);
}
public SqlOperation GetCreateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "CRE_RECIPE_PR"
};
var c = (Recipe)entity;
operation.AddVarcharParam(DB_COL_EMAIL, c.Email);
operation.AddDecimalParam(DB_COL_LONGITUDE, c.Longitud);
operation.AddDecimalParam(DB_COL_LATITUDE, c.Latitud);
operation.AddIntParam(DB_COL_ID_PROVIDER, c.IdProvider);
operation.AddDecimalParam(DB_COL_TOTAL_PROVIDER, c.TotalProvider);
operation.AddDecimalParam(DB_COL_TOTAL, c.Total);
return(operation);
}
public SqlOperation GetCreateStatement(EntidadBase entidad)
{
var operation = new SqlOperation {
ProcedureName = "CRE_ESTACION_PR"
};
var e = (Estacion)entidad;
operation.AddVarcharParam(DB_COL_NOMBRE, e.Nombre);
operation.AddVarcharParam(DB_COL_ESTADO, e.Estado);
operation.AddDecimalParam(DB_COL_LATITUD, e.Latitud);
operation.AddDecimalParam(DB_COL_LONGITUD, e.Longitud);
operation.AddIntParam(DB_COL_CENTRAL, e.Central);
operation.AddIntParam(DB_COL_KILOMETRO, e.Kilometro);
return(operation);
}
public SqlOperation GetCreateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "CRE_TERMINAL_PR"
};
var t = (Terminal)entity;
operation.AddVarcharParam(DB_COL_NOMBRE, t.TerminalName);
operation.AddDecimalParam(DB_COL_LATITUD, t.Latitude);
operation.AddDecimalParam(DB_COL_LONGITUD, t.Longitude);
operation.AddIntParam(DB_COL_CANTIDAD_LINEAS, t.CantidadLineas);
operation.AddVarcharParam(DB_COL_ESTADO, "Activo");
operation.AddIntParam(DB_COL_ESPACIOS_PARQUEO, t.EspaciosParqueo);
operation.AddIntParam(DB_COL_ESPACIOS_PARQUEO_BUS, t.EspaciosParqueoBus);
return(operation);
}
public SqlOperation GetUpdateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "UPD_SHIPPING_PR"
};
var s = (Shipping)entity;
operation.AddVarcharParam(DB_COL_IDENTIFICATION, s.Identification);
operation.AddVarcharParam(DB_COL_NAME, s.Name);
operation.AddVarcharParam(DB_COL_LOGO, s.Logo);
operation.AddDecimalParam(DB_COL_AREA_ENVIOS, s.CoveredArea);
operation.AddVarcharParam(DB_COL_NUMERO_TELEFONO, s.Phone_Number);
//operation.AddVarcharParam(DB_COL_TIPOS_ENVIO, s.TiposEnvio);
operation.AddDecimalParam(DB_COL_TARIFA_BASE, s.Minimum_Rate);
operation.AddDecimalParam(DB_COL_TARIFAXKILOMETRIO, s.Rate);
operation.AddIntParam(DB_COL_ID_CURRENCY, s.IdCurrency);
return(operation);
}
public SqlOperation GetDeleteStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "DEL_PRODUCT_PR"
};
var prouct = (Product)entity;
operation.AddDecimalParam(DB_COL_ID, prouct.Id);
return(operation);
}
public SqlOperation GetCreateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "CRE_AIRPORT_PR"
};
var c = (Airport)entity;
operation.AddVarcharParam(DB_COL_ID, c.ID);
operation.AddVarcharParam(DB_COL_NAME, c.Name);
operation.AddVarcharParam(DB_COL_ADDRESS, c.Address);
operation.AddVarcharParam(DB_COL_PHONE, c.Phone);
operation.AddVarcharParam(DB_COL_ZIPCODE, c.ZipCode);
operation.AddDecimalParam(DB_COL_GATE_TARIFF, c.GateTariff);
operation.AddDecimalParam(DB_COL_RUNWAY_TARIFF, c.RunwayTariff);
operation.AddDecimalParam(DB_COL_TAX, c.Tax);
operation.AddIntParam(DB_COL_STATUS, c.Status ? 1 : 0);
operation.AddVarcharParam(DB_COL_LATITUDE, c.Latitude);
operation.AddVarcharParam(DB_COL_LONGITUDE, c.Longitude);
// operation.AddIntParam(DB_COL_ASIGNED, c.Asigned ? 1 : 0);
return(operation);
}
public SqlOperation GetCreateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "CRE_PRODUCT_PR"
};
var Product = (Product)entity;
operation.AddIntParam(DB_COL_ID, Product.Id);
operation.AddVarcharParam(DB_COL_NAME, Product.Name);
operation.AddVarcharParam(DB_COL_DESCRIPTION, Product.Description);
operation.AddDecimalParam(DB_COL_PRICE_INITIAL, Product.PriceInitial);
operation.AddDecimalParam(DB_COL_PRICE_FINAL, Product.PriceFinal);
operation.AddDecimalParam(DB_COL_START_TAXES, Product.Taxes);
operation.AddVarcharParam(DB_COL_PROVIDER, Product.Provider);
operation.AddIntParam(DB_COL_ID_CATEGORY, Product.IdCategory);
operation.AddIntParam(DB_COL_ID_CURRENCY, Product.IdCurrency);
operation.AddBooleanParam(DB_COL_STATE, Product.State);
return(operation);
}
public SqlOperation UpdateTarjetaSaldo(BaseEntity entity)
{
var tarjeta = (Tarjeta)entity;
var operation = new SqlOperation {
ProcedureName = "UPD_SALDO_TARJETA"
};
operation.AddVarcharParam(DB_COL_CODIGO_UNICO, tarjeta.CodigoUnico);
operation.AddDecimalParam(DB_COL_SALDO_DISPONIBLE, tarjeta.SaldoDisponible);
return(operation);
}
public SqlOperation GetCreateStatement(EntidadBase entidad)
{
var operation = new SqlOperation {
ProcedureName = "CRE_TIPO_TIQUETE_PR"
};
var c = (TipoTiquete)entidad;
operation.AddVarcharParam(DB_COL_TIPO, c.Tipo);
operation.AddDecimalParam(DB_COL_PRECIO, c.Precio);
return(operation);
}
public SqlOperation GetCreateStatement(BaseEntity entity)
{
var operation = new SqlOperation()
{
ProcedureName = "CRUD_PAGO"
};
var pago = (Ruta)entity;
operation.Parameters = new List <SqlParameter>();
operation.AddIntParam(DbColIdPago, pago.IdPago);
operation.AddVarcharParam(DbColIdUsuario, pago.IdUsuario);
operation.AddVarcharParam(DbColMetodoPago, pago.MetodoDePago);
operation.AddVarcharParam(DbColEstadoPago, pago.EstadoDePago);
operation.AddDecimalParam(DbColMontoPago, pago.MontoDePago);
operation.AddDecimalParam(DbColImpuestoVentaPago, pago.ImpuestoDePago);
operation.AddDecimalParam(DbColDescuentoPago, pago.DescuentoDePago);
operation.AddDecimalParam(DbColTotalPago, pago.TotalPago);
operation.AddVarcharParam(DbColDetallePago, pago.DetalleDePago);
operation.AddIntParam(DbCrudAction, (int)CrudActionEnum.Create);
return(operation);
}
public SqlOperation GetCreateStatement(EntidadBase entidad)
{
var operation = new SqlOperation {
ProcedureName = "CRE_CONVENIO_PR"
};
var c = (Convenio)entidad;
operation.AddVarcharParam(DB_COL_NOMBRE, c.Nombre);
operation.AddDecimalParam(DB_COL_DESCUENTO, c.Descuento);
return(operation);
}
public SqlOperation GetUpdateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "CRE_SALIDA_PARQUEO_PR"
};
var r = (RegistroParqueo)entity;
operation.AddVarcharParam(DB_COL_TARJETA_ID, r.TarjetaId);
operation.AddIntParam(DB_COL_TERMINAL_ID, r.TerminalId);
operation.AddDateTimeParam(DB_COL_HORA_FINAL, r.HoraFin);
operation.AddDecimalParam(DB_COL_COSTO_TOTAL, r.CostoTotal);
return(operation);
}
public SqlOperation GetCreateStatement(BaseEntity entity)
{
var operation = new SqlOperation()
{
ProcedureName = "CRUD_PRODUCTO"
};
var producto = (Producto)entity;
operation.Parameters = new List <SqlParameter>();
operation.AddIntParam(DbColIdProducto, producto.IdProducto);
operation.AddVarcharParam(DbColNombreProducto, producto.NombreProducto);
operation.AddDecimalParam(DbColCostoProducto, producto.CostoProducto);
operation.AddByteParam(DbColLogoProducto, ConvertImageToByteArray(producto.LogoProducto));
operation.AddIntParam(DbCrudAction, (int)CrudActionEnum.Create);
return(operation);
}
public SqlOperation GetUpdateStatement(Entity entity)
{
var operation = new SqlOperation {
ProcedureName = "UPD_TIPO_IMPUESTO_PR"
};
var imp = (TipoImpuesto)entity;
operation.AddIntParam(DB_COL_CODIGO, imp.Codigo);
operation.AddVarcharParam(DB_COL_NOMBRE, imp.Nombre);
operation.AddDecimalParam(DB_COL_PORCENTAJE, imp.Porcentaje);
operation.AddVarcharParam(DB_COL_DESCRIPCION, imp.Descripcion);
operation.AddVarcharParam(DB_COL_ESTADO, imp.Estado);
return(operation);
}
public SqlOperation GetPagoMembresiaStatement(Entity entity)
{
var operation = new SqlOperation {
ProcedureName = "PAGO_MEMBRESIA_PR"
};
var c = (Cuenta)entity;
operation.AddVarcharParam(DB_COL_ID_USUARIO, c.IdUsuario);
operation.AddDecimalParam(DB_COL_MONTO, c.Monto);
operation.AddVarcharParam(DB_COL_ID_HOTEL, c.IdHotel);
operation.AddVarcharParam(DB_COL_TIPO_PAGO, c.TipoPago);
return(operation);
}
public SqlOperation GetUpdateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "UPD_ADVERTISING_PR"
};
var ads = (Advertising)entity;
operation.AddIntParam(DB_COL_ID_PRODUCT, ads.IdProduct);
operation.AddVarcharParam(DB_COL_PRODUCT, ads.ProductName);
operation.AddIntParam(DB_COL_ID_USER_PREFERENCES, ads.IdUserPreferences);
operation.AddDecimalParam(DB_COL_PRICE, ads.Price);
operation.AddVarcharParam(DB_COL_USER, ads.Email);
return(operation);
}
public SqlOperation GetCreateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "CRE_OFFER_CODE_PR"
};
var offerCode = (OfferCode)entity;
operation.AddVarcharParam(DB_COL_CODE, offerCode.Code);
operation.AddVarcharParam(DB_COL_DESCRIPTION, offerCode.Description);
operation.AddDecimalParam(DB_COL_VALUE, offerCode.Value);
operation.AddIntParam(DB_COL_CODE, offerCode.Product);
operation.AddIntParam(DB_COL_ID_PROVIDER, offerCode.Provider);
return(operation);
}
public SqlOperation GetCreateGananciaStatement(Entity entity)
{
var operation = new SqlOperation {
ProcedureName = "CRE_GANANCIA_DIA_PR"
};
var c = (Cuenta)entity;
operation.AddVarcharParam(DB_COL_ID_USUARIO, c.IdUsuario);
operation.AddDecimalParam(DB_COL_MONTO, c.Monto);
operation.AddVarcharParam(DB_COL_ID_HOTEL, c.IdHotel);
operation.AddVarcharParam(DB_COL_TIPO_USUARIO, c.TipoUsuario);
operation.AddVarcharParam(DB_COL_TIPO_PAGO, c.TipoPago);
return(operation);
}
public SqlOperation GetUpdateStatement(Entity entity)
{
var operation = new SqlOperation {
ProcedureName = "UPD_GANANCIA_DIA_PR"
};
var c = (Cuenta)entity;
operation.AddVarcharParam(DB_COL_ID_USUARIO, c.IdUsuario);
operation.AddDateTimeParam(DB_COL_FECHA_REALIZADO, c.FechaRealizado);
operation.AddDecimalParam(DB_COL_MONTO, c.Monto);
operation.AddVarcharParam(DB_COL_ID_HOTEL, c.IdUsuario);
operation.AddVarcharParam(DB_COL_TIPO_USUARIO, c.TipoUsuario);
operation.AddVarcharParam(DB_COL_TIPO_PAGO, c.TipoPago);
return(operation);
}
public SqlOperation GetUpdateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "UPD_STORE_PR"
};
var c = (Store)entity;
operation.AddVarcharParam(DB_COL_ID, c.IDStore);
operation.AddVarcharParam(DB_COL_NAME, c.Name);
operation.AddVarcharParam(DB_COL_MANAGER_NAME, c.ManagerName);
operation.AddVarcharParam(DB_COL_PHONE, c.Phone);
operation.AddVarcharParam(DB_COL_ID_CATEGORY, c.IDCategory);
operation.AddVarcharParam(DB_COL_ID_AIRPORT, c.IDAirport);
operation.AddDecimalParam(DB_COL_RENT, c.Rent);
operation.AddIntParam(DB_COL_STATUS, c.Status ? 1 : 0);
return(operation);
}
public SqlOperation GetCreateStatement(BaseEntity entity)
{
var operation = new SqlOperation()
{
ProcedureName = "CRUD_EVENTO_PRODUCTO"
};
var eventoProducto = (EventoProducto)entity;
operation.Parameters = new List <SqlParameter>();
operation.AddIntParam(DbColIdProducto, eventoProducto.IdProducto);
operation.AddVarcharParam(DbColTipoPatrocinio, eventoProducto.TipoPatrocinio);
operation.AddIntParam(DbColCantidadProducto, eventoProducto.CantidadProducto);
operation.AddDecimalParam(DbColValorTotalProducto, eventoProducto.ValorTotalProducto);
operation.AddIntParam(DbColIdEvento, eventoProducto.IdEvento);
operation.AddIntParam(DbColIdPatrocinador, eventoProducto.IdPatrocinador);
operation.AddIntParam(DbCrudAction, (int)CrudActionEnum.Create);
return(operation);
}
public SqlOperation GetCreateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "SP_CREATE_TICKET"
};
var a = (Ticket)entity;
operation.AddVarcharParam(DB_COL_ID, a.Id);
operation.AddVarcharParam(DB_COL_ID_FLIGHT, a.Id_Flight);
operation.AddVarcharParam(DB_COL_TICKET_CLASS, a.Ticket_Class);
operation.AddVarcharParam(DB_COL_STATUS, a.Status);
operation.AddDecimalParam(DB_COL_PRICE, a.Price);
operation.AddDateParam(DB_COL_BUY_DATE, a.Buy_Date);
operation.AddVarcharParam(DB_COL_ID_PERSON, a.Id_Person);
operation.AddVarcharParam(DB_COL_PERSON_NAME, a.Person_Name);
return(operation);
}
public SqlOperation GetCreateReservationReturn(Reservation reservation)
{
var operation = new SqlOperation {
ProcedureName = $"CRE_RESERVACIONES_RETURN_PR"
};
operation.AddIntParam("ID", reservation.Id);
operation.AddIntParam("FK_USUARIO", reservation.FkUser);
operation.AddIntParam("FK_HOTEL", reservation.FkHotel);
operation.AddDateParam("FECHA_INCIO", reservation.StartDate);
operation.AddDateParam("FECHA_FIN", reservation.EndDate);
operation.AddDecimalParam("PRECIO", reservation.Price);
operation.AddIntParam("FK_HABITACION", reservation.FKRoom);
operation.AddIntParam("FK_RESERVACION", reservation.FkReservation);
operation.AddIntParam("FK_SUBRESERVACION", reservation.FkSubreservation);
operation.AddVarcharParam("ESTADO", reservation.State);
return(operation);
}
public SqlOperation GetUpdateStatement(EntidadBase entidad)
{
var operation = new SqlOperation {
ProcedureName = "UPD_TREN_PR"
};
var t = (Tren)entidad;
operation.AddVarcharParam(DB_COL_MODELO, t.Modelo);
operation.AddVarcharParam(DB_COL_MATRICULA, t.Matricula);
operation.AddVarcharParam(DB_COL_NOMBRE, t.Nombre);
operation.AddVarcharParam(DB_COL_FECHA_COMPRA, t.FechaCompra);
operation.AddDecimalParam(DB_COL_COSTO, t.Costo);
operation.AddVarcharParam(DB_COL_DESCRIPCION, t.Descripcion);
operation.AddVarcharParam(DB_COL_ESTADO, t.Estado);
return(operation);
}
public SqlOperation GetUpdateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "UPD_STORE_PR"
};
var store = (Store)entity;
operation.AddVarcharParam(DB_COL_ID, store.Id);
operation.AddVarcharParam(DB_COL_NAME, store.Name);
operation.AddVarcharParam(DB_COL_LOGO, store.Logo);
operation.AddVarcharParam(DB_COL_PHONE_NUMBER, store.PhoneNumber);
operation.AddIntParam(DB_COL_CATEGORY, store.Category);
operation.AddBooleanParam(DB_COL_ACTIVE, store.Active);
operation.AddDecimalParam(DB_COL_EARNINGS, store.Earnings);
return(operation);
}