public SqlOperation GetUpdateStatement(BaseEntity entity)
{
var e = (Empleado)entity;
SqlOperation op = new SqlOperation {
ProcedureName = "UPD_EMPLEADO_PR"
};
op.AddVarcharParam(DB_COL_CODIGO_TIENDA, e.ID_TIENDA);
op.AddVarcharParam(DB_COL_IDENTIFICACION, e.IDENTIFICACION);
op.AddVarcharParam(DB_COL_PRIMER_NOMBRE, e.PRIMER_NOMBRE);
op.AddVarcharParam(DB_COL_SEGUNDO_NOMBRE, e.SEGUNDO_NOMBRE);
op.AddVarcharParam(DB_COL_PRIMER_APELLIDO, e.PRIMER_APELLIDO);
op.AddVarcharParam(DB_COL_SEGUNDO_APELLIDO, e.SEGUNDO_APELLIDO);
op.AddVarcharParam(DB_COL_URL_FOTO_ID, e.URL_FOTO_ID);
return(op);
}
public SqlOperation GetUpdateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "UPD_SELLER_PR"
};
var s = (SellerStore)entity;
operation.AddVarcharParam(DB_COL_EMAIL, s.Email);
operation.AddVarcharParam(DB_COL_URL_PHOTO_ID, s.Url_Photo_ID);
operation.AddVarcharParam(DB_COL_NAME_1, s.Name_1);
operation.AddVarcharParam(DB_COL_NAME_2, s.Name_2);
operation.AddVarcharParam(DB_COL_LAST_NAME_1, s.Last_Name_1);
operation.AddVarcharParam(DB_COL_LAST_NAME_2, s.Last_Name_2);
operation.AddVarcharParam(DB_COL_PHONE_1, s.Phone_1);
operation.AddVarcharParam(DB_COL_PHONE_2, s.Phone_2);
//operation.AddIntParam(DB_COL_ID_ADDRESS, s.ID_Address);
operation.AddVarcharParam(DB_COL_URL_PROFILE_PRIC, s.Url_Profile_Pric);
//operation.AddVarcharParam(DB_COL_ID_STORE, s.ID_STORE);
//operation.AddBoolParam(DB_COL_ACTIVE, s.ACTIVE);
return(operation);
}
public SqlOperation GetCreateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "CreateExitRamp"
};
var be = (ExitRamp)entity;
operation.AddVarcharParam(DB_COL_NAME, be.Name);
operation.AddIntParam(DB_COL_ID_TERMINAL, be.Terminal.IdTerminal);
if (be.Route?.IdRoute > 0)
{
operation.AddIntParam(DB_COL_ID_ROUTE, be.Route.IdRoute);
}
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 GetUpdateStatement(BaseEntity entity)
{
var Operation = new SqlOperation {
ProcedureName = "UpdateRoute"
};
var C = (Route)entity;
Operation.AddIntParam(IDROUTE, C.IdRoute);
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 = "UpdateSanction"
};
var C = (Sanction)entity;
Operation.AddVarcharParam(DESCRIPTION, C.Description);
Operation.AddIntParam(IDROUTE, C.Route.IdRoute);
Operation.AddIntParam(IDTERMINAL, C.Terminal.IdTerminal);
Operation.AddIntParam(IDSANCTIONTYPE, C.Type.IdType);
Operation.AddIntParam(IDCOMPANY, C.Company.IdCompany);
Operation.AddDateParam(DATE, DateTime.Now);
Operation.AddIntParam(IDSANCTION, C.IdSanction);
return(Operation);
}
public SqlOperation GetCreateStatement(BaseEntity entity)
{
var Operation = new SqlOperation {
ProcedureName = "CreateComplaint"
};
var C = (Complaint)entity;
Operation.AddVarcharParam(DESCRIPTION, C.Description);
Operation.AddIntParam(IDBUS, C.Bus.IdBus);
Operation.AddIntParam(IDTERMINAL, C.Terminal.IdTerminal);
Operation.AddIntParam(IDDRIVER, C.Driver.CardNumber);
Operation.AddIntParam(IDUSER, C.User.IdUser);
Operation.AddDateParam(DATE, DateTime.Now);
Operation.AddIntParam(IDCOMPANY, C.Company.IdCompany);
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 GetCreateStatement(EntidadBase entidad)
{
var operation = new SqlOperation {
ProcedureName = "CRE_HISTORIALVIAJE_PR"
};
var i = (HistorialViajes)entidad;
operation.AddVarcharParam(DB_COL_LINEA, i.Linea);
operation.AddVarcharParam(DB_COL_TREN, i.Tren);
operation.AddVarcharParam(DB_COL_ESTACION_ANTERIOR, i.EstacionAnterior);
operation.AddVarcharParam(DB_COL_ESTACION_SIGUIENTE, i.EstacionSiguiente);
operation.AddVarcharParam(DB_COL_TIEMPO_ESTIMADO, i.TiempoEstimado);
operation.AddVarcharParam(DB_COL_ACCION, i.Accion);
operation.AddVarcharParam(DB_COL_FECHA, i.Fecha);
return(operation);
}
public SqlOperation GetCreateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "SP_CREATEFLIGHT"
};
var a = (Flight)entity;
operation.AddVarcharParam(DB_COL_ID, a.Id);
operation.AddVarcharParam(DB_COL_AIRLINE_ID, a.Airline_Id);
operation.AddVarcharParam(DB_COL_ORIGIN_AIRPORT, a.Origin_Airport_Id);
operation.AddVarcharParam(DB_COL_DESTINY_AIRPORT, a.Destiny_Airport_Id);
operation.AddDateParam(DB_COL_DEPARTURE_TIME, a.Departure_Time);
operation.AddDateParam(DB_COL_ARRIVAL_TIME, a.Arrival_DateTime);
operation.AddVarcharParam(DB_COL_STATUS, a.Status);
operation.AddVarcharParam(DB_COL_ID_AIRPLANE, a.Id_Airplane);
operation.AddVarcharParam(DB_COL_ID_GATE, a.Id_Gate);
return(operation);
}
public SqlOperation GetUpdateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "CRE_Direcciones"
};
var d = (Direccion)entity;
operation.AddVarcharParam(BD_COL_Provincia, d.Provincia);
operation.AddVarcharParam(BD_COL_Canton, d.Canton);
operation.AddVarcharParam(BD_COL_Distrito, d.Distrito);
operation.AddVarcharParam(BD_COL_Senas, d.Senas);
operation.AddVarcharParam(BD_COL_Tipo, d.Tipo);
operation.AddVarcharParam(BD_COL_CedulaCliente, d.CedulaCliente);
return(operation);
}
public SqlOperation GetCreateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "CRE_STORE_ADMINISTRATOR_PR"
};
var storeAdmin = (StoreAdministrator)entity;
operation.AddVarcharParam(DB_COL_NAME, storeAdmin.Name);
operation.AddVarcharParam(DB_COL_LAST_NAME1, storeAdmin.FirstLastName);
operation.AddVarcharParam(DB_COL_LAST_NAME2, storeAdmin.SecondLastName);
operation.AddVarcharParam(DB_COL_EMAIL, storeAdmin.Email);
operation.AddVarcharParam(DB_COL_PASSWORD, storeAdmin.Password);
operation.AddVarcharParam(DB_COL_STORE, storeAdmin.Store);
return(operation);
}
public SqlOperation GetUpdateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "SP_UPDATEAIRLINE"
};
var a = (Airline)entity;
operation.AddVarcharParam(DB_COL_ID, a.Id);
operation.AddVarcharParam(DB_COL_COMERCIAL_NAME, a.Comercial_name);
operation.AddVarcharParam(DB_COL_BUSINESS_NAME, a.Business_name);
operation.AddDateParam(DB_COL_CREATION_YEAR, a.Creation_year);
operation.AddVarcharParam(DB_COL_DESCRIPTION, a.Description);
operation.AddVarcharParam(DB_COL_EMAIL, a.Email);
operation.AddIntParam(DB_COL_STATUS, a.Status ? 1 : 0);
operation.AddVarcharParam(DB_COL_REQUEST, a.Request);
return(operation);
}
public SqlOperation GetUpdateStatement(EntidadBase entidad)
{
var operation = new SqlOperation {
ProcedureName = "UPD_EMPRESA_PR"
};
var c = (Empresa)entidad;
operation.AddVarcharParam(DB_COL_CED_JURIDICA, c.Cedula);
operation.AddVarcharParam(DB_COL_NOMBRE, c.Nombre);
operation.AddVarcharParam(DB_COL_DIRRECCION, c.Direccion);
operation.AddVarcharParam(DB_COL_TELEFONO, c.Telefono);
operation.AddVarcharParam(DB_COL_CORREO, c.Correo);
operation.AddVarcharParam(DB_COL_IMPUESTO, c.Impuesto);
return(operation);
}
public SqlOperation GetUpdateStatementNoFrecuente(EntidadBase entidad)
{
var operation = new SqlOperation {
ProcedureName = "UPD_CLIENTE_NO_FRECUENTE_PR"
};
var u = (Cliente)entidad;
operation.AddVarcharParam(DB_COL_CEDULA, u.Cedula);
operation.AddVarcharParam(DB_COL_NOMBRE, u.Nombre);
operation.AddVarcharParam(DB_COL_APELLIDO, u.Apellido);
operation.AddVarcharParam(DB_COL_CORREO, u.Correo);
operation.AddVarcharParam(DB_COL_TELEFONO, u.Telefono);
operation.AddVarcharParam(DB_COL_RESIDENCIA, u.Residencia);
return(operation);
}
public SqlOperation GetUpdateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "UPD_DIRECTION_PR"
};
var d = (Direction)entity;
operation.AddVarcharParam(DB_COL_PROVINCE, d.Province);
operation.AddVarcharParam(DB_COL_CANTON, d.Canton);
operation.AddVarcharParam(DB_COL_DISTRITO, d.Distrito);
operation.AddVarcharParam(DB_COL_DETAILS, d.Details);
operation.AddVarcharParam(DB_COL_TYPE, d.Type);
operation.AddVarcharParam(DB_COL_OWNER_ID, d.OwnerId);
return(operation);
}
public SqlOperation GetUpdateStatement(Entity entity)
{
var operation = new SqlOperation {
ProcedureName = "UPD_SERVICIO_PR"
};
var s = (Servicio)entity;
operation.AddVarcharParam(DB_COL_CODIGO, s.Codigo);
operation.AddVarcharParam(DB_COL_NOMBRE, s.Nombre);
operation.AddVarcharParam(DB_COL_DESCRIPCION, s.Descripcion);
operation.AddVarcharParam(DB_COL_ESTADO, s.Estado);
operation.AddVarcharParam(DB_COL_FOTO_PERFIL, s.FotoPerfil);
operation.AddVarcharParam(DB_COL_ID_HOTEL, s.IdHotel);
return(operation);
}
public SqlOperation GetUpdateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "UPD_STORE_ADMINISTRATOR_PR"
};
var storeAdmin = (StoreAdministrator)entity;
operation.AddVarcharParam(DB_COL_NAME, storeAdmin.Name_1);
operation.AddVarcharParam(DB_COL_LAST_NAME1, storeAdmin.Last_Name1);
operation.AddVarcharParam(DB_COL_LAST_NAME2, storeAdmin.Last_Name2);
operation.AddVarcharParam(DB_COL_EMAIL, storeAdmin.Email);
operation.AddVarcharParam(DB_COL_ID, storeAdmin.Id);
operation.AddVarcharParam(DB_COL_PHONE, storeAdmin.Phone_1);
return(operation);
}
public SqlOperation GetCreateStatement(BaseEntity entity)
{
var operation = new SqlOperation()
{
ProcedureName = "CRUD_ENTIDAD"
};
var entidad = (Entidad)entity;
operation.Parameters = new List <SqlParameter>();
operation.AddVarcharParam(DbColIdEntidad, entidad.IdEntidad);
operation.AddVarcharParam(DbColNombreEntidad, entidad.NombreEntidad);
operation.AddVarcharParam(DbColTipoEntidad, entidad.TipoEntidad);
operation.AddVarcharParam(DbColNombreComercialEntidad, entidad.NombreComercialEntidad);
operation.AddVarcharParam(DbColDireccionEntidad, entidad.DireccionEntidad);
operation.AddVarcharParam(DbColTelefonoEntidad, entidad.TelefonoEntidad);
operation.AddByteParam(DbColLogoEntidad, ConvertImageToByteArray(entidad.LogoEntidad));
operation.AddVarcharParam(DbColCorreoEntidad, entidad.CorreoEntidad);
operation.AddIntParam(DbCrudAction, (int)CrudActionEnum.Create);
return(operation);
}
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 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 GetUpdateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "UPD_CUSTOMER_PR"
};
var c = (Customer)entity;
operation.AddVarcharParam(DB_COL_ID, c.Id);
operation.AddVarcharParam(DB_COL_NAME, c.Name);
operation.AddVarcharParam(DB_COL_LAST_NAME, c.LastName);
operation.AddVarcharParam(DB_COL_BIRTHDAY, c.Birthday);
operation.AddIntParam(DB_COL_AGE, c.Age);
operation.AddVarcharParam(DB_COL_SOCIALSTATUS, c.SocialStatus);
operation.AddVarcharParam(DB_COL_GENDER, c.Gender);
return(operation);
}
public SqlOperation GetCreateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "CRE_CLIENTE_PR"
};
var c = (Cliente)entity;
operation.AddVarcharParam(DB_COL_cedula, c.cedula);
operation.AddVarcharParam(DB_COL_nombre, c.nombre);
operation.AddVarcharParam(DB_COL_apellido, c.apellido);
operation.AddVarcharParam(DB_COL_fechaNacimiento, c.fechaNacimiento);
operation.AddIntParam(DB_COL_edad, c.edad);
operation.AddVarcharParam(DB_COL_estadoCivil, c.estadoCivil);
operation.AddVarcharParam(DB_COL_genero, c.genero);
return(operation);
}
public SqlOperation GetUpdateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "UPD_PRODUCT_MEDIA_PR"
};
var productMedia = (ProductMedia)entity;
operation.AddIntParam(DB_COL_ID, productMedia.Id);
operation.AddVarcharParam(DB_COL_IMAGE_1, productMedia.Image1);
operation.AddVarcharParam(DB_COL_IMAGE_2, productMedia.Image2);
operation.AddVarcharParam(DB_COL_IMAGE_3, productMedia.Image3);
operation.AddVarcharParam(DB_COL_IMAGE_4, productMedia.Image4);
operation.AddVarcharParam(DB_COL_IMAGE_5, productMedia.Image5);
operation.AddVarcharParam(DB_COL_VIDEO, productMedia.Video);
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 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 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_CUSTOMER_PR"
};
var c = (Customer)entity;
operation.AddVarcharParam(DB_COL_ID, c.Id);
operation.AddVarcharParam(DB_COL_NAME, c.Name);
operation.AddVarcharParam(DB_COL_LAST_NAME, c.LastName);
operation.AddVarcharParam(DB_COL_BIRTH_DATE, Convert.ToString(c.BirthDate));
operation.AddIntParam(DB_COL_AGE, c.Age);
operation.AddVarcharParam(DB_COL_CIVIL_STATUS, Convert.ToString(c.CivilStatus));
operation.AddVarcharParam(DB_COL_GENDER, Convert.ToString(c.Gender));
return(operation);
}
public SqlOperation GetCreateStatement(EntidadBase entidad)
{
var operation = new SqlOperation {
ProcedureName = "CRE_CLIENTE_PR"
};
var u = (Cliente)entidad;
operation.AddVarcharParam(DB_COL_CEDULA, u.Cedula);
operation.AddVarcharParam(DB_COL_NOMBRE, u.Nombre);
operation.AddIntParam(DB_COL_EDAD, u.Edad);
operation.AddVarcharParam(DB_COL_CORREO, u.Correo);
operation.AddVarcharParam(DB_COL_CLAVE, u.Clave);
operation.AddVarcharParam(DB_COL_TELEFONO, u.Telefono);
operation.AddVarcharParam(DB_COL_RESIDENCIA, u.Residencia);
return(operation);
}
public SqlOperation GetUpdateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "UPD_CLIENTE_PR"
};
var c = (Customer)entity;
operation.AddVarcharParam(DB_COL_CEDULA, c.Cedula);
operation.AddVarcharParam(DB_COL_NOMBRE, c.Nombre);
operation.AddVarcharParam(DB_COL_APELLIDO, c.Apellido);
operation.AddVarcharParam(DB_COL_GENERO, c.Genero);
operation.AddVarcharParam(DB_COL_EST_CIVIL, c.EstadoCivil);
operation.AddVarcharParam(DB_COL_FEC_NAC, c.FechaNacimiento);
operation.AddIntParam(DB_COL_AGE, c.Edad);
return(operation);
}