Exemplo n.º 1
0
        public SqlOperation GetUpdateStatement(BaseEntity entity)
        {
            var operation = new SqlOperation {
                ProcedureName = "UPD_LOCATION_PR"
            };

            var location = (Location)entity;

            operation.AddIntParam(DB_COL_ID, location.Id);
            operation.AddVarcharParam(DB_COL_NAME, location.Name);
            operation.AddFloatParam(DB_COL_LATITUDE, location.Latitude);
            operation.AddFloatParam(DB_COL_LONGITUDE, location.Longitude);
            return(operation);
        }
Exemplo n.º 2
0
        public SqlOperation GetCreateStatement(BaseEntity entity)
        {
            var operation = new SqlOperation {
                ProcedureName = "CRE_LOCATION_PR"
            };

            var c = (Location)entity;

            operation.AddVarcharParam(DB_COL_NAME, c.Name);
            operation.AddFloatParam(DB_COL_LATITUDE, c.Latitude);
            operation.AddFloatParam(DB_COL_LONGITUDE, c.Longitude);

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