public SqlOperation GetRetriveAllStatement()
{
var operation = new SqlOperation()
{
ProcedureName = "CRUD_ACTIVIDAD"
};
operation.Parameters = new List <SqlParameter>();
operation.AddIntParam(DbCrudAction, (int)CrudActionEnum.RetrieveAll);
return(operation);
}
public SqlOperation GetRetriveStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "RET_CONSULTA_PALABRA_PR"
};
var c = (ConsultasPalabras)entity;
operation.AddIntParam(DB_COL_CODIGO_REGISTRO, c.CODIGO_REGISTRO);
return(operation);
}
public SqlOperation GetCitasClienteStatament(BaseEntity entity)
{
var c = (Cita)entity;
var operacion = new SqlOperation {
ProcedureName = "OBTENER_CITAS_CLIENTE"
};
operacion.AddDateParam(DB_COL_FECHA, c.fecha);
operacion.AddIntParam(DB_COL_ID_CLIENTE, c.id_cliente);
return(operacion);
}
public SqlOperation GetCitasComercioStatament(BaseEntity entity)
{
var c = (Cita)entity;
var operacion = new SqlOperation {
ProcedureName = "OBTENER_CITA_COMERCIO"
};
operacion.AddDateParam(DB_COL_FECHA, c.fecha);
operacion.AddIntParam(DB_COL_ID_COMERCIO, c.id_comercio);
return(operacion);
}
//Search by id
public SqlOperation GetRetriveStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "RET_ADVERTISING_ID_PR"
};
var ads = (Advertising)entity;
operation.AddIntParam(DB_COL_ID_PRODUCT, ads.IdProduct);
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 GetRetriveStatement(BaseEntity entity)
{
var Operation = new SqlOperation {
ProcedureName = "RetrieveScheduleById"
};
var C = (Schedule)entity;
Operation.AddIntParam(IDSCHEDULE, C.IdSchedule);
return(Operation);
}
public SqlOperation GetRetriveStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "RET_RUTA_PR"
};
var r = (Ruta)entity;
operation.AddIntParam(DB_COL_ID, r.Id);
return(operation);
}
public SqlOperation GetRetriveStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "RET_PRODUCTO_PR"
};
var c = (Productos)entity;
operation.AddIntParam(DB_COL_CODIGO, c.CODIGO);
return(operation);
}
public SqlOperation GetRetriveStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "RET_TARIFA_PR"
};
var t = (Tarifa)entity;
operation.AddIntParam(DB_COL_ROUTE_ID, t.RouteId);
return(operation);
}
public SqlOperation GetRetriveStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "RET_CREDITO_PR"
};
var c = (Credit)entity;
operation.AddIntParam(DB_COL_ID, c.Id);
return(operation);
}
public SqlOperation GetDeleteStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "DEL_ACCOUNT_PR"
};
var a = (Account)entity;
operation.AddIntParam(DB_COL_ACCOUNT_NUM, a.AccountNum);
operation.AddVarcharParam(DB_COL_CUSTOMER_ID, a.UserId);
return(operation);
}
public SqlOperation GetRetriveByRutaStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "RET_HORARIO_PR"
};
var h = (Horario)entity;
operation.AddIntParam(DB_COL_RUTA_ID, h.RutaId);
return(operation);
}
public SqlOperation GetRetriveStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "PA_LISTAR_PRODUCCION_POR_ID"
};
var p = (Produccion)entity;
operation.AddIntParam(DB_COL_ID_PRODUCCION, p.IdProduccion);
return(operation);
}
public SqlOperation GetCreateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "CRE_USER_PR"
};
var c = (User)entity;
operation.AddVarcharParam(DB_COL_NAME, c.Name);
operation.AddIntParam(DB_COL_TRANSLATED_WORDS_AMOUNT, c.amountTranslatedWords);
return(operation);
}
public SqlOperation GetCountByCodigoCategoriaStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "CONT_ALL_PRODUCTOS_BY_CATEGORIA_PR"
};
var c = (Productos)entity;
operation.AddIntParam(DB_COL_CODIGO_CATEGORIA, c.CODIGO_CATEGORIA);
return(operation);
}
public SqlOperation GetRetriveStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "RET_USER_PR"
};
var c = (User)entity;
operation.AddIntParam(DB_COL_ID_USER, c.IdUser);
return(operation);
}
public SqlOperation GetRetriveStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "RET_CLIENTE_PR"
};
var c = (Cliente)entity;
operation.AddIntParam(DB_COL_ID, c.Id_Cliente);
return(operation);
}
//Search by id
public SqlOperation GetRetriveStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "RET_PRODUCT_ID_PR"
};
var product = (Product)entity;
operation.AddIntParam(DB_COL_ID, product.Id);
return(operation);
}
public SqlOperation GetCreateStatement(Entity entity)
{
var operation = new SqlOperation {
ProcedureName = "CRE_PRODUCTO_PR"
};
var p = (Producto)entity;
operation.AddVarcharParam(DB_COL_CODIGO, p.Codigo);
operation.AddVarcharParam(DB_COL_NOMBRE, p.Nombre);
operation.AddVarcharParam(DB_COL_DESCRIPCION, p.Descripcion);
operation.AddDecimalParam(DB_COL_PRECIO, p.Precio);
operation.AddVarcharParam(DB_COL_FOTO, p.Foto);
operation.AddVarcharParam(DB_COL_PROVEEDOR, p.Proveedor);
operation.AddIntParam(DB_COL_CANT_PRODUCTOS, p.CantProductos);
operation.AddIntParam(DB_COL_ID_CATEGORIA, p.IdCategoria);
operation.AddIntParam(DB_COL_ID_TIPO_IMPUESTO, p.IdTipoImpuesto);
operation.AddVarcharParam(DB_COL_ID_SERVICIO, p.IdServicio);
return(operation);
}
public SqlOperation GetRetriveStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "RetrieveAgreementById"
};
var be = (Agreement)entity;
operation.AddIntParam(DB_COL_ID, be.IdAgreement);
return(operation);
}
public SqlOperation GetUpdateStatement(EntidadBase entidad)
{
var p = (Puesto)entidad;
var operation = new SqlOperation {
ProcedureName = "UPD_PUESTO_PR"
};
operation.AddIntParam(DB_COL_ID, p.Id);
operation.AddVarcharParam(DB_COL_NOMBRE, p.Nombre);
return(operation);
}
public SqlOperation GetCitasSucursalStatament(BaseEntity entity)
{
var c = (Cita)entity;
var operacion = new SqlOperation {
ProcedureName = "OBTENER_CITA_SUCURSAL"
};
operacion.AddDateParam(DB_COL_FECHA, c.fecha);
operacion.AddIntParam(DB_COL_ID_SUCURSAL, c.id_sucursal);
return(operacion);
}
public SqlOperation UpdateEstadoTarjeta(BaseEntity entity)
{
var tarjeta = (Tarjeta)entity;
var operation = new SqlOperation {
ProcedureName = "UPD_TARJETA_ESTADO_PR"
};
operation.AddVarcharParam(DB_COL_CODIGO_UNICO, tarjeta.CodigoUnico);
operation.AddIntParam(DB_COL_ESTADO_TARJETA_ID, tarjeta.EstadoTarjeta.EstadoTarjetaId);
return(operation);
}
public SqlOperation GetRetrieveStatement(Entity entity)
{
var operation = new SqlOperation {
ProcedureName = "RET_CARRITO_PR"
};
var c = (Carrito)entity;
operation.AddIntParam(DB_COL_ID_CARRITO, c.IdCarrito);
return(operation);
}
public SqlOperation GetUpdateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "MODIFICAR_MULTA"
};
var c = (Multa)entity;
operation.AddIntParam(DB_COL_ID, c.id);
return(operation);
}
public SqlOperation GetRetriveStatement(BaseEntity entity)
{
var operacion = new SqlOperation {
ProcedureName = "OBTENER_CITA"
};
var c = (Cita)entity;
operacion.AddIntParam(DB_COL_ID, c.id);
return(operacion);
}
public SqlOperation GetUpdateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "UPD_USUARIO_PR"
};
var u = (Usuario)entity;
operation.AddVarcharParam(DB_COL_CEDULA, u.cedula);
operation.AddVarcharParam(DB_COL_NOMBRE, u.nombre);
operation.AddVarcharParam(DB_COL_PRIMERAPELLIDO, u.apellido1);
operation.AddVarcharParam(DB_COL_SEGUNDOAPELLIDO, u.apellido2);
operation.AddDatetimeParam(DB_COL_FECHANACIMIENTO, u.dob);
operation.AddVarcharParam(DB_COL_CORREOUSUARIO, u.correoUsuario);
operation.AddVarcharParam(DB_COL_CONTRASENA, u.contrasena);
operation.AddIntParam(DB_COL_TELEFONO, u.telefono);
operation.AddVarcharParam(DB_COL_ESTADOUSUARIO, u.estadoUsuario);
operation.AddIntParam(DB_COL_IDROL, u.idRol);
return(operation);
}
public SqlOperation GetCitasEmpleadoStatament(BaseEntity entity)
{
var c = (Cita)entity;
var operacion = new SqlOperation {
ProcedureName = "OBTENER_CITA_EMPLEADO"
};
operacion.AddDateParam(DB_COL_FECHA, c.fecha);
operacion.AddIntParam(DB_COL_ID_EMPLEADO, c.id_empleado);
return(operacion);
}
public SqlOperation GetUpdateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "MODIFICAR_ITEM"
};
var c = (Item)entity;
operation.AddIntParam(DB_COL_ID, c.id);
operation.AddVarcharParam(DB_COL_NOMBRE, c.nombre);
operation.AddVarcharParam(DB_COL_DESCRIPCION, c.descripcion);
operation.AddDoubleParam(DB_COL_PRECIO, c.precio);
operation.AddVarcharParam(DB_COL_TIPO, c.tipo);
operation.AddIntParam(DB_COL_INVENTARIO, c.inventario);
operation.AddIntParam(DB_COL_DURACION, c.duracion);
operation.AddIntParam(DB_COL_ID_SUCURSAL, c.id_sucursal);
operation.AddIntParam(DB_COL_ID_IMPUESTO, c.id_impuesto);
operation.AddVarcharParam(DB_COL_ID_FOTO, c.id_foto);
return(operation);
}
