public SqlOperation GetRetriveStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "RET_PROYECTO_PR"
};
var pro = (Proyecto)entity;
operation.AddStringParam(DB_COL_IDENTIFICACION_USUARIO, pro.IdUsuario);
operation.AddStringParam(DB_COL_NOMBRE, pro.Nombre);
return(operation);
}
public SqlOperation GetUpdateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "UPD_IDIOMA_PR"
};
var c = (Idiomas)entity;
operation.AddStringParam(DB_COL_NOMBRE_IDIOMA, c.NOMBRE_IDIOMA);
operation.AddStringParam(DB_COL_PAIS_ORIGEN, c.PAIS_ORIGEN);
return(operation);
}
public SqlOperation GetRetrivePalabraIdiomStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "RET_PALABRA_EN_IDIOMA_PR"
};
var c = (Palabras)entity;
operation.AddStringParam(DB_COL_PALABRA_PRIMER_REGISTRO, c.PALABRA);
operation.AddStringParam(DB_COL_NOMBRE_IDIOMA, c.NOMBRE_IDIOMA);
return(operation);
}
public SqlOperation GetUpdateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "UPD_CLIENTE_PR"
};
var c = (Cliente)entity;
operation.AddStringParam(DB_COL_IDENTIFICACION_CLIENTE, c.identificacion);
operation.AddStringParam(DB_COL_NOMBRE, c.nombre);
operation.AddStringParam(DB_COL_DIRECCION, c.direccion);
return(operation);
}
public SqlOperation GetUpdateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "UPD_CASO_PR"
};
var c = (CasoDeUso)entity;
operation.AddStringParam(DB_COL_CODIGO, c.CODIGO);
operation.AddStringParam(DB_COL_NOMBRE, c.NOMBRE);
operation.AddStringParam(DB_COL_DESCRIPCION, c.DESCRIPCION);
return(operation);
}
public SqlOperation GetUpdateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "UPD_CONSULTA_PALABRA_PR"
};
var c = (ConsultasPalabras)entity;
operation.AddIntParam(DB_COL_CODIGO_REGISTRO, c.CODIGO_REGISTRO);
operation.AddStringParam(DB_COL_CODIGO_CONSULTA, c.CODIGO_CONSULTA);
operation.AddStringParam(DB_COL_PALABRA, c.PALABRA);
return(operation);
}
internal SqlOperation GetCreatePrimeraPalabraStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "CRE_PRIMERA_PALABRA_PR"
};
var c = (Palabras)entity;
operation.AddStringParam(DB_COL_PALABRA_PRIMER_REGISTRO, c.PALABRA_PRIMER_REGISTRO);
operation.AddStringParam(DB_COL_NOMBRE_IDIOMA, c.NOMBRE_IDIOMA);
operation.AddStringParam(DB_COL_TIPO, c.TIPO);
return(operation);
}
public SqlOperation GetUpdateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "UPD_USUARIO_PR"
};
var c = (Usuarios)entity;
operation.AddIntParam(DB_COL_CEDULA, c.CEDULA);
operation.AddStringParam(DB_COL_NOMBRE, c.NOMBRE);
operation.AddStringParam(DB_COL_APELLIDO, c.APELLIDO);
operation.AddStringParam(DB_COL_NOMBRE_USUARIO, c.NOMBRE_USUARIO);
return(operation);
}
public SqlOperation GetUpdateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "UPD_Palabra_PR"
};
var c = (Palabras)entity;
operation.AddStringParam(DB_COL_PALABRA, c.PALABRA);
operation.AddStringParam(DB_COL_NOMBRE_IDIOMA, c.NOMBRE_IDIOMA);
operation.AddStringParam(DB_COL_PALABRA_PRIMER_REGISTRO, c.PALABRA_PRIMER_REGISTRO);
operation.AddStringParam(DB_COL_TIPO, c.TIPO);
return(operation);
}
public SqlOperation GetCreateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "CRE_CLIENTE_PR"
};
var c = (Contacto)entity;
operation.AddIntParam(DB_COL_ID_CONTACTO, c.identificacion);
operation.AddStringParam(DB_COL_NOMBRE, c.nombre);
operation.AddStringParam(DB_COL_TELEFONO, c.numeroTelefonico);
operation.AddStringParam(DB_COL_CORREO_ELECTRONICO, c.correo);
return(operation);
}
public SqlOperation GetUpdateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "UPD_USER_PR"
};
var nObj = (User)entity;
operation.AddStringParam(DB_COL_IDENTIFICACION, nObj.Id);
operation.AddStringParam(DB_COL_NOMBRE, nObj.Name);
operation.AddStringParam(DB_COL_APELLIDO, nObj.LastName);
operation.AddStringParam(DB_COL_PASSWORD, nObj.Password);
operation.AddStringParam(DB_COL_CORREO_ELECTRONICO, nObj.Email);
return(operation);
}
public SqlOperation GetUpdateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "UPD_PROYECTO_PR"
};
var pro = (Proyecto)entity;
operation.AddIntParam(DB_COL_ID_PROYECTO, pro.IdProyecto);
operation.AddStringParam(DB_COL_NOMBRE, pro.Nombre);
operation.AddStringParam(DB_COL_INDUSTRIA, pro.Industria);
operation.AddStringParam(DB_COL_DESCRIPCION, pro.Descripcion);
operation.AddStringParam(DB_COL_FECHA_FINAL, pro.FechaFinal);
return(operation);
}
public SqlOperation GetCreateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "CREATE_REQUERIMIENTO_PR"
};
var c = (Requerimientos)entity;
//operation.AddIntParam(DB_COL_ID_REQUERIMIENTO, c.ID_REQUERIMIENTO);
operation.AddStringParam(DB_COL_CODIGO, c.CODIGO);
operation.AddDoubleParam(DB_COL_PRIORIDAD, c.PRIORIDAD);
operation.AddStringParam(DB_COL_DESCRIPCION, c.DESCRIPCION);
operation.AddIntParam(DB_COL_ID_PROYECTO, c.ID_PROYECTO);
operation.AddBooleanParam(DB_COL_ESTADO, c.ESTADO);
return(operation);
}
public SqlOperation GetCreateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "CREATE_CASO_PR"
};
var c = (CasoDeUso)entity;
operation.AddStringParam(DB_COL_CODIGO, c.CODIGO);
operation.AddIntParam(DB_COL_ID_PROYECTO, c.ID_PROYECTO);
operation.AddFloatParam(DB_COL_PRIORIDAD, c.PRIORIDAD);
operation.AddStringParam(DB_COL_NOMBRE, c.NOMBRE);
operation.AddStringParam(DB_COL_DESCRIPCION, c.DESCRIPCION);
return(operation);
}
public SqlOperation GetRetriveAllProyectosUsuarioStatement(string identificacion)
{
var operation = new SqlOperation {
ProcedureName = "RET_PROYECTOS_USUARIO_PR"
};
operation.AddStringParam(DB_COL_IDENTIFICACION_USUARIO, identificacion);
return(operation);
}
public SqlOperation GetUpdateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "UPD_CONSULTA_FRASES_PR"
};
var c = (ConsultasFrases)entity;
operation.AddStringParam(DB_COL_CODIGO_CONSULTA, c.CODIGO_CONSULTA);
operation.AddIntParam(DB_COL_NOMBRE_CEDULA, c.CEDULA);
operation.AddStringParam(DB_COL_FRASE, c.FRASE);
operation.AddStringParam(DB_COL_TRADUCCION_ESPANOL, c.TRADUCCION_ESPANOL);
operation.AddIntParam(DB_COL_CANTIDAD_PALABRAS, c.CANTIDAD_PALABRAS);
operation.AddStringParam(DB_COL_FECHA_CONSULTA, c.FECHA_CONSULTA);
operation.AddIntParam(DB_COL_POPULARIDAD, c.POPULARIDAD);
return(operation);
}
public SqlOperation GetRetriveStatementByUser(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "RET_USER_USER_NAME_PR"
};
var nObj = (User)entity;
operation.AddStringParam(DB_COL_NOMBRE_USUARIO, nObj.UserName);
return(operation);
}
public SqlOperation GetDeleteStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "DEL_IDIOMA_PR"
};
var c = (Idiomas)entity;
operation.AddStringParam(DB_COL_NOMBRE_IDIOMA, c.NOMBRE_IDIOMA);
return(operation);
}
public SqlOperation GetDeleteStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "DEL_USER_PR"
};
var nObj = (User)entity;
operation.AddStringParam(DB_COL_NOMBRE_USUARIO, nObj.UserName);
return(operation);
}
public SqlOperation GetRetriveStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "RET_USER_PR"
};
var nObj = (User)entity;
operation.AddStringParam(DB_COL_IDENTIFICACION, nObj.Id);
return(operation);
}
public SqlOperation GetDeleteStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "DEL_CASO_PR"
};
var c = (CasoDeUso)entity;
operation.AddStringParam(DB_COL_CODIGO, c.CODIGO);
return(operation);
}
public SqlOperation GetDeleteStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "DEL_CASO_PR"
};
var c = (Cliente)entity;
operation.AddStringParam(DB_COL_IDENTIFICACION_CLIENTE, c.identificacion);
return(operation);
}
public SqlOperation GetDeleteStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "DEL_Palabra_PR"
};
var c = (Palabras)entity;
operation.AddStringParam(DB_COL_PALABRA, c.PALABRA);
return(operation);
}
public SqlOperation GetDeleteStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "DEL_CONSULTA_FRASES_PR"
};
var c = (ConsultasFrases)entity;
operation.AddStringParam(DB_COL_CODIGO_CONSULTA, c.CODIGO_CONSULTA);;
return(operation);
}
public SqlOperation GetDeleteStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "DEL_REQUERIMIENTO_PR"
};
var c = (Requerimientos)entity;
operation.AddStringParam(DB_COL_CODIGO, c.CODIGO);
return(operation);
}
public SqlOperation GetRetriveStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "RET_USUARIO_PR"
};
var c = (Usuarios)entity;
operation.AddStringParam(DB_COL_NOMBRE_USUARIO, c.NOMBRE_USUARIO);
return(operation);
}
public SqlOperation GetCreateStatement(BaseEntity entity)
{
var operation = new SqlOperation {
ProcedureName = "CRE_PROYECTO_PR"
};
var pro = (Proyecto)entity;
operation.AddStringParam(DB_COL_IDENTIFICACION_USUARIO, pro.IdUsuario);
operation.AddStringParam(DB_COL_ID_CLIENTE, pro.IdCliente);
operation.AddStringParam(DB_COL_NOMBRE, pro.Nombre);
operation.AddStringParam(DB_COL_INDUSTRIA, pro.Industria);
operation.AddStringParam(DB_COL_DESCRIPCION, pro.Descripcion);
operation.AddStringParam(DB_COL_FECHA_INICIO, pro.FechaInicio);
operation.AddStringParam(DB_COL_FECHA_FINAL, pro.FechaFinal);
return(operation);
}
