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